Overview
Course Outline
Scheduled Dates

Course Overview

This course builds an end-to-end, business-ready approach to data management with Power BI. You'll connect governance and data quality to the models and pipelines that feed analytics, shaping dimensional models (such as star/snowflake), creating repeatable Power Query transformations, writing DAX for robust, governed metrics, and designing decision-led dashboards. We also cover Power BI Service (workspaces, apps, sharing), security (RLS/OLS), lifecycle (versioning, deployment, refresh), and the operating rhythms that ensure data remains reliable, secure, and adopted across the organisation.

Objective:

Define data governance roles, policies and stewardship for BI
Establish data quality rules, profiling and remediation workflows
Design conceptual, logical and dimensional models for analytics
Build Power Query ETL/ELT patterns with parameters and documentation
Create governed DAX measures and a reusable semantic layer
Design dashboards tied to decisions, KPIs and stakeholder journeys
Manage Power BI Service workspaces, apps, refresh and deployment
Implement security, privacy and compliance (RLS/OLS, sensitivity labels)

Course Outline

Day 1 — Strategy & Governance

BI strategy, operating model and ownership (roles, stewardship, guardrails)
Policies: privacy, security, lifecycle and data catalogue/lineage foundations
KPI accountability: decision mapping, metric definitions, approval pathways
Adoption playbook: enablement paths, change champions, feedback loops

Day 2 — Quality & Modelling

Data quality dimensions, rules, profiling and issue management
Conceptual/logical modelling and conformed dimensions
Dimensional design (facts, granularity, slowly changing dimensions)
Master/reference data alignment and naming/metadata standards

Day 3 — Integration with Power Query

Source connectivity and parameters; incremental patterns and automation
Staging vs curated layers; query folding and performance tips
Reusable transformations, documentation and testing of pipelines
Load strategies, lineage and refresh governance

Day 4 — Metrics, DAX & Dashboards

Semantic layer: measure tables, calculation groups, time intelligence
DAX patterns for robust, auditable business logic
Dashboard standards: layout, interactions, accessibility and narrative
Validation: metric reconciliation and stakeholder sign-off

Day 5 — Power BI Service, Security & Operations

Workspaces, apps, deployment pipelines and release management
Refresh scheduling, gateways, monitoring and alerting
RLS/OLS, sensitivity labels, auditing and compliance alignment
Road mapping and continuous improvement (backlog, SLAs, review cadence)

Schedule & Fees

Select Month

All
February
April
June
August
November

Location

All
London

New Popular

Data Management & Power BI

Date: 02 - 06 Feb 2026

Duration: 5 Days

Venue: London

Price: $5,900

New Popular

Data Management & Power BI

Date: 13 - 17 Apr 2026

Duration: 5 Days

Venue: London

Price: $5,900

New Popular

Data Management & Power BI

Date: 22 - 26 Jun 2026

Duration: 5 Days

Venue: London

Price: $5,900

New Popular

Data Management & Power BI

Date: 31 Aug - 04 Sep 2026

Duration: 5 Days

Venue: London

Price: $5,900

New Popular

Data Management & Power BI

Date: 23 - 27 Nov 2026

Duration: 5 Days

Venue: London

Price: $5,900

Data Management & Power BI

Date: 31 Aug - 04 Sep 2026

Duration: 5 Days

Venue: London

Price: $ 5,900

Questions? Speak to our friendly training advisor

John Bayson

Chat on Whatsapp

john@londontfe.com

+44 2071836657

CPD Standards

Employees of professional or formally regulated bodies are generally expected to have CPD accredited training. This type of accreditation ensures that the training is knowledgeable, informed and constantly updated. It ensures our standards as a company are kept high and consistent.

100000+ Members in
59+ Countries with
3000+ Chapters

Why Choose London Training For Excellence?

Reliability

We will never cancel a confirmed booking
Support

We offer around the clock support
Tailored

We customise our courses to suit your personal learning needs
Quality

Our courses are delivered by highly experienced industry experts
Recognition

All our courses are accredited by the CPD Standards Agency

Frequently Asked Questions

How can training courses be used as a company benefit?

Training is hugely beneficial to both yourself and your company. It enables you to employ new technologies, increases your productivity and enables you to be more autonomous. Have a look here at our infographic on the importance of training and development!

How often do you update your course content to ensure relevancy?

Our course content is constantly reviewed and updated to ensure we stay up to date with all the latest trends. After every course is completed we review the feedback and improve the material where necessary.

Do you keep your classroom environment and instructional methodologies current with today’s real-world workplace?

Yes, we focus our training on ‘real-world’ scenarios and our trainers are all highly experienced and skilled in their relevant fields.

Are your courses eligible for professional certification?

Yes, we offer certification with all our courses, every course is entitled to CPD (Continuous Professional Development) hours which you can put towards your professional portfolio.

Get In Touch Today