← Back to courses
Power BIAdvancedUpcoming
Power BI Professional
Enterprise Analytics and Semantic Modelling
20 hours82 lessons Self-study
EE
Emmanuel Edegbo
Lead Data Engineer & Architect
About this course
Implement enterprise semantic models, row-level security, deployment pipelines, and advanced DAX patterns.
Course at a glance
12
Chapters
82
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
- ✓Build enterprise semantic models with composite models
- ✓Write advanced DAX (time intelligence, virtual relationships, TREATAS)
- ✓Implement comprehensive row-level and object-level security
- ✓Set up deployment pipelines across dev/test/prod workspaces
- ✓Optimise model performance with Vertipaq analyser
- ✓Complete an enterprise analytics architecture project
Who this is for
Software testersAdvanced data analystsData scientists
Curriculum
82 lessons · 20h 20m1. From Applied to Professional10 lessons
2. Storage Modes & Composite Models7 lessons
3. Aggregations at Scale7 lessons
4. DAX Performance Tuning7 lessons
5. Calculation Groups in Depth6 lessons
6. Advanced & Organisational Security7 lessons
7. Enterprise Semantic Models & Discovery8 lessons
8. Dataflows & Incremental Refresh7 lessons
9. Deployment, Governance & Operations8 lessons
10. The Optimisation Case7 lessons
11. Capstone Project — Cubed Analytics NHS Trust Enterprise Optimisation2 lessons
12. Quick Reference Cheat Sheet6 lessons
Prerequisites
- •Power BI Applied or strong intermediate Power BI skills
What learners say
How ratings work4.8
29 ratings (time-weighted)
- 5★23
- 4★6
- 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 Advanced 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 Advanced live cohort scheduled yet.
See upcoming live sessionsPortfolio projects
Real-data evidence employers can see.
No Power BI Advanced portfolio project published yet.
Browse all portfolio projects