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
- Introduction to Power BI Desktop and the Power BI Service
- Key concepts explained: reports, datasets, and dashboards
- Reviewing available data connectivity options
Data Connection and Preparation
- Importing data from Excel, CSV files, and cloud platforms
- Performing basic data transformations using the Power Query Editor
- Refining and structuring data for visual analysis
Crafting Effective Visuals
- Selecting appropriate chart types for specific data sets
- Building tables, cards, and KPI displays
- Implementing slicers and filters to enhance interactivity
Constructing Interactive Dashboards
- Assembling visuals into unified, cohesive dashboards
- Applying themes, layouts, and design best practices
- Incorporating drill-through and cross-filter interactions
Publishing and Distributing Reports
- Storing and publishing reports to the Power BI Service
- Setting up workspaces and managing access permissions
- Distributing dashboards and embedding reports
Practical Workshop
- Developing a full dashboard from a sample dataset
- Refining visual interactions and filter settings
- Presenting and sharing final results with stakeholders
Conclusion and Future Steps
Requirements
- Familiarity with data handling techniques using spreadsheets
- Practical experience with Microsoft Excel or comparable tools
- Foundational knowledge of business reporting or analytics
Target Audience
- Business analysts
- Operations and administrative personnel
- Professionals aiming to develop high-impact 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
