← 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

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