Description

Data Analysis with Python: Explore, Visualise and Present Your Results

Build clear, well-structured charts with pandas and Matplotlib that make the message in your data stand out

  • 2 days — 14 h
  • In-person or virtual
  • Intermediate
  • Up to 6 participants

Extracts multiply and tables pile up, yet the reading remains difficult: overloaded charts, misleading scales, series stacked without any hierarchy. The time spent on formatting ends up exceeding the time devoted to the analysis itself, and the requester leaves without a clear conclusion.

Two days to structure an analysis chain in Python, from preparing the dataset with pandas through to the final figure. Each participant works on their own files and leaves with commented scripts and a reusable reporting template.

Learning objectives

  • Prepare and validate a dataset with pandas
  • Select the chart type suited to the question being asked
  • Build figures with Matplotlib and Seaborn
  • Set scales, axes and annotations to prevent misreading
  • Assemble several charts into a coherent presentation
  • Automate figure production in a reusable script

What makes this programme different

Each participant works on a dataset they bring with them
The scripts produced in session are commented and handed to every participant
A collective critical review of the charts closes each half-day

Programme

1Data Preparation with pandas

Starting from a clean table before plotting

  • Load source files and check their quality
  • Handle missing values and duplicates
  • Reshape tables through grouping and pivoting
  • Create the variables required for visualisation

2The Grammar of Charts

Matching a question to a visual form

  • Distinguish comparison, distribution, trend and relationship
  • Choose between bars, lines, scatter plots and box plots
  • Prioritise information through colour and line weight
  • Identify representations that mislead the reader

3Building Figures with Matplotlib and Seaborn

Mastering the figure down to the detail

  • Organise figures, axes and subplots
  • Set scales, tick marks and legends
  • Add annotations and reading markers
  • Apply a consistent colour palette
  • Export to the formats required by the report

4Presentation and Automation

Moving from a standalone chart to a decision-support document

  • Sequence figures to convey a message
  • Generate charts by looping over several scopes
  • Document the script to make it reproducible
  • Prepare the oral presentation of results

Who is it for

Analysts, research officers, engineers and management controllers who already work with data and wish to improve the way they present it visually.

Prerequisites

Ability to write a simple Python script and work with basic data structures.

Dates & locations

36 scheduled dates between November 2026 and December 2027. Seats are confirmed in the order enquiries are received.

November 2026

December 2026

January 2027

February 2027

March 2027

April 2027

May 2027

June 2027

September 2027

October 2027

November 2027

December 2027

None of these dates suit you? We open additional sessions on request, and any programme can be run privately for your team.

Practical details

Before the programme
Online positioning questionnaire. Your development objectives are shared with the trainer, who tailors the practical case studies to your context.
Teaching methods
Theoretical input, workshops and practical case studies. Digital course materials and method sheets provided.
Assessment
Multiple-choice tests and role-play exercises. Assessment of learning at the start and end of the programme, with immediate and 60-day follow-up evaluations.
After the programme
One year of access to the e-learning platform. Self-assessment of the skills acquired and a 30-day follow-up session with your trainer.
How to register
Registration online or on the basis of a quotation.
Lead time
11 working days after confirmation of registration.
Accessibility
Accessible to people of determination. Contact our accessibility coordinator to design a suitable solution: contact@mpf-academy.ae
Start dates
Rolling intake: in addition to the scheduled sessions, this programme can start on request.