Real skills. Solid foundations.Kénitra, MoroccoQuestions? Let’s talk.
Data Analyst

Power BI — Analytics & Business Reporting

Prepare, model and analyse data with Power Query and Power BI, then design reports with figures you can explain.

Intermediate → advanced6 modulesFR / EN · website & free lessons
YOUR PROGRESSION, LEVEL BY LEVEL

The right level. A practical goal.

Start at the level matching your experience. Every stage has prerequisites, workshops and a validation project.

01
LEVEL 01

Intermediate

Build an end-to-end Power BI report with explainable, validated metrics.

Prerequisites: Basic Excel, table and aggregation skills; familiarity with simple data preparation.

01Scoping a BI project
  • Business question and users
  • KPI definitions
  • Source and expected quality
02Transforming with Power Query
  • Connectors, types and profiling
  • Merging and appending queries
  • Documented transformation steps
03Creating a star schema
  • Facts and dimensions
  • Cardinality and filter direction
  • Calendar table and keys
04Writing DAX measures
  • Measures versus calculated columns
  • SUM, DIVIDE and CALCULATE
  • Filter context and validation
05Designing an interactive report
  • Choosing visuals
  • Slicers and interactions
  • Navigation, tooltips and accessibility
06Publishing and maintaining
  • Model and report in the service
  • Refresh and gateway principles
  • Workspace and licence checks
VALIDATION PROJECT

Prove it through practice.

Deliver a sales report: cleaned sources, a star schema, a calendar, DAX measures and interactive pages.

Success criteria
  • Relationships and granularity are justified
  • Measures reconcile to a reference calculation
  • Interactions are tested and reading guidance is provided
Choose this level
02
LEVEL 02

Advanced

Design a performant model, secure distribution and organise long-term operation.

Prerequisites: Solid star-schema, Power Query, DAX measure and publishing skills, or completion of the intermediate level.

01Advanced semantic modelling
  • Role-playing dimensions
  • Active and inactive relationships
  • Import/DirectQuery choices under constraints
02Mastering DAX contexts
  • Row context and context transition
  • Iterators and variables
  • Time calculations with a validated calendar
03Optimising through measurement
  • Performance Analyzer
  • Cardinality and unnecessary columns
  • Comparing query times and results
04Securing data
  • Static and dynamic RLS
  • Filter propagation
  • Testing Viewer and editor roles separately
05Making refresh reliable
  • Parameters and dependencies
  • Gateway and connection identity
  • Incremental refresh depending on context and licensing
06Organising delivery
  • Environments and acceptance testing
  • Deployment with available tools and licences
  • Monitoring, incidents and documentation
VALIDATION PROJECT

Prove it through practice.

Productionise a multi-team report: a documented model, validated DAX, an RLS plan, Viewer-role tests and an operations procedure.

Success criteria
  • Measures tested across several filter contexts
  • RLS verified using appropriate accounts and roles
  • Performance measured before and after optimisation
Choose this level
Software & environment

Power BI Desktop on compatible Windows. Power BI account, publishing permissions, gateway and sharing licence must be checked for the workshops; Microsoft subscriptions are not included.

Start with a real lesson.

GENIUS NOTES / FREE PREVIEW6 MIN

Before the chart, define what the figure measures.

An explained concept, a diagram or example, then an exercise to work through yourself.

Read the free lesson

What you will learn to do

  • Prepare consistent, validated sources
  • Build a simple star schema
  • Create measures and understand filter context
  • Design a report that serves its audience

Skills across the programme

01Business questions and metric definitions
02Data collection and transformation with Power Query
Proposed module: concepts, practical cases and knowledge checks. Details are confirmed for your chosen session.
03Star schemas and relationships
Proposed module: concepts, practical cases and knowledge checks. Details are confirmed for your chosen session.
04DAX measures and filter context
Proposed module: concepts, practical cases and knowledge checks. Details are confirmed for your chosen session.
05Visualisation and report navigation
Proposed module: concepts, practical cases and knowledge checks. Details are confirmed for your chosen session.
06Publishing, access and refresh
Proposed module: concepts, practical cases and knowledge checks. Details are confirmed for your chosen session.

Start with the right foundations

Prerequisites

Basic Excel and data table knowledge. Power BI Desktop on a compatible environment.

Language and format

Discovery resources are available in French and English. Contact us to confirm the teaching language, format, materials and support for your chosen programme.

Connect knowledge to a project

EXAMPLE TARGET PROJECT

Build a sales report with a documented model, validated measures and views suited to decision-makers.

Before you enrol

Preview lessonFree · no account
Full programme and materialsAs confirmed for the session
Official examSeparate registration
Cloud environment costsCheck for each lab
TRY BEFORE YOU CHOOSE

The best way to find out?
Start learning.

One lesson, a real concept and an exercise. Discover our approach, without an account and at your own pace.

Open a free lesson
GENIUS NOTES / 001
CLOUD ARCHITECTURE

A reliable architecture starts with the right questions.

6 min · Reading & exerciseRead the lesson

Your next chapter starts here.

A goal, a question, a project? Let’s talk about your learning path.

Let’s talk about your goals