← Back to courses
Power BIIntermediateUpcoming

Power BI Applied

Interactive Reporting and Data Modelling

16 hours40 lessons Self-study
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.

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 SQL Core 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 query engineering 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

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