23. Report and Dashboard Design Principles
23.5 Storytelling With Data
A good report tells a story: What happened? Why? What should we do?
- Context: titles that state the insight, not just the chart content. "Kolhapur had the fastest average delivery this month" is better than "Avg Delivery Time by City".
- Comparison: numbers mean little alone. Compare with last year, target or average.
- Focus: highlight the key bar or line; grey out the rest.
- Flow: pages ordered from summary to detail; bookmarks or page navigation guide the reader.
- Action: where possible, point to the next step (e.g. a drill-through page listing the customers behind a decline).
The story is not "how many visuals we built". The story is the sentence Shraddha can repeat after the meeting without the file in front of her. "Gangapur missed the promise on 2 of 6 delivered orders, and 1 of 8 orders was cancelled. College Road is the pattern, at 9 of 10. We are not moving Satpur's rider because of a smaller order card."
That paragraph has context (which store, against which promise), comparison (College Road and Satpur), a focus (Gangapur), and an action (do not move the Satpur rider). A line chart of all stores for twelve months does not say it. A title that says "Avg Delivery Time by City" does not say it. The better title is the claim: "Gangapur is the late Nashik store this week".
Comparison is what stops a vanity metric from sounding like news. "50 orders" is not a story. "50 orders, and 32 of 40 delivered orders inside 10 minutes" is a story, because the second number can disappoint you while the first one smiles. "₹400 AOV in both Pune and Nashik" is a story only because it tells you AOV will not pick the store. If a chart cannot sit next to a comparison, it is a number in a box.
Flow is the order of the pages, which is the order of the questions. Summary, then the store, then the order list. Bookmarks and buttons are how you walk a nervous reader along that order. They are not how you show every bookmark you know how to make.
Action is a named next step. "Investigate" is not a step. "Open the two Gangapur orders that missed 10 minutes, and the one cancel, before 11:00 IST" is a step. If the page cannot point there, it is a poster.
Ravindra Bagale's Tip
A common storytelling mistake is showing every chart you built. Lead with the message ("Delivery time rose in Nagpur after 9 pm"), then show the supporting visual. Remove charts that don't support the story on that page. Clear?
Ravindra Bagale's Tip – मराठी
Storytelling मधली एक common चूक म्हणजे तुम्ही बनवलेला प्रत्येक chart दाखवणं. आधी message सांगा ("Delivery time rose in Nagpur after 9 pm"), मग त्याला आधार देणारा visual दाखवा. त्या page वरच्या story ला आधार न देणारे charts काढून टाका. समजलं का?
Ravindra Bagale's Tip – हिंदी
Storytelling की एक common गलती है अपना बनाया हर chart दिखा देना. पहले message बताओ ("Delivery time rose in Nagpur after 9 pm"), फिर उसे support करने वाला visual दिखाओ. जो charts उस page की story को support नहीं करते उन्हें हटा दो. समझ आया?
Fix common mistakes
| Wrong result | Reason | Correction |
|---|---|---|
| Chart title Sales by Month | Describes, does not tell | Write the insight: May sales up to ₹1,200 from ₹900 |
| Too many messages | No single story | One message per page |
About this data: This table uses columns: Wrong result, Reason, Correction. Values shown are the lesson examples already on this page (not a new dataset).
Practise independently
Practice task
Write an insight title for the Month chart.
Practice file (fictional): visuals_orders_apr_may_2026.csv
Hints
- (1,200 − 900) ÷ 900.
Solution
May sales grew 33.3% to ₹1,200 (fictional data).
Revision card