AI & Data
Data Analytics with Python and Power BI
Turn messy spreadsheets into dashboards people actually use. Python for the cleaning, Power BI for the story.
Overview
Most analysis work is cleaning, not modelling. This course is honest about that: you spend the first half learning to get real, broken data into a shape you can trust, and the second half turning it into dashboards a manager will read without you standing next to them.
Bring your own dataset if you have one. Several past participants have used their employer's data and left with something they put straight into use.
Learning outcomes
Clean and reshape real data with pandas, including the ugly cases
Join data from multiple sources without silently losing rows
Describe a dataset properly before drawing conclusions from it
Build an interactive Power BI dashboard with filters and drill-down
Choose a chart that answers the question rather than decorating the slide
Explain an analysis to someone who will not read your code
Curriculum
01Week 1-2: Data that fights back
- pandas DataFrames and Series
- Missing values, duplicates and inconsistent categories
- Dates, encodings and the things that break imports
02Week 3-4: Reshaping and joining
- Group, aggregate, pivot
- Merges and what a row count tells you after one
- Building a repeatable cleaning script
03Week 5: Describing data honestly
- Distributions, outliers and summary statistics
- Correlation and what it is not
- Sanity checks before you present anything
04Week 6-7: Power BI
- Connecting sources and the data model
- DAX measures for the calculations you actually need
- Relationships, filters and slicers
05Week 8: Designing a dashboard
- Choosing visualisations that answer a question
- Layout, colour and accessibility
- Performance on large datasets
06Week 9-10: Capstone
- A full analysis on your own or a provided dataset
- Review session with feedback
- Presenting to a non-technical audience
Prerequisites
- Basic Python, or completion of Python Programming Foundations
- Comfortable with spreadsheets and formulas
- A laptop that can run Power BI Desktop (Windows) or a Windows VM