← 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
| 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
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 in