Phase 12 · Data, AI and operations
Data Analysis and Business Intelligence
Turn business data into reproducible analysis, reconciled KPIs, dashboards and decision-ready explanations.
Company-level project
Executive Sales Performance Dashboard with KPIs
Begin from the starter branch, work through the modules and use the main branch as a completed reference after making a genuine attempt.
Recommended sequence
Complete the modules at your own pace.
Every module links to the exact GitHub resource folder and its stable code-reference tag.
- 01
Excel, Power Query and Reproducible Analysis
Study the resources, complete the practical lab, validate the result and record any limitation.
Code referencep12-module-01-excel-power-query-and-reproducible-analysis - 02
Analytical SQL and KPI Views
Study the resources, complete the practical lab, validate the result and record any limitation.
Code referencep12-module-02-analytical-sql-and-kpi-views - 03
Practical Statistics for Decisions
Study the resources, complete the practical lab, validate the result and record any limitation.
Code referencep12-module-03-practical-statistics-for-decisions - 04
NumPy, pandas and Analytical Pipelines
Study the resources, complete the practical lab, validate the result and record any limitation.
Code referencep12-module-04-numpy-pandas-and-analytical-pipelines - 05
Data Visualisation and Executive Storytelling
Study the resources, complete the practical lab, validate the result and record any limitation.
Code referencep12-module-05-data-visualisation-and-executive-storytelling - 06
Power BI, DAX, Reconciliation and Delivery
Study the resources, complete the practical lab, validate the result and record any limitation.
Code referencep12-module-06-power-bi-dax-reconciliation-and-delivery
Project review
