The programme
Five units of two hours each. Suggested pace: five meetings or learning sessions of two hours each, over one to two weeks, as the learner's schedule allows.
- Level
- Beginner
- Language
- English
- Suggested pace
- 10 training hours including activities and assessment
- 1
Getting started and preparing the data
- The Power BI Desktop interface and importing a file30 minutes
- Cleaning types and values with Power Query30 minutes
- Application and comprehension check: preparing a data table ready for analysis1 hour
2 hours
- 2
The data model
- Tables, keys and relationships30 minutes
- Avoiding duplication and understanding the effect of filtering30 minutes
- Application and comprehension check: linking a transactions table to a categories table1 hour
2 hours
- 3
Indicators and measures
- The difference between columns and measures30 minutes
- An introduction to SUM, COUNTROWS and DIVIDE30 minutes
- Application and comprehension check: calculating a total, a count and a simple ratio1 hour
2 hours
- 4
Designing the dashboard
- Choosing charts and laying out the page elements30 minutes
- Filters, interaction and indicator titles30 minutes
- Application and comprehension check: building a dashboard page and reviewing its clarity1 hour
2 hours
- 5
The applied project
- Framing business questions and checking the answers30 minutes
- Testing numbers and filters and documenting limitations30 minutes
- Application and comprehension check: submitting the dashboard file and a summary of results1 hour
2 hours