← Back to courses
Power BIAdvancedUpcoming

Power BI Professional

Enterprise Analytics and Semantic Modelling

20 hours82 lessons Self-study
4.8 (29)
EE
Emmanuel Edegbo

Lead Data Engineer & Architect

About this course

Implement enterprise semantic models, row-level security, deployment pipelines, and advanced DAX patterns.

Power BI is the most widely deployed BI platform in the enterprise — the tool decision-makers actually open. Analysts who can model data properly and build reports people trust are the bridge between raw tables and decisions, and that skill shows up in job specs across every industry.

Who this course is for

  • ✓Analysts who present data to stakeholders and want dashboards that update themselves
  • ✓Excel power users ready to graduate from static workbooks to governed, refreshable reporting
  • ✓Career switchers targeting BI analyst and BI developer roles
  • ✓SQL learners who want the visualisation and modelling layer on top of their query skills

Who this course is NOT for

  • ✗Experienced Power BI developers — Core covers the foundations; start at Applied or Professional
  • ✗Anyone after pixel-perfect paginated or print reporting — this track is interactive analytics first
  • ✗Learners who only need to query data — the SQL track covers that without the modelling layer

How you'll learn

  • →Each chapter follows the same rhythm: concept → worked build → expected result → hands-on lab in Power BI Desktop
  • →You build against the real SalesLT and ComplianceLT datasets — the same data the SQL track queries
  • →Labs produce report pages you keep — by the end you have a portfolio-ready dashboard, not screenshots
  • →Module Readiness Checks at the end of every chapter confirm you're solid before moving on
  • →Course discussion lets you ask the instructor and other learners questions inline with each lesson

By the end of this course, you'll be able to

  • ✓Model data properly — star schemas, relationships, and the difference between a measure and a column
  • ✓Write core DAX with confidence: CALCULATE, filter context, and time intelligence
  • ✓Design report pages stakeholders actually use — KPIs, drill-downs, slicers, and bookmarks
  • ✓Publish, refresh, and share governed reports through the Power BI Service
  • ✓Take a business question from raw tables to a defensible dashboard independently

Course at a glance

12
Chapters
82
Lessons
20h
Estimated time
Self-study
Format

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 the Power BI Professional 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 work 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 20m
1. 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 work
4.8
29 ratings (time-weighted)
  1. 5★
    23
  2. 4★
    6
  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

Continue 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 sessions

Portfolio projects

Real-data evidence employers can see.

No Power BI Advanced portfolio project published yet.

Browse all portfolio projects