Two weeks. You do the work.
No lectures. You learn the way analysts learn: by being handed the work and getting it reviewed.
The brief lands.
Your engagement manager messages you between two meetings. One slide on why the new stores lose money, for Thursday's steering committee. You say it back before you build anything.

Need you on the new-stores question for next Thursday's steerco. Partner wants a view on why they're losing money. One slide, maybe two. Data's in the room. I'm with the client till 4.

Got it. One slide on why the 12 new stores lose money, for Thursday, from the data in the room. Outline by end of day.
You build the model, and it doesn't tie.
Sixteen stores, five raw files, one working sheet. Your total comes out 4.1% above the client's own dashboard. Everybody's does, the first time. Finding out why is the work.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 2 | Store | Cohort | Opened | Revenue (₹L) | Rent (₹L) | Staff (₹L) | Orders |
| 3 | KK-01 Jayanagar | Mature | Mar-19 | 68.4 | 6.1 | 9.8 | 41,220 |
| 4 | KK-04 Indiranagar | Mature | Aug-19 | 71.2 | 7.4 | 10.1 | 43,015 |
| 5 | KK-09 HSR Layout | Mature | Jan-21 | 64.9 | 6.8 | 9.5 | 39,880 |
| 6 | KK-31 Whitefield | New | Feb-25 | 37.2 | 5.9 | 8.7 | 22,410 |
| 7 | KK-33 Sarjapur | New | Apr-25 | 34.8 | 5.6 | 8.4 | 21,006 |
| 8 | KK-37 Koramangala | New | Sep-25 | 29.1 | 6.2 | 8.9 | 17,532 |
| 9 | KK-40 Bellandur | New | Jan-26 | 24.6 | 5.8 | 8.2 | 14,870 |
| 10 | … | ||||||
| 19 | Total, 16 stores | 694.3 | 98.6 | 146.2 | 4,12,330 | ||
| 20 | Client ops dashboard | 667.0 | |||||
| 21 | Variance | +4.1% | ▲ outside 0.5% tolerance | ||||
A partner reviews your slide.
Your first draft describes the numbers. Rajan's comment asks for the one line. You say the note back, cut the title to one breath, and the client sees the fixed version that afternoon.
New store performance: what the numbers show
Observations
- New stores sell about half of what mature stores sell
- Rent per store is similar across both groups
- Staff cost per store is similar across both groups
- Ramp-up: new stores are 6 to 14 months old
- Cost lines to be reconciled with finance before steerco
The steering committee.
Seven people on the call. You own one number. The client CFO asks you about it, by name. You answer without guessing, or you say "I'll confirm and come back by end of day". Both are the right answer.
🎤Prabha Krishnan (CFO)
🔇Ashok Pillai
🔇Meera Iyer
🔇YouAbout 4 hours in total, on your own time. Three long sittings on a laptop, the rest are short days. Then a live case session with Prakriti.


Shrikant Shelke
Vaibhav Vashishta