A complete path to become operational in data analysis: clean data in Excel, query it with SQL, model it, build a Power BI dashboard and draw useful business conclusions.
A course that follows the real workflow of an analyst: prepare data in Excel, query it with SQL, model it, then build a Power BI dashboard and formulate useful conclusions for the business, on realistic datasets.
Tools : Excel SQL Power BI
The workflow followed throughout the course:
01 — Data and quality (Excel)
Cleaning, formats, checks.
02 — SQL for analysis
Queries, aggregations, joins.
03 — Preparation and modeling
Power Query, data model, relationships.
04 — Power BI and dashboards
Measures, visuals, interactivity.
05 — Final project: business analysis
From the raw file to recommendations.
Comfort with computers; Excel basics help but are not mandatory.
80% practice / 20% theory
📍 Marrakech — in-person training in a training room provided by a partner school. The exact address is given for each session.
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.
The price is set for each session and has not been published yet. Request the next dates to find out.
Leave your details: we will tell you the next dates as soon as they are published.
Clean your data, use formulas, tables and pivot tables, and build charts for a first analysis.
Query a database: SELECT, WHERE, ORDER BY, GROUP BY, aggregations, joins and subqueries, with the basics of databases.
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.