Avoid Dashboard Clutter

Technical Explanation

Dashboard clutter happens when too many metrics, charts, or visual elements compete for attention. It reduces comprehension and makes it harder to find the information that matters.

Principles of Dashboard Design

Principle	Description
Hierarchy	Most important metrics prominently displayed
Cognitive load	Limit to what viewers can absorb
White space	Allow visual breathing room
Alignment	Create visual connections

The 5-3-1 Rule

• 5 supporting metrics (small, quick glance)
• 3 main KPIs (medium size)
• 1 hero metric (largest, primary focus)

---

Code Examples

Using the CatCafe dataset:

-- Example: Before (Cluttered - too many metrics)
-- DON'T DO THIS:
SELECT
    total_orders,
    total_revenue,
    avg_order_value,
    unique_customers,
    returning_customers,
    new_customers,
    repeat_rate,
    total_cat_views,
    total_adoptions,
    revenue_per_cat,
    customer_satisfaction_score,
    average_visit_duration,
    website_visits,
    conversion_rate,
    cart_abandonment_rate,
    email_open_rate,
    email_click_rate,
    social_followers,
    social_engagement
FROM daily_metrics;
-- 20 metrics! This is chaos!

-- Example: After (Focused - 5-3-1 rule)
-- Hero (1): Revenue
SELECT
    SUM(total_amount) as monthly_revenue
FROM orders
WHERE status = 'completed'
AND order_date >= CURRENT_DATE - INTERVAL '30 days';

-- Main KPIs (3):
-- Revenue, New Customers, Conversion Rate
SELECT
    SUM(total_amount) as revenue,
    COUNT(DISTINCT CASE WHEN ... THEN customer_id END) as new_customers,
    conversion_rate
FROM metrics;

-- Supporting (5):
-- Avg Order Value, Retention Rate, CAC, LTV, Satisfaction
SELECT
    AVG(order_value) as aov,
    retention_rate,
    cac,
    ltv,
    satisfaction
FROM metrics;

---

The Cat Analogy

Cat cafe information overload:

Cluttered menu board:

CAT FOOD
Dry: $5/$10/$15
Wet: $6/$12/$18
Treats: $3/$5/$7
Premium: $20/$30/$40
Special: $15/$25/$35
Organic: $25/$35/$45
Grain-Free: $22/$32/$42
Kitten: $8/$16
Senior: $9/$18
Indoor: $7/$14
Outdoor: $7/$14
Hypoallergenic: $30/$45

Focused menu board:

CAT FOOD
Basic Care: from $7
Premium: from $15
Special Diet: from $22

Same information, but focused. Customers know where to start.

---

Exercises

Exercise 1

What makes a dashboard "cluttered"?

Exercise 2

Apply the 5-3-1 rule to these metrics:

• Revenue, New Customers, Returning Customers, Page Views, Bounce Rate, Avg Session Duration, Conversion Rate, Cart Abandonment, Email Open Rate, Revenue per User

Exercise 3

Why does cognitive load matter in dashboard design?

---

Key Takeaways

• Clutter reduces comprehension and decision quality
• Use the 5-3-1 rule: 5 supporting, 3 main, 1 hero metric
• Prioritize based on stakeholder decisions
• White space and hierarchy improve clarity
• Remove metrics that don't drive specific decisions