Power BI Data Analysis & Dashboarding3 Sections21 Lessons3 Days
Curriculum
- 3 Sections
- 21 Lessons
- 3 Days
Expand all sectionsCollapse all sections
- Day 1: Power BI workflow and data connectio7 Items
- 1.1Power BI workflow and data connection.
- 1.2Connect approved data sources and define the business question
- 1.3Related requirements, data inputs and practical judgements for power bi workflow and data connection
- 1.4Data preparation and transformation.
- 1.5Clean types, duplicates and missing values using repeatable transformations
- 1.6Related requirements, data inputs and practical judgements for data preparation and transformation
- 1.7Practical workshop: Complete linked exercises: load a supplied dataset; document preparation decisions.
- Day 2: Data modeling principles and Measures and calculation concepts7 Items
- 2.1Data modeling principles.
- 2.2Create relationships and a clear dimensional structure
- 2.3Related requirements, data inputs and practical judgements for data modeling principles
- 2.4Measures and calculation concepts.
- 2.5Distinguish measures and calculated columns
- 2.6Explore filter context
- 2.7Practical workshop: Complete linked exercises: correct an ambiguous model; build and validate core business measures.
- Day 3: Dashboard design and storytelling and Publishing, sharing and governance7 Items
- 3.1Dashboard design and storytelling.
- 3.2Choose visuals, accessible labels and useful interactions
- 3.3Related requirements, data inputs and practical judgements for dashboard design and storytelling
- 3.4Publishing, sharing and governance.
- 3.5Explain workspace, refresh and access responsibilities
- 3.6Related requirements, data inputs and practical judgements for publishing, sharing and governance
- 3.7Practical workshop: Complete linked exercises: design a management report; prepare a publishing checklist for the agreed licensed environment.

