← Back to courses
Power BIIntermediateUpcoming

Power BI Applied

Interactive Reporting and Data Modelling

20 hours90 lessons Self-study
5.0 (48)
EE
Emmanuel Edegbo

Lead Data Engineer & Architect

About this course

Build star-schema data models, write DAX measures, and create paginated reports for real business stakeholders.

Power BI is the most widely deployed BI platform in the enterprise — the tool decision-makers actually open. Analysts who can model data properly and build reports people trust are the bridge between raw tables and decisions, and that skill shows up in job specs across every industry.

Who this course is for

  • ✓Analysts who present data to stakeholders and want dashboards that update themselves
  • ✓Excel power users ready to graduate from static workbooks to governed, refreshable reporting
  • ✓Career switchers targeting BI analyst and BI developer roles
  • ✓SQL learners who want the visualisation and modelling layer on top of their query skills

Who this course is NOT for

  • ✗Experienced Power BI developers — Core covers the foundations; start at Applied or Professional
  • ✗Anyone after pixel-perfect paginated or print reporting — this track is interactive analytics first
  • ✗Learners who only need to query data — the SQL track covers that without the modelling layer

How you'll learn

  • →Each chapter follows the same rhythm: concept → worked build → expected result → hands-on lab in Power BI Desktop
  • →You build against the real SalesLT and ComplianceLT datasets — the same data the SQL track queries
  • →Labs produce report pages you keep — by the end you have a portfolio-ready dashboard, not screenshots
  • →Module Readiness Checks at the end of every chapter confirm you're solid before moving on
  • →Course discussion lets you ask the instructor and other learners questions inline with each lesson

By the end of this course, you'll be able to

  • ✓Model data properly — star schemas, relationships, and the difference between a measure and a column
  • ✓Write core DAX with confidence: CALCULATE, filter context, and time intelligence
  • ✓Design report pages stakeholders actually use — KPIs, drill-downs, slicers, and bookmarks
  • ✓Publish, refresh, and share governed reports through the Power BI Service
  • ✓Take a business question from raw tables to a defensible dashboard independently

Course at a glance

12
Chapters
90
Lessons
20h
Estimated time
Self-study
Format

Datasets used

SalesLTRetail dataset — used for sales dashboards, KPI cards, and time-intelligence examples.
ComplianceLTCompliance dataset — used for risk-monitoring report pages and slicer-driven analysis.

Tools you'll need

  • •Power BI Desktop
  • •Power BI Service account (free tier)

What you get when you enrol

  • ✓Lifetime access to every lesson, exercise, and update — including future revisions to this course.
  • ✓12-month Azure SQL practice access against the same datasets used in the course (read-only). Renews on request for active learners.
  • ✓Auto-graded labs in your browser — write SQL, hit Run, get instant feedback against the expected result.
  • ✓AI-graded Professional Challenges — open-ended scenarios reviewed against a published rubric, not just a single right answer.
  • ✓Course discussion + community — talk to other learners and ask the instructor questions inside the course.
  • ✓Basic Certificate on demonstrated capability — awarded when you complete every Hands-On Lab and Module Readiness Check, plus the Professional Challenges. Confirms you can write, run, and defend course-level SQL against real datasets.
  • ✓Optional Advanced Certificate on completion of the Power BI Applied multi-project — a separate credential awarded when you complete all three capstone projects, each independently assessed and approved by an instructor. Each project is end-to-end work against a real brief with defined acceptance criteria — proves competence at a level an employer can actually evaluate. The Basic Certificate alone confirms course mastery; the Advanced Certificate confirms you can deliver.
  • ✓Optional live training upgrade — instructor-led cohort sessions with capped capacity, sold separately.

What you'll learn

  • ✓Design star-schema data models with fact and dimension tables
  • ✓Write intermediate DAX measures (CALCULATE, FILTER, ALL, ALLEXCEPT)
  • ✓Build drill-through and drill-down report pages
  • ✓Create bookmarks and page navigation for guided analytics
  • ✓Implement row-level security basics
  • ✓Complete a multi-page interactive reporting project

Who this is for

Software testersBusiness analystsData analystsData engineersRecruitersCyber security professionalsData scientists

Curriculum

90 lessons · 20h 26m
1. From Core to Applied9 lessons
2. Role-Playing Dimensions8 lessons
3. Many-to-Many & Parameter Tables9 lessons
4. Filter Context in Depth9 lessons
5. Grain & Aggregation Patterns8 lessons
6. Time Intelligence in Depth8 lessons
7. Power Query for Analysts9 lessons
8. Advanced Visuals & Interactivity7 lessons
9. Report Design at Stakeholder Level8 lessons
10. Shipping Reports7 lessons
11. Capstone Project — Cubed Analytics NHS Trust Patient Flow Dashboard2 lessons
12. Quick Reference Cheat Sheet6 lessons

Prerequisites

  • •Power BI Core or equivalent Power BI foundation

What learners say

How ratings work
5.0
48 ratings (time-weighted)
  1. 5★
    48
  2. 4★
    0
  3. 3★
    0
  4. 2★
    0
  5. 1★
    0

Course discussion

Open to enrolled learners

Sign in to read and post in the course discussion.

Sign in

Continue on the Power BI Intermediate track

Pair this with the matching format to build skills, evidence and accountability together.

Live Training cohorts

Instructor-led. Pick a date that works.

No Power BI Intermediate live cohort scheduled yet.

See upcoming live sessions

Portfolio projects

Real-data evidence employers can see.

No Power BI Intermediate portfolio project published yet.

Browse all portfolio projects