Session | Topic | Teaching focus | Student activity | Best-fitting simulation, where relevant | Assessment or output |
|---|
1 | Business Intelligence foundations and decision support | Define BI, analytics, information and decision support. Frame operational, tactical and strategic decisions and connect them to data, users and action cadence. | Students convert broad management questions into decision statements, required evidence and measurable outputs. | | Decision-support map and one-page BI problem statement. |
2 | Data sources, architecture and integration | Cover source systems, ETL/ELT, warehouses, marts, lakes, semantic layers and the importance of grain and shared definitions. | Teams map a fragmented data estate and propose a target information flow for one management decision. | | Source-to-decision architecture with ownership and refresh logic. |
3 | Data quality, preparation and governance | Teach profiling, cleaning, master data, lineage, stewardship, access and fit-for-purpose data-quality thresholds. | Students triage a flawed dataset, classify materiality and decide whether to use, fix or stop. | | Data-quality assessment and governance RACI. |
4 | Descriptive analytics and performance measurement | Use summary statistics, ratios, benchmarks, trends and segmentation to build an accurate performance picture. | Students analyse a multi-period company dataset and write a concise performance diagnosis. | Financial Statement Analysis | Performance brief with ratios, trend commentary and key exceptions. |
5 | Exploratory and diagnostic analytics | Move from what happened to plausible drivers using drill-downs, segmentation, variance analysis and evidence gaps. | Teams build a driver tree and test competing explanations for a deteriorating KPI. | Financial Statement Analysis | Diagnostic memo separating observations, hypotheses and required evidence. |
6 | Data visualisation and dashboard design | Cover chart choice, visual hierarchy, comparison, interaction, annotations, accessibility and dashboard critique. | Students redesign an overloaded dashboard for two different decision users. | | One-screen dashboard storyboard plus design rationale. |
7 | KPIs, scorecards and managerial decision-making | Connect measures to strategy, owners, targets, thresholds, incentives and cross-functional trade-offs. | Students build a five-KPI scorecard and compare CFO, COO, CMO and CEO priorities. | Managerial Accounting | KPI dictionary and executive scorecard recommendation. |
8 | Predictive analytics and forecasting | Introduce prediction framing, baselines, forecast error, classification and model uncertainty for managerial users. | Students compare a forecast model with a simple baseline and decide whether accuracy is sufficient for action. | Portfolio Management | Forecast decision note with error interpretation and sensitivity. |
9 | Prescriptive analytics and decision models | Teach objectives, constraints, optimisation, what-if analysis, sensitivity and the limits of formal models. | Students allocate a constrained budget across competing projects and defend the chosen portfolio. | Capital Budgeting | Resource-allocation recommendation with model limits and override criteria. |
10 | Self-service BI, data literacy and adoption | Examine self-service scenarios, user roles, certified data, centres of excellence, adoption and analytical capability. | Teams design a governed self-service operating model for novice, casual and power users. | | Self-service BI operating model and adoption plan. |
11 | Advanced analytics, AI and augmented BI | Explore AI-assisted analysis, natural-language querying, anomaly detection, automated narratives and human verification. | Students audit an AI-generated executive summary and trace each claim to source evidence. | | AI-assisted BI validation checklist and permitted-use declaration. |
12 | Ethics, privacy, security and insight-to-action capstone | Integrate governance, bias, privacy, security, decision rights and implementation. Close the course by turning insight into monitored action. | Students present a board-style BI recommendation and defend assumptions, stakeholder impacts and next-step metrics. | | Capstone decision memo, oral defence and post-decision monitoring plan. |