A practical program that teaches you the full data analysis workflow: collecting and cleaning data, finding patterns, and presenting clear insights. You will work with Excel, SQL, Python and Power BI on real-world datasets and finish with a portfolio of analysis projects.
Curriculum
Excel for Analysis: Formulas, lookups, pivot tables, charts and data cleaning.
Statistics Basics: Mean, median, distributions, correlation and sampling.
SQL for Analysts: Filtering, joins, grouping, subqueries and reporting queries.
Python for Data: Python basics, Pandas and data cleaning.
Data Visualization: Choosing the right chart and telling a clear story with data.
Power BI Dashboards: Data modelling, DAX basics and interactive dashboards.
Capstone Project: Answer a business question end to end and present your findings.