Skip to main content

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.

Next session to be confirmed
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.

Ask for the next dates

From management data to shared dashboards.

* Required field