10 weeks · Intermediate · Data
Data Analytics with Python
Python, pandas, SQL and visual storytelling. Turn raw datasets into dashboards and decisions.
For anyone who already works with spreadsheets and wants to move to real analysis. We cover Python fundamentals, pandas, SQL and dashboarding.
Each module uses messy, realistic data, the kind that needs cleaning before it tells you anything.
What the course covers
Module 01
Module 1 · Python for analysts
- Syntax refresher
- Working with files
- Notebooks and workflow
Module 02
Module 2 · pandas
- Cleaning messy data
- Grouping and joins
- Time series basics
Module 03
Module 3 · SQL
- Queries and joins
- Window functions
- Query performance
Module 04
Module 4 · Storytelling
- Chart choice
- Dashboards
- Capstone analysis
Demo lessons
Course tour and dataset preview4:48
Cleaning a messy CSV live11:22
What you will walk away with
- Confident data cleaning and analysis in pandas
- SQL queries against production-shaped schemas
- Dashboards that non-technical stakeholders understand
- A capstone analysis on a dataset of your choice