Data analyst training
From raw data to the dashboard that genuinely supports a decision.
| Duration | 5 jours (35 h) |
|---|---|
| Format | On-site |
| Level | Intermediate |
| Participants | — |
| Price | On request |
| Certificate | Yes |
Who is this course for ?
People who handle data without initial training in analysis: management, finance, production, quality, human resources.
What will you be able to do by the end ?
- Clean and make reliable a real dataset with Python.
- Write the SQL queries needed for day-to-day analysis.
- Choose the chart that fits the question asked.
- Build a dashboard that supports a decision.
- Present a result to a management team in five minutes.
Programme
-
Day 1 — Framing the question and gathering the data
Formulating the question before touching the data. Sources, formats, imports. First consistency checks.
-
Day 2 — Cleaning and preparing
Missing values, duplicates, types, outliers. Pandas in practice. Documenting your processing so it can be replayed.
-
Day 3 — Querying with SQL
Selections, joins, aggregations, window functions. The queries you need every day.
-
Day 4 — Analysing and visualising
Descriptive statistics, correlations and their traps. Choosing the visual to match the question. Building the dashboard.
-
Day 5 — Presenting and deciding
Structuring a message, ranking the figures, anticipating objections. Each participant presents to the group.
Prerequisites
Spreadsheet practice and basic logic. No programming prerequisites.
How is the course run ?
Every module is built on a business dataset. The course ends with an oral presentation to the group: being able to explain a result is part of the job.
Further reading
-
Power BI in business: the 7 mistakes that kill your reports
Most Power BI reports abandoned after three months fail for the same reasons. The seven most frequent mistakes, and how to correct them.
-
Power BI: where do you start when you are coming from spreadsheets?
The first dashboard almost always fails for the same reason: people start with the charts instead of starting with the data. Here is the order that works.
Frequently asked questions
Are courses delivered at our offices?
Yes, and that is the format we recommend: your teams work in their own environment on their own data. Remote and hybrid delivery are possible depending on your constraints.
How many participants per session?
We deliberately cap group sizes to keep time for individual support during exercises. The exact number is set in the quote, according to the course and the level of the group.
Do we work on our own real data?
Yes wherever possible, and this is the main difference from generic training. Exercises use your real datasets, which means participants leave with dashboards and automations they can put straight to use.
Is a certificate issued?
Yes, a named certificate is given to each participant at the end of the course, together with the detailed programme covered.
What happens after the course?
The materials, exercise workbooks and working files stay with you. Follow-up support can be included in the quote, to answer the questions that surface once the learning is put into practice.
How much does a training course cost?
The price depends on four things: the course chosen, its length, the number of participants and the location. An in-house session run on your own data is not priced like a short refresher. We send a quote within 48 hours, free and with no commitment, after a thirty-minute conversation to frame the need and the level of the group.
Updated Aug. 11, 2026