Advanced Python for data analysis
Joins, time series, database connections and automation: a reproducible analysis chain.
| Duration | 3 jours (21 h) |
|---|---|
| Format | On-site |
| Level | Intermediate |
| Participants | — |
| Price | Sur devis |
| Certificate | Yes |
Who is this course for ?
Analysts and business profiles who have taken the introductory level or have equivalent Python and Pandas basics.
What will you be able to do by the end ?
- Perform joins, pivots and complex aggregations without leaving Python.
- Analyse time series and chronological data.
- Connect an analysis to a database or an external API.
- Automate the production and export of a report.
- Run simple statistical tests and interpret the result.
Programme
-
Day 1 — Advanced handling
Joins, pivots, multi-level aggregations. Performance and readability of a processing chain as it grows.
-
Day 2 — Time series and external sources
Chronological data, resampling and seasonality. Connecting to a database and to an API.
-
Day 3 — Automating and concluding
Automated reports and scheduled exports. Inferential statistics and simple tests, with the limits of their interpretation.
Prerequisites
Python and Pandas basics, from the introductory level or from practice. One laptop per participant.
How is the course run ?
A single thread: one analysis chain, reworked day after day until it is reproducible and scheduled.
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 Nov. 10, 2026