Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 7 hours
Course Outline
Introduction to Power BI
- Overview of Power BI Desktop and Power BI Service
- Understanding key elements: reports, datasets, and dashboards
- Reviewing available data connectivity options
Data Connection and Preparation
- Importing data from Excel, CSV files, and cloud services
- Performing basic data transformations using the Power Query Editor
- Cleaning and shaping data for effective visual analysis
Creating Effective Visuals
- Selecting appropriate chart types for specific data sets
- Building tables, cards, and KPIs
- Implementing slicers and filters to enhance interactivity
Developing Interactive Dashboards
- Integrating visuals into cohesive dashboard layouts
- Applying themes, layouts, and design best practices
- Incorporating drill-through and cross-filter interactions
Publishing and Distributing Reports
- Saving and publishing reports to the Power BI Service
- Setting up workspaces and managing access permissions
- Sharing dashboards and embedding reports in external applications
Practical Workshop
- Constructing a complete dashboard from a sample dataset
- Customizing visual interactions and filter settings
- Presenting and sharing outcomes with key stakeholders
Conclusion and Future Steps
Requirements
- Familiarity with data handling through spreadsheets
- Practical experience with Microsoft Excel or equivalent tools
- Foundational knowledge of business reporting or analytics
Target Audience
- Business analysts
- Operations and administrative personnel
- Professionals aiming to create impactful dashboards and reports
Testimonials (2)
How to use relationships in Power BIand the differences between columns and measurements
LEUNG Chun Hei - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics
engagement with the attendees
