Academy
Power BI & data analysis
From management data to shared dashboards.
Connect your sources, model the data, write your DAX measures and publish interactive Power BI reports to steer your business.
- Duration
- 24–40 h
- Format
- On site in Oujda, in-company or hybrid
- Level
- Intermédiaire
- Pricing
- Request the conditions
Who is it for?
- Audience
Managers, controllers and analysts who produce reports and want to automate them.
- Prerequisites
Good Excel skills (pivot tables, common formulas). A Windows computer with Power BI Desktop, which is free.
What you will be able to do
- Import and prepare data from several sources with Power Query
- Build a star-schema data model with the right relationships
- Write DAX measures: totals, ratios, time comparisons
- Design clear, interactive reports
- Publish and share reports in the Power BI service
Curriculum
Getting started
Power BI Desktop and the Power BI service: the path from data to report.
Preparing the data
Excel, CSV and database connections; cleaning and shaping with Power Query.
Modelling
Fact and dimension tables, relationships, date table.
Calculating with DAX
Calculated columns and measures, CALCULATE, time intelligence, key indicators.
Designing the report
Choice of visuals, filters, slicers, navigation and readability.
Publishing and sharing
Workspaces, scheduled refresh, access rights.
Hands-on practice
Deliverable: a Power BI dashboard
A complete report built on a business case (sales, purchasing, HR or production), from data import to publication.
Assessment and certificate
Guided exercises at each step, then a presentation of the final dashboard: model quality, correct measures and a clear report.
ENTSI Academy certificate of completion, issued at the end of the course once the deliverable is validated.
Sessions
Next session to be confirmed.
Leave your details and we will send you the next dates as soon as they are set.