Start a conversation ↗

Description

Power BI Fundamentals: Connect, Model and Visualise Your Data

Connect your sources, model your data and publish a Power BI report refreshed every month

  • 3 days — 21 h
  • In-person or virtual
  • Foundation
  • Up to 6 participants

Producing the monthly report often takes several days: extracts to rework, copies moved between workbooks, formulas that break as soon as a column shifts position. Figures end up differing from one department to another and the discussion turns to the data rather than the decisions to be taken.

Three days to build a complete Power BI report, from connecting to sources through to publication and scheduled refresh. Participants work on datasets close to their own business extracts.

Learning objectives

  • Connect Power BI to the organisation's various data sources
  • Transform and clean data in the query editor
  • Build a relational model that produces accurate totals
  • Write the most commonly used calculation measures
  • Publish a report and schedule its refresh

What makes this programme different

The datasets used replicate genuine business extracts
A complete report is built from source file through to publication
The most frequent modelling errors are diagnosed in workshop format

Programme

1Connecting and Preparing Data

Clean before you visualise

  • Connect to a file, a database or an online service
  • Clean and transform data in the query editor
  • Combine several sources through merge or append
  • Document each step to make the refresh reliable

2Data Modelling

Linking tables to cross-analyse

  • Distinguish fact tables from dimension tables
  • Create relationships and check their direction
  • Build a date table
  • Correct models that produce incorrect totals

3Calculations and Measures

Writing your first calculations

  • Differentiate calculated columns from measures
  • Write the most widely used aggregations
  • Filter a calculation according to a given context
  • Set up running totals and period comparisons

4Visualisation and Layout

Making the report readable

  • Select the visual suited to the question asked
  • Set up filters, slicers and navigation
  • Harmonise page formatting
  • Avoid misleading representations

5Publication and Refresh

Keeping the report alive after delivery

  • Publish a report to a workspace
  • Organise sharing and access rights
  • Schedule the data refresh
  • Set up a monitoring dashboard

Who is it for

Management controllers, accountants, analysts, reporting officers and operational managers who produce dashboards.

Prerequisites

Practical use of spreadsheets and the ability to work with data tables.

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.