Skip to content
Back to learning library

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.

ExcelPower QuerySQLpandasPower BIDAX

Recommended sequence

Complete the modules at your own pace.

Every module links to the exact GitHub resource folder and its stable code-reference tag.

  1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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

Build first. Compare second. Explain every decision.

Build from starter
Run validation
Compare with main
Document limitations
Explain the architecture