← All courses
beginner
Python and data analytics
Go from spreadsheets to Python, SQL and dashboards.
16 weeks · 23 sessions · certificate on completion
For anyone who has outgrown Excel. You will learn Python from scratch, clean and analyse real datasets with pandas, query databases with SQL, and present findings that non-technical colleagues can act on.
Included with every programme
Free AI Training & Support
Every course, career path and internship comes with hands-on AI training at no extra cost — so you leave knowing how to use the tools the industry actually works with.
- Real tools, hands-onChatGPT, Copilot and the AI assistants teams actually use day to day.
- Applied to your subjectUse AI on the same code, data or design work your course already covers.
- Support while you learnBring your doubts to the AI sessions running alongside your regular classes.
- No extra chargeIncluded for every student, in classroom batches and live online alike.
Curriculum
6 modules · 23 sessions
1Python fundamentals4 sessions
Setting up Python and your editorFree preview
Variables, types and control flowFree preview
Functions, modules and packages
Files, errors and the standard library
2Working with data in pandas4 sessions
Series and DataFrames
Cleaning messy real-world data
Grouping and aggregation
Merging and reshaping datasets
3SQL for analysts4 sessions
Querying with SELECT and WHERE
Joins and subqueries
Window functions for analysts
Writing queries colleagues can trust
4Visualisation and storytelling4 sessions
Choosing a chart that answers the question
Matplotlib and seaborn in practice
Building a dashboard with Streamlit
Presenting findings to non-analysts
5Statistics for decisions4 sessions
Descriptive statistics that matter
Distributions and sampling
A/B testing from first principles
Common statistical traps
6Analytics capstone3 sessions
Choosing a dataset and a question
Analysis and written report
Final presentation