Start a conversation ↗

Description

Power BI — Advanced Decision-Making Dashboards: Modelling, Calculations and Industrialisation

Move from a report that works to a model that handles the load and refreshes without manual intervention

  • 2 days — 14 h
  • In-person or virtual
  • Expert
  • Up to 6 participants

The first report was built quickly and it works. Then the number of sources grows. Measures contradict one another depending on the filter applied. Refresh times get longer. Users ask for different views and every request creates a new report that no one maintains afterwards.

These 14 hours are designed for report designers who are already self-sufficient in building reports. The work focuses on the data model, advanced calculations and filter context, then on moving to production: scheduled refresh, access security, workspace organisation and control of response times.

Learning objectives

  • Build a star schema data model suited to the required analyses
  • Write advanced measures with full command of filter context
  • Optimise transformation queries and refresh times
  • Implement access security by user profile
  • Organise report publication and scheduled refresh
  • Diagnose slow performance and identify its cause within the model

What makes this programme different

The guiding thread is a faulty model that participants diagnose and then rebuild
Every measure written is tested against several contradictory filter contexts
Deployment is covered through to scheduled refresh and access rights

Programme

1Modelling and Relationships

The model determines everything else

  • Fact tables and dimension tables
  • Relationships, cardinality and filter direction
  • Date table and time-based analysis
  • Identifying models that produce incorrect figures

2Advanced Calculations and Filter Context

Understanding why a measure changes value

  • Measures and calculated columns according to use case
  • Row context and filter context
  • Context modification functions
  • Cumulative calculations, comparisons and period variances

3Data Preparation and Performance

Lighten the load before visualising

  • Transformations carried out as close to the source as possible
  • Unnecessary columns, data types and granularity
  • Merged queries and parameters
  • Measuring and reducing refresh times

4Publication, Security and Operations

From report to delivered service

  • Workspaces and the report life cycle
  • Scheduled refresh and authenticated sources
  • Row-level security applied by profile
  • Distribution, usage monitoring and maintenance

Who is it for

Report designers, analysts and management controllers who are already self-sufficient in creating visuals and transforming data.

Prerequisites

Ability to import data, create visuals and write simple measures in a business intelligence tool.

Dates & locations

36 scheduled dates between November 2026 and December 2027. Seats are confirmed in the order enquiries are received.

November 2026

December 2026

January 2027

February 2027

March 2027

April 2027

May 2027

June 2027

September 2027

October 2027

November 2027

December 2027

None of these dates suit you? We open additional sessions on request, and any programme can be run privately for your team.

Practical details

Before the programme
Online positioning questionnaire. Your development objectives are shared with the trainer, who tailors the practical case studies to your context.
Teaching methods
Theoretical input, workshops and practical case studies. Digital course materials and method sheets provided.
Assessment
Multiple-choice tests and role-play exercises. Assessment of learning at the start and end of the programme, with immediate and 60-day follow-up evaluations.
After the programme
One year of access to the e-learning platform. Self-assessment of the skills acquired and a 30-day follow-up session with your trainer.
How to register
Registration online or on the basis of a quotation.
Lead time
11 working days after confirmation of registration.
Accessibility
Accessible to people of determination. Contact our accessibility coordinator to design a suitable solution: contact@mpf-academy.ae
Start dates
Rolling intake: in addition to the scheduled sessions, this programme can start on request.