Power BI dashboards step by step
From installation to a professional dashboard: import, model, visuals, interactions and complete projects on real cases.
Access: an e-mail address is enough, you receive a sign-in code. Free modules need no bank card.
What you will be able to do
- Install Power BI Desktop, import and prepare data in Power Query
- Design a report: mock-up, fact table, reference tables and one-to-many relationships
- Combine visuals, slicers, interactions and conditional formatting
- Give a report a professional finish: canvas, page navigator and bookmarks
- Write DAX measures (SUMX, ALL, CALCULATE, TOTALYTD) and create a date table
- Carry out a complete portfolio project, up to an exposure dashboard
Who it is for
Excel users who want to build interactive dashboards in Power BI Desktop.
Prerequisites
Excel basics. The “Power Query: the fundamentals” course is recommended from the intermediate modules onwards.
Included
- Video with chapters
- PDF slides
- Marked quiz
- Verifiable certificate
Programme
Fundamentals
- 01Installing Power BI Desktop and creating your first report
- 02From raw data to dashboard: queries and model
- 03Designing and then building a report in five stages
Intermediate
- 04Assignment tracking: preparing and visualising activity
- 05Professional report: canvas, navigation and bookmarks
- 06Portfolio project (1/3): importing and preparing the files
Advanced
- 07Portfolio project (2/3): model and DAX measures
- 08Portfolio project (3/3): gauge, alerts and layout
- 09Expert masterclass: “Portfolio Exposure” dashboard
Training a team? Access for several employees, on quotation. admin@axent-consulting.com