← Back to courses
Power BIIntermediateUpcoming
Power BI Applied
Interactive Reporting and Data Modelling
20 hours90 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.
Course at a glance
12
Chapters
90
Lessons
20h
Estimated time
Self-study
Format
Datasets used
| SalesLT | Retail dataset — used for sales dashboards, KPI cards, and time-intelligence examples. |
| ComplianceLT | Compliance 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
Curriculum
90 lessons · 20h 26m1. 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 work5.0
48 ratings (time-weighted)
- 5★48
- 4★0
- 3★0
- 2★0
- 1★0
Course discussion
Open to enrolled learnersSign in to read and post in the course discussion.
Sign inContinue 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 sessionsPortfolio projects
Real-data evidence employers can see.
No Power BI Intermediate portfolio project published yet.
Browse all portfolio projects