Pertanyaan Bisnis & Framework
Tidak langsung membuat pivot table. Dimulai dari pertanyaan bisnis, siapa stakeholder-nya, dan framework apa yang tepat.
Dari riset bisnis, teridentifikasi 3 pertanyaan utama:
Pertanyaan 1: Outlet mana yang harus ditutup, mana yang diinvestasi?
Stakeholder: VP Operations + CFO + Board
552 outlet tidak bisa di-evaluate satu-satu. Dibutuhkan scoring framework yang sistematis — mempertimbangkan trend, area, dan lease expiry, bukan hanya profitabilitas saat ini.
Pertanyaan 2: Channel mana yang benar-benar profitable?
Stakeholder: CMO + VP Operations
Revenue aggregator naik, tapi setelah komisi 20-30%, masih profitable? Apakah aggregator cannibalize own delivery?
Pertanyaan 3: Apa yang di-present ke board?
Stakeholder: Board of Directors
1 halaman. Berapa outlet profitable vs unprofitable? Projected savings? 1 biggest risk, 1 biggest opportunity.
Framework: Outlet Segmentation
★
Stars — High Rev + High Margin
Invest & expand
$
Cash Cows — Low Rev + High Margin
Maintain, efficient
?
Question Marks — High Rev + Low Margin
Investigate, fix or close
×
Dogs — Low Rev + Low Margin
Closure candidates
Framework: Channel Profitability
| Channel | Revenue | Deductions | True Margin |
|---|---|---|---|
| Takeaway | Revenue | Food cost only | Highest |
| Dine-in | Revenue | Food + labor + rent | Good |
| Own Delivery | Revenue | Food + delivery cost (~7%) | Moderate |
| Aggregator | Revenue | Food + commission (20-30%) | Lowest / negative |
Mapping ke Job Posting
- Data Engineering (R1-3, R10-11) — collect, validate, transform → data cleaning & profiling
- Analysis & Modeling (R4-6) — patterns, scoring model → outlet segmentation & channel analysis
- Strategic Thinking (R8) — propose solutions → rekomendasi ke board
- Communication (R7, R12) — present to stakeholders → executive summary & report
Senior vs Junior
Level Junior: mengeksekusi report yang diminta. Level Senior: menentukan pertanyaan yang tepat, merancang framework, dan meng-communicate ke stakeholder yang berbeda.