Power BI Dashboards & Reporting
Overview
Power BI turns raw data into interactive dashboards and reports that managers can explore themselves. This hands-on course takes participants from importing and shaping data to building data models, writing basic DAX measures, designing clear dashboards and sharing reports securely.
Who should attend
Analysts, reporting staff, finance and HR professionals, and managers who prepare regular reports.
Training methodology
Interactive presentations, practical exercises, case studies, group discussions, role-plays where relevant, and a personal action plan that participants apply in their own work.
Objectives
By the end of this course, participants will be able to:
- Import and transform data with Power Query
- Build relationships and data models
- Create calculated measures with DAX
- Design clear, interactive dashboards
- Publish, share and refresh reports
Course outline
Day 1Getting Started
- Power BI components
- Connecting to data
- The report interface
- First visuals
- Hands-on lab
Day 2Shaping Data
- Power Query basics
- Cleaning and transforming
- Merging and appending
- Date tables
- Hands-on lab
Day 3Data Modelling
- Star schema
- Relationships
- Calculated columns
- Model best practice
- Hands-on lab
Day 4DAX Measures
- DAX fundamentals
- Aggregations and filters
- Time intelligence
- Common KPIs
- Hands-on lab
Day 5Dashboards and Sharing
- Dashboard design principles
- Interactivity and drill-down
- Publishing and workspaces
- Security and refresh
- Final project
