What you will learn

Connect Power BI to real files and clean them in Power Query|Append and merge queries into one reliable table|Build a star schema and the relationships that make it work|Write DAX measures, including CALCULATE and time intelligence|Design a dashboard that answers a business question at a glance|Deliver a solo project and present a team project to a client

Sixteen days that take you from opening Power BI Desktop for the first time to presenting a finished dashboard to a client. You clean, shape, model and measure one real business, Webbo Oil Stations Ltd, live with your tutor, then prove it on your own with PayLink Nigeria and as a team with Jade Hotels & Resorts. Power Query, data modelling, DAX, CALCULATE, time intelligence, visuals and storytelling, with three assignments and two projects.

Lessons

1 Start Here: Syllabus, Datasets and How This Course Works 13 min 2 Day 1: The Power BI Desktop Interface and Getting Data 13 min 3 Day 2: The Power Query Editor and Data Cleaning 13 min 4 Day 3: Data Transformation in Power Query 13 min 5 Day 4 Lab: Cleaning Sales_2023 Together 8 min 6 Assignment 1: Clean Sales_2024 on Your Own 6 min 7 Day 5: Appending and Merging Queries 9 min 8 Day 6 Lab: Append, Merge and Loading to the Model 8 min 9 Day 7: Star Schema and Relationships 9 min 10 Day 8: Calculated Columns vs Measures and DAX Basics 11 min 11 Day 9 Lab: Relationships in Model View and First Measures 7 min 12 Assignment 2: Build the Webbo Oil Star Schema 6 min 13 Day 10: CALCULATE 11 min 14 Day 11 Lab: CALCULATE Together 10 min 15 Solo Project: PayLink Nigeria 10 min 16 Day 12: Time Intelligence 9 min 17 Day 13: Building Visuals 7 min 18 Assignment 3: A One-Page Webbo Oil Dashboard 4 min 19 Day 14 Lab: Time Intelligence and Visuals Together 6 min 20 Pod Project: Jade Hotels & Resorts 11 min 21 Day 15: Slicers, Drill-through and Dashboard Storytelling 8 min 22 Day 16: Pod Presentations 6 min