← Back to courses
Power BIAdvancedUpcoming
Power BI Professional
Enterprise Analytics and Semantic Modelling
16 hours44 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.
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
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 in