Case Study 1: BFSI โ Analytics & AI
Context
The bank's analytics and reporting team of 38 was producing monthly management packs using manual Excel processes that took 3โ4 days per cycle. The MIS head had trialled Power BI but adoption was low because the team lacked confidence in AI features. The training need was partly technical and partly cultural: people needed to see AI as a tool that helped them, not replaced them.
The Challenge
- โMonthly MIS pack taking 3โ4 person-days of manual work per cycle
- โPower BI Copilot purchased but unused โ team unfamiliar with how to use it effectively
- โRegulatory reporting narratives drafted manually by senior analysts
- โJunior analysts spending 60% of time on data cleaning rather than analysis
Our Approach
Day 1 covered AI tool orientation and Power BI Copilot hands-on labs using the bank's own data export structure (anonymised). Day 2 focused on Python automation for data cleaning and report generation. Day 3 was prompt engineering for regulatory narrative writing, with a live exercise producing a SEBI-format commentary from structured data.
Measurable Outcomes
| Metric | Before | After | Change |
|---|---|---|---|
| MIS pack cycle time | 3.5 days | 1.2 days | -66% |
| Power BI Copilot adoption | 8% | 79% | +71 pp |
| Regulatory narrative drafting | 4 hours manual | 35 minutes AI-assisted | -85% |
| Junior analyst data cleaning time | 60% of week | 28% of week | -53% |
"We came in hoping for modest improvement. The actual numbers surprised even the CFO โ the first AI-assisted MIS pack landed 2 days early."
โ Head of MIS & Analytics
The biggest enabler was designing labs around the bank's own report templates and data structures. Participants weren't learning generic tools โ they were building the exact workflows they'd use on Monday morning.