Intermediate Course book available

Power BI & Dashboard Development

Model data, write DAX measures and publish dashboards that leadership teams use every week.

4 modules · 9 lessons · about 5 hours of guided content

About this course

Learn the full Power BI workflow: connect and transform data, design a star-schema model, write DAX measures, and design reports that answer specific management questions. Examples cover sales, programme monitoring and service delivery.

What you'll achieve

Build a clean star-schema model from several source tables
Write DAX measures for totals, ratios, time intelligence and targets
Design report pages around decisions rather than visuals
Publish, schedule refresh and manage access

What you'll deliver

Programme monitoring dashboard
Certificate of completion

Prerequisites

• Comfortable with Excel tables and PivotTables

Library for this course(2 items)

Curriculum

Module 1
Getting data in shapePower Query for BI. · 2 lessons
- Connecting to Excel, CSV and databasesTypical sources in organizations.30 min
- Shaping data in Power QueryTypes, merges and appends.35 min
Module 2
ModellingRelationships and the star schema. · 2 lessons
- Facts, dimensions and relationshipsWhy the model matters more than the visuals.35 min
- Date tablesThe foundation for time intelligence.25 min
Module 3
DAX measuresCalculations that answer questions. · 3 lessons · quiz
- Measures vs calculated columnsWhen to use each, and why it matters for performance.Free sample30 min
- CALCULATE and filter contextThe most important idea in DAX.45 min
- Time intelligenceYear-to-date, previous period and growth.35 min
- Quiz: DAX essentials · 2 questions · pass mark 70%
Module 4
Designing and publishingFrom report to decisions. · 2 lessons · assignment
- Designing a KPI pageHierarchy, colour and annotation.40 min
- Publishing and refreshWorkspaces, sharing and scheduled refresh.30 min
- Assignment: Programme monitoring dashboard

Certificate requirements

• Complete every lesson
• Score at least 70% on every module quiz
• Hold an active enrollment

Certificates confirm completion of BDIM training. They are not an academic qualification or professional accreditation.

Request a quote

Tell us whether you are an individual learner, a group or an organization, and your preferred format. Pricing is negotiable.

Curriculum

Module 1

Getting data in shapePower Query for BI. · 2 lessons

Connecting to Excel, CSV and databasesTypical sources in organizations.30 min
Shaping data in Power QueryTypes, merges and appends.35 min

Module 2

ModellingRelationships and the star schema. · 2 lessons

Facts, dimensions and relationshipsWhy the model matters more than the visuals.35 min
Date tablesThe foundation for time intelligence.25 min

Module 3

DAX measuresCalculations that answer questions. · 3 lessons · quiz

Measures vs calculated columnsWhen to use each, and why it matters for performance.Free sample30 min
CALCULATE and filter contextThe most important idea in DAX.45 min
Time intelligenceYear-to-date, previous period and growth.35 min
Quiz: DAX essentials · 2 questions · pass mark 70%

Module 4

Designing and publishingFrom report to decisions. · 2 lessons · assignment

Designing a KPI pageHierarchy, colour and annotation.40 min
Publishing and refreshWorkspaces, sharing and scheduled refresh.30 min
Assignment: Programme monitoring dashboard

Request a quote

Tell us whether you are an individual learner, a group or an organization, and your preferred format. Pricing is negotiable.