This project simulates the in-store customer journey within a Quick Service Restaurant (QSR) using mock data. It visualizes key service touchpoints such as entry, ordering, payment, pickup, and exit — helping understand service time and operational efficiency across different ordering channels.
The dashboard was designed to:
- Monitor service time across Kiosk, Main Counter, and Online orders
- Measure performance KPIs like Order Preparation Time, Pickup Waiting Time, and Total Journey Time
- Compare store-wise and channel-wise service behavior
To replicate a real-world business scenario and build a compelling one-page dashboard that offers insights to stakeholders for improving the in-store customer journey.
- Power BI – Data modeling, DAX calculations, interactive dashboard
- Excel – Used to create and manage mock data
- DAX – Calculated columns and measures for KPIs
| Metric | Description |
|---|---|
| 🕒 Journey Time | Time between entry and exit |
| 🔧 Order Prep Time | Time between order start and ready-for-pickup |
| ⏳ Pickup Waiting Time | Time between order ready and pickup |
| 🧾 Channel-wise Analysis | Kiosk vs Main Counter vs Online |
| 🏬 Store Comparisons | Store 1 vs Store 2 vs Store 3 |
One-page executive dashboard with filters, cards, stacked visuals, and drill-downs.