Skip to content
Marrakech IT Academy
All courses Upcoming sessions
Register
Français English العربية
Data & Business Intelligence Available Course

Power BI — From Data to Dashboard

Import Excel or CSV files, clean them with Power Query, build a data model and create an interactive Power BI dashboard from realistic business data.

Level
Beginner → Intermediate
Duration
12–15 hours
Format
In person
Location
📍 Marrakech
Request next dates See sessions

Overview

From Excel or CSV files to an interactive dashboard: import and clean data with Power Query, build a data model, write your first DAX measures and design a readable dashboard, using realistic business datasets.

Tools : Power BI Power Query DAX

Who is this course for?

  • Professionals
  • Accountants
  • Managers
  • Data professionals
  • Students
  • Professionals who track indicators in Excel.
  • Accountants and management controllers.
  • Managers who want steering dashboards.
  • Students and data profiles.

What you will be able to do

  • Import data from Excel or CSV and clean it with Power Query
  • Build a data model with relationships
  • Write basic DAX measures (totals, comparisons, indicators)
  • Design readable visuals and interactive filters
  • Choose the right chart to tell a story with data

Practical exercises and projects

  1. 1 Sales dashboard: revenue, margin, monthly evolution
  2. 2 Cleaning and merging several Excel files with Power Query
  3. 3 Summary report with slicers and indicators for a manager

Program

  1. 01 — Import and preparation (Power Query)

    Connect to files, clean, transform.

  2. 02 — Data model and relationships

    Fact and dimension tables, relationships, good practice.

  3. 03 — DAX basics

    Measures, calculated columns, time comparisons.

  4. 04 — Visualizations and layout

    Choosing charts, filters, interactions, readability.

  5. 05 — Project: from file to dashboard

    A complete dashboard on a realistic dataset.

Prerequisites

Excel basics (tables, simple formulas). Power BI Desktop (Windows) must be installed; preparation is explained before each session.

Teaching method

80% practice / 20% theory

  • Short alternation of theory and exercises: you practice throughout the session.
  • Concrete cases and realistic datasets drawn from professional or academic situations.
  • Limited group size, with the instructor supporting you during the exercises.
  • In-person training in a training room in Marrakech.

Location

📍 Marrakech — in-person training in a training room provided by a partner school. The exact address is given for each session.

Upcoming sessions

Dates to be confirmed

No session is scheduled at the moment. Leave us your details: we will notify you as soon as the dates are set.

Request next dates

Price

The price is set for each session and has not been published yet. Request the next dates to find out.

Interested in this course?

Leave your details: we will tell you the next dates as soon as they are published.

Request next dates

Frequently asked questions

No. DAX basics are taught; advanced modeling has its own dedicated course.

Power BI Desktop runs on Windows. Mention it in your request if you do not have a Windows computer.

When a session is open, the "Register" button takes you to the form. Otherwise, ask to be notified: we contact you as soon as the dates are set. The academy then confirms your registration.

In person in Marrakech, in a training room provided by a partner school. The exact address is given for each session.

No. These are practical training courses. For certification preparation courses, the academy prepares you for the exam but does not issue the certification: the official exam is taken with the certifying body.

Related courses

Data & Business Intelligence Coming soon

Power Query for Data Preparation

Import, clean, transform and combine data sources in a reproducible way before analysis.

Level
Intermediate
Duration
6–8 hours
Audience
Professionals, Accountants, Data professionals
Format
In person
Location
Marrakech
View course Notify me
Data & Business Intelligence Coming soon

Power BI — Data Modeling & DAX

Design a solid data model (relationships, star schema) and write DAX measures for your indicators.

Level
Intermediate
Duration
12–15 hours
Audience
Data professionals, Professionals, Accountants
Format
In person
Location
Marrakech
View course Notify me
Data & Business Intelligence Coming soon

Excel + Power BI for Business

Combine Excel and Power BI to prepare data, track indicators and produce management reports.

Level
Beginner → Intermediate
Duration
15–20 hours
Audience
Professionals, Managers, Accountants…
Format
In person
Location
Marrakech
View course Notify me