SkillPath Africa
Beginner

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.

6 lessons · 3 levelsKSh 500

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.

10% OFF10% OFF10% OFF10% OFF10% OFF10% OFF10% OFF10% OFF
Get Full Access — KSh 500

Reviews

No reviews yet.