Online Power BI course: from your data to a professional dashboard

Duration: 32 hours, 16 sessions of 2 hours

Format: online with replay

Certificate: included

Learn Power BI step by step in 16 two-hour sessions: import and clean your data with Power Query, build a star schema, write DAX measures, create interactive visuals, then publish and secure your reports.

Goal: complete independence with Power BI

2,000 MAD (≈ €185)

Individual price

32 hours of practice

16 sessions of 2 hours

French and Arabic

Online + replay

Group price, min. 4

1,000 MAD (≈ €90) /person

Clean data

DAX measures

Clean and combine your sources with Power Query.

Calculate revenue, share of total and changes over time.

Clear dashboards

Real project

Design readable, interactive and professional reports.

Finish with a complete dashboard presented in a final defence.

Turning raw data into dashboards that support decisions

This certified Power BI course is for students, researchers and professionals who want to analyse and present data without relying on Excel alone. Each two-hour session ends with a concrete exercise, so you progress with a simple logic: prepare, model, calculate, visualise, share.

Prepare the data

Model and calculate

Visualise and share

Import Excel, CSV and web files, then clean, merge and transform them with Power Query.

Build a reliable star schema and create DAX measures: CALCULATE, filter context, time intelligence.

Design interactive reports, publish them to the Power BI service and control access to the data.

The Power BI skills you'll master by the end

The programme covers the whole analysis chain, from importing data to a published, secured report.

Understand business intelligence and the difference between Excel and Power BI.

Import Excel, CSV and web data, in Import or DirectQuery mode.

Clean, merge and transform data with Power Query.

Build a star schema with fact tables, dimensions and relationships.

Write DAX measures: SUM, DIVIDE, CALCULATE, FILTER, ALL.

Analyse change over time: YTD, previous month, previous year.

Create advanced visuals and navigable reports with bookmarks and drill-through.

Publish, share, secure (RLS) and optimise your Power BI reports.

Who is this Power BI course for?

A course designed for anyone who needs to analyse data and present clear results, with no programming prerequisites.

Bachelor's, Master's and PhD students

Recent graduates

Finance and management control

To analyse the data of a thesis, final-year project or dissertation and present visual results.

To add a highly sought-after data and business intelligence skill to your CV.

To automate reporting, track indicators and compare periods.

Marketing and sales

Human resources

Entrepreneurs and SMEs

To track sales, commercial targets and performance by region or product.

To build HR dashboards: headcount, absences, recruitment and turnover.

To manage your business with reliable, automatically updated indicators.

Detailed Power BI course programme (16 sessions, 32 hours)

Each session lasts 2 hours and combines a goal, specific content and a practical exercise.

Session 1: Introduction to Power BI

Goal: Understand Power BI and create a first report

Content: BI, Excel vs Power BI, real cases, interface (Home, Data, Model).

Practical exercise: Total sales and sales by city.

Session 2: Data sources and basic visuals

Goal: Import several sources and build an interactive page

Content: Excel, CSV, Web, Import vs DirectQuery, choosing a visual, slicers.

Practical exercise: One-page mini sales dashboard.

Session 3: Power Query: data cleaning

Goal: Know how to clean data

Content: Unnecessary columns, null values, types, duplicates, standardising text.

Practical exercise: Clean a customer dataset.

Session 4: Modelling: tables and relationships

Goal: Build a star schema

Content: Fact and dimension tables, keys, cardinality, filter direction.

Practical exercise: A 3-table model with 2 visuals.

Session 5: DAX: the basics

Goal: Create measures

Content: Measure vs calculated column, SUM, AVERAGE, COUNTROWS, DIVIDE.

Practical exercise: Revenue, average basket and number of sales measures.

Session 6: DAX: CALCULATE and filter context

Goal: Master filter context

Content: CALCULATE, FILTER, ALL, row context and filter context.

Practical exercise: Sales by city as % of total.

Session 7: DAX: time intelligence

Goal: Analyse over time

Content: Calendar table, year-to-date (YTD), previous month, previous year.

Practical exercise: Sales trend compared with the previous year.

Session 8: Advanced Power Query

Goal: Transform complex data

Content: Merge and append queries, conditional column, pivot and unpivot.

Practical exercise: Combine 12 monthly files into a single table.

Session 9: Advanced visuals

Goal: Choose and configure rich visuals

Content: Matrix, gauge, KPI, maps, combo chart.

Practical exercise: A commercial target tracking page.

Session 10: Advanced interactivity

Goal: Make the report navigable

Content: Page and report filters, bookmarks, drill-down, drill-through, tooltips.

Practical exercise: A 2-page report with navigation.

Session 11: Design and storytelling

Goal: Create a readable, professional report

Content: Themes, colours, layout, visual hierarchy, accessibility.

Practical exercise: Redesign an existing report.

Session 12: Power BI service: publishing and sharing

Goal: Publish and share a report

Content: Workspace, publishing, scheduled refresh, dashboards, sharing.

Practical exercise: Publish your report and share it.

Session 13: Security and governance

Goal: Control access to data

Content: Row-level security (RLS), roles, governance best practices.

Practical exercise: Create a role per region.

Session 14: Performance optimisation

Goal: Speed up a slow report

Content: Performance analyzer, model reduction, DAX best practices.

Practical exercise: Diagnose and optimise a report.

Session 15: Guided case study

Goal: Use all the skills together

Content: End-to-end project: import, cleaning, model, measures, visuals.

Practical exercise: A complete HR or marketing dashboard.

Session 16: Final project and assessment

Goal: Assess what you've learned

Content: Project presentations, feedback, assessment, next steps.

Practical exercise: Final project defence.

What the course includes

Complete PDF materials

16 practical exercises

Exercise data files

Replay available

Private WhatsApp group

Final certificate

What you'll build during the course

Concrete exercises that reproduce real analysis and reporting needs.

A one-page sales dashboard with slicers and interactive visuals, then a commercial target tracking page.

A complete star schema and DAX measures: revenue, average basket, share of total and change versus the previous year.

An end-to-end HR or marketing dashboard, published to the Power BI service and presented at the final project defence.

Sales dashboard

Model and DAX measures

Complete final project

Sessions 2 and 9

Sessions 4 to 7

Sessions 15 and 16

Before starting Power BI

Answers to the questions we are asked most often before enrolment.

How long is the Power BI course?

The course lasts 32 hours, spread over 16 two-hour sessions, from the introduction to Power BI to the final project.

Is it suitable for beginners?

Yes. The first session starts from scratch: the difference between Excel and Power BI, the interface and a first report. It then progresses to Power Query, modelling, DAX and publishing.

How much does the Power BI course cost?

The one-to-one course costs 2,000 MAD (≈ €185). In a group of at least 4 people, the price is 1,000 MAD (≈ €90) per participant.

Do I get a certificate?

Yes, a Data Académique certificate will be issued at the end of the course, depending on the path followed.

Is it live or on replay?

The course takes place online with a replay available, so you can review the steps at your own pace.

Do I need to install Power BI?

Yes, Power BI Desktop must be installed. It is free Microsoft software that runs on Windows. You can ask for guidance if you need help getting started.

Master Power BI and create dashboards that make a difference

In 16 sessions, go from scattered data to clear, interactive, shared reports, useful for your studies and your career.