Unit 8.7
Data Presentation Tools: Dashboards and Reports
Learning Objectives
By the end of this chapter, you will be able to:
- ✅ Understand the importance of data storytelling.
- ✅ Define a dashboard and its purpose in monitoring business performance.
- ✅ Identify the key features and uses of reports.
- ✅ Name the leading software tools for creating dashboards and presentations.
The Most Critical Step
A brilliant analysis is useless if its insights are not understood or acted upon.
The final step in business analytics is communicating the findings to decision-makers.
This is done through data presentation tools that translate complex data into clear, compelling formats.
The Goal: Data Storytelling 📖
Data Storytelling: The practice of building a narrative around data to convey its meaning in a powerful and memorable way.
It's not just showing charts; it's about explaining:
- What happened? (The insight)
- Why it happened? (The context)
- What should we do next? (The recommendation)
🎬 Watch: Telling Stories with Data
Interactive: Identify the Storytelling Element
Read each statement below and click the correct data storytelling element it represents.
Statement
🚀 Real Case: The Chart That Didn't Persuade
The night before the space shuttle Challenger launched (28 January 1986), engineers warned that cold weather could stop the rubber O-ring seals working.
- Their charts listed past launches and damage in tables and sketches, but never plotted damage against temperature.
- Managers weren't convinced, and the launch went ahead at a record-low temperature.
- An O-ring failed; the shuttle broke apart and all seven crew died.
- Analysts later showed that one simple chart (damage vs temperature) made the danger obvious.
🎬 Watch: The Challenger Charts
Presentation Tool 1: Dashboards 📊
A dashboard is a data visualization tool that provides a real-time, at-a-glance view of Key Performance Indicators (KPIs).
Characteristics:
- 🎯 Purpose: Monitor business performance and track goals.
- ⚡ Features: Highly visual, interactive (drill-down, filter), and real-time updates.
- 📈 Analytics Type: Primarily used for Descriptive Analytics.
🎬 Watch: Dashboard Design Mistakes
📐 Designing a Good Dashboard
- 5-second rule: the main message should be clear at a glance.
- Few KPIs: about 5–9 metrics, not 30.
- Most important top-left: where eyes land first.
- Context: show a target or last period next to each number.
- Colour with meaning: red = needs action, not decoration.
Interactive: Live KPI Dashboard Simulator
Press Refresh Data to simulate real-time KPI updates — just like a live business dashboard.
Leading Dashboard Tools
Tableau
Powerful and popular, known for its user-friendly interface and beautiful, interactive visualizations.
Microsoft Power BI
Provides interactive visualizations with tight integration to other Microsoft products, especially Excel.
Google Looker Studio
Interactive: Match the Feature to the Tool
Click on a feature card to reveal which dashboard tool it best describes.
Presentation Tool 2: Reports 🔍
A report is used to provide more detailed information in a static format, often on a regular schedule (e.g., weekly, monthly).
Characteristics:
- 🎯 Purpose: Provide a detailed, static record for a specific period or topic.
- ⚡ Features: Often text-heavy with tables, charts, and graphs. Not typically interactive.
- Key Tools: Microsoft Excel, Google Sheets, Crystal Reports.
Dashboard vs. Report: Which to Use?
Dashboards
- High-level overview
- Interactive & dynamic
- Real-time data
- Answers "What's happening now?"
- Use for: Daily performance monitoring.
Reports
- In-depth details
- Static snapshot
- Periodic data (weekly, monthly)
- Answers "What happened over this period?"
- Use for: Monthly sales analysis, quarterly financial statements.
Interactive: Dashboard or Report?
For each business scenario, decide whether a Dashboard or a Report is the better tool.
📊 Which Chart for Which Message?
| Message | Best chart |
|---|---|
| A trend over time | Line chart |
| Comparing categories | Bar chart |
| Parts of a whole (few parts) | Pie or stacked bar |
| Relationship between two numbers | Scatter plot |
| Exact values to look up | Table |
Data visualization = showing data as pictures so patterns are quick to see.
🎭 How Charts Can Mislead
Illustrative: Branch A sold NPR 96 lakh, Branch B NPR 100 lakh.
B's bar looks 5 times taller than A's.
The bars look almost equal: the real difference is 4%.
- Other tricks: 3D pies, cherry-picked date ranges, two different y-axes.
- Rule: bar charts start at zero; always label axes and sources.
🧪 Quick Activity: Which Chart?
- Monthly tourist arrivals in Nepal over 5 years. → Line
- Do students who study more hours get higher marks? → Scatter
- Number of students in each faculty this year. → Bar
- The exact fee for each of 40 courses. → Table
Practical Application: A Nepali E-commerce Company
Imagine you are an analyst for Daraz Nepal.
- Dashboard Use Case: A real-time sales dashboard for the "11.11" campaign. It shows live sales figures, top-selling products, website traffic, and conversion rates. This helps the marketing team make instant adjustments to promotions.
- Report Use Case: A quarterly business review report sent to regional leadership. It details market share, category growth, customer lifetime value, and logistics performance metrics. This informs long-term strategy and investment decisions.
Interactive: Build the Data Story
Click the steps in the correct order to build a complete data story for the Daraz "11.11" campaign.
🧮 Worked Example: One Dataset, Three Audiences
Illustrative: a Nepali cooperative's monthly loan data.
| Audience | Needs | Best tool and chart |
|---|---|---|
| Board chair | "Are we healthy?" | One slide: line chart of overdue loans % vs target |
| Branch manager | "Who do I call today?" | Live dashboard: list of overdue borrowers, filter by branch |
| Auditor / regulator | "Show me every loan" | Detailed monthly report with full tables |
Same data; different question, detail and format.
Tying It All Together: The Presentation
The final step is often presenting your findings to stakeholders.
Analysts embed charts from dashboards and tables from reports into PowerPoint or Google Slides to support their data story.
The presentation is where the narrative comes alive, persuading the audience and driving business action.
💬 Discuss: Present It Better
- Think of a chart you saw in the news or on social media. Did it tell the truth clearly?
- If you had one slide to show your college's results to parents, what would you put on it?
- When is a dashboard the wrong tool?
Key Takeaways
- The goal of data presentation is data storytelling: building a narrative around the data to drive action.
- Dashboards provide an interactive, real-time view of business performance (e.g., Tableau, Power BI).
- Reports provide a detailed, static record of information for a specific period (e.g., Excel, Crystal Reports).
- The right tool depends on the audience and the question you are trying to answer: "What's happening now?" vs. "What happened last month?".
Exam Practice 📝
Short answer
- What is a dashboard?
- What is data visualization?
- Which chart type is best for showing a trend over time?
Exam Practice 📝 (continued)
Long answer
- Explain the key presentation tools and technologies used to communicate business insights.
- Discuss how the choice of presentation tool and chart type depends on the audience and the message.
Revise the answers in the full note.
Image & Video Credits
Images
- Challenger flight 51-L crew: NASA, public domain, via Wikimedia Commons
- Truncated axis diagram: course author (original), CC BY 4.0
Videos (YouTube)
- Harvard Business Review, "Telling Stories with Data in 3 Steps (Quick Study)" (0–62 s)
- Userfacet, "6 UX Design Mistakes While Designing a Dashboard" (14–100 s)
- Derek Sonderegger (NAU), "NAU STA 141 – Data Visualization and the Challenger Disaster" (63–116 s)
Thank You
Any questions?
Next Topic: Course Completed