Business Analytics Lab

Why it’s different

Formulas taught in business context: you clean real data, build interactive dashboards and write the one-page memo that turns analysis into a decision.

What you’ll learn

1. 01Spreadsheet Data Prep3 hrsData hygiene, handling missing values, removing duplicates and validation.Book this module separately: NPR 4,500–8,000
2. 02Formulas & Lookups3 hrsLogical, conditional, text and date functions; VLOOKUP/XLOOKUP; error handling.Book this module separately: NPR 4,500–8,000
3. 03Business Metrics & Pivots3 hrsSummarising sales and operations data, defining KPIs and comparing periods.Book this module separately: NPR 4,500–8,000
4. 04Dashboard Design3 hrsChart selection, visual hierarchy, slicers and conditional formatting.Book this module separately: NPR 4,500–8,000
5. 05Data Storytelling & Decisions2 hrsVariance analysis, testing hypotheses and writing one-page decision memos.Book this module separately: NPR 3,000–5,500

What you’ll walk away with

A clean dataset, a formula workbook, a KPI dictionary, a dashboard and a decision memo.

Full course (15 hrs): NPR 7,500

Facilitators