Session 29 · Phase 4: Statistics & Visualization

Dashboard Building — 1 Complete Dashboard

Turn your analysis into a decision tool — KPIs, the right charts, clean layout, and a story a stakeholder can act on in seconds.

⏱ ~2 hrs 🧠 Project 🎯 High priority

Learning Objectives

1. What a Dashboard Is & Why

A dashboard is a single page that shows the most important metrics for a decision — at a glance, so stakeholders don't have to dig through raw data. A good dashboard answers "how are we doing?" in seconds.

2. KPIs — Key Performance Indicators

A KPI is a measurable value that shows how well a goal is being achieved — like total sales, churn rate, or average order value. KPIs are the "big numbers" at the top of a dashboard.

📝
Interview answer: "A KPI is a metric tied to a business goal — like revenue, churn, or conversion. I pick KPIs after understanding what decision the dashboard is meant to support."

3. The Key Elements of a Dashboard

ElementPurpose
KPI cardsthe headline numbers (total sales, churn %)
Chartstrends, comparisons, distributions
Filters / Slicerslet users slice by region, date, segment
Title / contextwhat the dashboard is about and the time period

4. The Four Design Principles

Before you place a single chart, answer these (from Tableau's own best practices):

  1. Purpose — what decision should this dashboard support?
  2. Audience — who will use it, and what do they already know?
  3. Layout — most important things first, top-left.
  4. Interactivity — slicers/filters let users explore on their own.
💡
Golden rule: the most important KPI goes top-left (that's where the eye lands first), and the layout should tell one clear story, not cram in every chart you can make.

5. Choosing the Right Chart

QuestionChart
How is a metric trending over time?line chart
How do categories compare?bar / column chart
What's the share of a whole?pie / doughnut
What's the distribution?histogram / boxplot
How are two numbers related?scatter plot

6. Data Storytelling

Visualization shows the data; data storytelling adds context and a narrative — the "what happened, why it matters, and what to do" around the chart. It's what turns a chart into a decision.

🌐
Real World: "Sales dropped 15% in the South" is a chart. "Sales dropped 15% in the South because a key product went out of stock — restock it to recover" is a story that drives action.

7. Building a Complete Dashboard — a Recipe

  1. Define purpose & KPIs — e.g. "help the sales manager spot regional problems."
  2. Prepare data — import and clean it (Power Query / Tableau Prep).
  3. Add KPI cards — total sales, orders, avg order value, churn %.
  4. Add trend & comparison charts — sales over time, sales by region.
  5. Add slicers — region, date, product.
  6. Add a title and one-sentence takeaway — the story.
📋 Stable content — Reviewed: August 2026

8. Interview Questions (with Model Answers)

The dashboard questions interviewers ask. Self-test before revealing.

IQ1. What is a KPI?

Model answer: "A Key Performance Indicator is a measurable value tied to a business goal — like revenue, churn rate, or conversion. I pick KPIs after understanding what decision the dashboard supports."

IQ2. What are the key elements of a dashboard?

Model answer: "KPI cards for the headline numbers, charts for trends and comparisons, and filters/slicers for interactivity — plus a clear title and context."

IQ3. Walk me through your dashboard-building process.

Model answer: "First I define the purpose and audience, then choose KPIs, prepare the data, add KPI cards and charts, add slicers for interactivity, and finish with a one-line takeaway."

IQ4. What design principles do you follow?

Model answer: "Purpose, audience, layout, and interactivity. I put the most important KPI top-left, keep the layout clean and focused, and let users explore with slicers."

IQ5. How do you decide which chart to use?

Model answer: "I match the chart to the question — line for trend, bar for comparison, pie for share, histogram for distribution, scatter for relationships."

IQ6. What's the difference between data visualization and data storytelling?

Model answer: "Visualization shows the data; storytelling adds context and a narrative — what happened, why it matters, and what to do. It turns a chart into a decision."

IQ7. What is a slicer, and why use it?

Model answer: "A slicer is an interactive filter — buttons that let users slice the dashboard by region, date, or segment. It makes the dashboard self-service instead of static."

IQ8. How do you make a dashboard stakeholder-friendly?

Model answer: "Keep the key number obvious, use clear charts, add labels and context, avoid clutter, and write a plain-English takeaway so the audience doesn't have to hunt for the insight."

IQ9. What's the most important thing to establish before building a dashboard?

Model answer: "Its purpose and audience. If I don't know what decision it supports and who will use it, I'll build the wrong thing — so I always clarify that first."

Hands-On Project: Design a Sales Dashboard

Plan (and, if you have Power BI/Tableau, build) a sales dashboard.

Steps

  1. Write down the purpose and audience in one sentence.
  2. List 4 KPIs for a sales manager.
  3. Choose 3 charts and explain why each one.
  4. Decide which slicers to include.
  5. Write the one-line takeaway the dashboard should communicate.
View Solution / Walkthrough
  1. Purpose: "Help the sales manager spot regional performance problems."
  2. KPIs: Total Sales, Orders, Average Order Value, Sales vs Target %.
  3. Charts: line (sales over time), bar (sales by region), pie (sales by product category).
  4. Slicers: Region, Date range, Product category.
  5. Takeaway: "South region is underperforming due to a product stock-out — restock to recover."

Key Takeaways

1

A KPI is a metric tied to a business goal — pick it after knowing the purpose.

2

Design by purpose, audience, layout, and interactivity.

3

Most important KPI goes top-left; keep the layout clean.

4

Match the chart to the question (trend/compare/share/distribution/relationship).

5

Storytelling adds the "why and what to do" — that's what drives action.

Objective Questions — Test Your Understanding

Q1. What does KPI stand for?

Q2. Which dashboard element lets users filter interactively?

Q3. What should you establish FIRST before building a dashboard?

Q4. Which element shows a single headline number like total sales?

Q5. What does data storytelling add beyond plain visualization?