13. Excel Dashboards
Chala mitrano, aata aapan sagla shiklela ekatra vaparnar aahot – Tables, formulas, PivotTables, charts aani slicers – aani ek purna Blinkit dashboard banavnar aahot. Dashboard mhanje ek page jithe manager la 30 secondat samajla pahije ki business kasa chalu aahe. Rang aani design nantar – aadhi prashna aani KPIs. Ghabru naka, step by step karuya.
What you will learn in this module
- Planning a dashboard: audience, business questions and KPIs (key performance indicators)
- Structuring the workbook into Data, Calc and Dashboard sheets
- Building KPI cards linked to formulas and GETPIVOTDATA
- Building the PivotTables and PivotCharts that feed the dashboard
- Connecting slicers and a timeline to every pivot
- Layout and design principles, refresh and a final checklist
The dashboard we will build (fictional data, March 2026). The Orders Table (tblOrders) holds all Blinkit and Amazon Now order lines for the six cities. The month's headline numbers, which the dashboard must show, are:
| KPI | Value (March 2026) | How it is calculated |
|---|---|---|
| Net Sales | ₹49,50,000 | Sum of Amount for Delivered orders |
| Total Orders | 14,000 | Count of Order ID (all statuses) |
| Delivered Orders | 13,200 | Count where Status = Delivered |
| AOV (average order value) | ₹375 | Net Sales ÷ Delivered Orders |
| Cancellation Rate | 4.0% | 560 cancelled ÷ 14,000 |
| Avg Delivery Time | 11.6 min | Average of Delivery Mins for Delivered orders |
City split of Net Sales: Pune ₹18,42,500 · Nagpur ₹9,86,300 · Nashik ₹7,12,400 · Sambhaji Nagar ₹6,05,900 · Kolhapur ₹4,38,700 · Solapur ₹3,64,200 (total ₹49,50,000).
Concepts in this chapter
- 13.1Planning: Audience, Questions and KPIs
- 13.2Structuring the Workbook: Data, Calc, Dashboard
- 13.3PivotTables that Feed the Dashboard
- 13.4KPI Cards
- 13.5Charts for the Dashboard
- 13.6Slicers and a Timeline for All Pivots
- 13.7Layout and Design Principles
- 13.8Refresh, Finishing Touches and a Checklist
The chapter recap is at the end of the last concept page.