About this course
Become a productive analyst fast. Learn SQL and Python for analysis, build dashboards in Power BI, and use AI assistants to clean data, write queries and draft insight summaries — while knowing how to check their work.
What you will be able to do
- Query and model data with SQL
- Analyse data with Python and pandas
- Build interactive Power BI dashboards
- Use AI assistants for analysis — and verify them
- Present findings that drive decisions
Curriculum
01Thinking like an analyst
- Questions
- Metrics
- Bias
02SQL
- Queries
- Joins
- Window functions
03Python for analysis
- pandas
- Cleaning
- Charts
04Power BI
- Modelling
- DAX
- Report design
05AI in the workflow
- Prompting for analysis
- Vibe-coding notebooks
- Verification
06Storytelling
- Narratives
- Executive summaries
- Presenting
Tools you will use
Prerequisites
- None
Projects you will build
5 milestones
Regional sales analytics with SQL and Power BI
Model raw sales data in SQL, build a Power BI report regional managers will actually use, and add AI-generated insight summaries.
SQL Server · Power BI · DAX Coming soon
5 milestones
Solar energy performance reporting with MySQL and Power BI
Track generation, efficiency and downtime across solar plants and spot under-performing panels early.
MySQL · Power BI · Excel Coming soon