Power BI for Data Reporting
Turn a spreadsheet into a report people actually use. Power BI is Microsoft's free desktop tool for connecting to data, cleaning it, and building interactive dashboards — and it appears by name in job adverts far more often than most tools you can learn in a weekend. By the end you'll be able to load and clean messy data, choose the right chart for a question, write your own calculations, and assemble a working dashboard. Spreadsheet familiarity helps; no programming needed.
Every lesson comes with written notes, a practice task and a knowledge check.
On a limited data plan? Tap the gear icon (⚙️) in the video player and choose 480p or lower — standard-definition video uses a fraction of the data HD does and still looks fine on a phone.
Level 1 — Foundations
What Power BI is for, and getting it running on your own machine.
Module 1 — Getting Started
- Lesson 1 — What Power BI Is Actually For· 8 min· ~56 MB
A clear beginner explanation of what Power BI does and where it fits alongside Excel. Under 8 minutes.
- Explain what Power BI does that a spreadsheet does not
- Name the three stages of the Power BI workflow
- Decide when a problem needs Power BI rather than Excel
- Lesson 2 — Installing and Finding Your Way Around· 5 min· ~38 MB
Microsoft's own short walkthrough of Power BI Desktop — installing it, connecting to your first data source, and what each part of the window does. About 5 minutes.
- Install Power BI Desktop and open your first file
- Identify the Report, Data and Model views and what each is for
- Connect to a spreadsheet and see the data load
Level 2 — Core Skills
The two things you do over and over: clean the data, then show it.
Module 2 — Core Skills in Practice
- Lesson 1 — Cleaning Messy Data with Power Query· 13 min· ~94 MB
A practical walkthrough of Power Query — the part of Power BI that fixes data before it reaches your report. About 13 minutes.
- Open Power Query and apply cleaning steps to a table
- Remove, split and reshape columns without touching the source file
- Explain why recorded steps re-run automatically on new data
- Lesson 2 — Choosing Charts That Answer a Question· 14 min· ~102 MB
A tour of the main Power BI visualisations and what each is good for. About 14 minutes.
- Match a chart type to the question being asked
- Add slicers so readers can filter the report themselves
- Recognise the chart choices that mislead
Level 3 — Working Like a Pro
Your own calculations, and a finished dashboard.
Module 3 — Working Like a Pro
- Lesson 1 — Writing Your Own Calculations with DAX· 37 min· ~270 MB
A thorough tutorial on DAX, the formula language behind Power BI measures. About 37 minutes, so watch it in parts — the first section covers what you need to start.
- Write a basic measure using SUM, COUNT and AVERAGE
- Explain the difference between a measure and a calculated column
- Use CALCULATE to answer a filtered question
- Lesson 2 — Building a Complete Dashboard· 23 min· ~166 MB
A full beginner walkthrough building a working dashboard from raw data to finished report. About 23 minutes.
- Assemble cleaned data, measures and visuals into one dashboard
- Lay out a report so the most important number is seen first
- Produce something you can show an employer or client
Spin for a discount
One spin, one discount on this Learning Path.
Reviews
No reviews yet.