16. Practice Exercises with Answer Hints
16.12 Module 13: Dashboards
- Write five KPIs with definitions for a Kolhapur store dashboard. Hint: numerator, denominator, filter, comparison, good direction (13.1).
- Build a KPI card that shows Net Sales in lakh and updates with slicers.
Hint: GETPIVOTDATA in a Calc cell → text
"₹"&TEXT(x/100000,"0.00")&" L"→ shape linked with=Calc!O3. - Connect City and Platform slicers to four pivots. Hint: Report Connections on each slicer.
- Fit the dashboard to one screen and hide gridlines/headings. Hint: View › Show; Zoom 100%.
- Add a manual check formula that must equal the Net Sales card.
Hint:
=SUMIFS(tblOrders[Amount],tblOrders[Status],"Delivered").
Ravindra Bagale's Tip
Khup students dashboard sathi 10–12 charts banavtat. Aadhi prashna liha, mag pratyek prashnasathi ekach chart. Kami charts, jasta spashtata (clarity) – manager la 30 secondat uttar milala pahije.