📱 Dashboard UI UX Principles

1. What is it?

Dashboard UI/UX Principles are the psychological, graphic, and ergonomic rules applied to analytical dashboards. It structures the interface around the Decision Loop:

flowchart LR
    U["User Persona"] --> G["Business Goal"]
    G --> Q["Analytical Question"]
    Q --> I["Visual Information"]
    I --> INT["Interaction / Slicing"]
    INT --> D["Operational Decision"]
    D --> A["Action"]

    style U fill:#e3f2fd,stroke:#1565c0,stroke-width:1px
    style G fill:#fff3e0,stroke:#ef6c00,stroke-width:1px
    style Q fill:#f3e5f5,stroke:#7b1fa2,stroke-width:1px
    style I fill:#ede7f6,stroke:#512da8,stroke-width:1px
    style D fill:#fbe9e7,stroke:#d84315,stroke-width:1px
    style A fill:#e8f5e9,stroke:#2e7d32,stroke-width:2px

2. Why is it used?

Spreadsheets built without UI/UX principles fail in executive environments because:

• Visual Clutter: Too many contrasting colors and borders overwhelm the user's working memory.
• Ambiguous Priority: The user does not know where to look first.
• Cognitive Friction: Complex legends and tilted axis labels force the user to work harder to extract simple numbers.
• Action Paralysis: Displaying numbers without context (targets, benchmarks) prevents decision-making.

3. How does it work?

1. Visual Hierarchy (The 5-Second Scan):
   • High-level KPIs live at the top (Tier 1).
   • Core operational trajectories live in the center (Tier 2).
   • Detailed breakdowns and diagnostics live at the bottom (Tier 3).
2. The 8-Point Spatial Grid: All margins, card padding, and gutters adhere to multiples of 8 points ($8\text{px}, 16\text{px}, 24\text{px}, 32\text{px}$), ensuring visual rhythm.
3. Dual-Encoding Accessibility: Operational states combine color, iconography, and text (e.g. ⚠️ 18.9% - SLA Breach).

4. Syntax & Structure: The Executive Application Shell

┌────────────────────────────────────────────────────────────────────────┐
│ ZONE 1: TOP APP BAR (Branding, Time Scope, System Status, Global Sync) │
├──────────────┬─────────────────────────────────────────────────────────┤
│ ZONE 2:      │ ZONE 3: EXECUTIVE KPI CARDS (Structured Grid Containers) │
│ LEFT NAV &   ├────────────────────────────┬────────────────────────────┤
│ SLICERS      │ ZONE 4: PRIMARY VISUAL     │ ZONE 5: SECONDARY VISUAL   │
│              │ (Core Operational Trajectory) (Comparative Breakdown)   │
│              ├────────────────────────────┴────────────────────────────┤
│              │ ZONE 6: DIAGNOSTIC & DRILL-DOWN MATRIX                  │
│              ├─────────────────────────────────────────────────────────┤
│              │ ZONE 7: ACTIONABLE CONTEXT & OPERATIONAL INSIGHT FOOTER │
└──────────────┴─────────────────────────────────────────────────────────┘

5. Practical Example: Floating Shapes vs Native Grid KPI Cards

• Naive Implementation: Drawing a rounded rectangle shape, typing text, and floating it over rows 4–8. When opened on a 150% DPI laptop screen, the text overflows or the card shifts 40 pixels to the right!
• UI/UX Engineering: Formatting merged native Excel worksheet cells (Rows 5:7, Cols F:H) with subtle 1pt borders (#E2E8F0), bold 22pt font (#0F172A), and custom number formatting. The KPI card is 100% DPI-resilient across every device.

6. Common Mistakes

1. Rainbow Palettes: Assigning random colors (green, red, yellow, purple) to individual bars in a single category chart.
2. Using Gauges & Speedometers: Takes up massive screen space to communicate a single scalar number.
3. Pie Charts with Many Slices: Comparing angles is cognitively difficult; replace with horizontal ranked bars.
4. Neglecting Empty / Zero-Result States: Slicers that yield 0 rows displaying ugly #N/A errors.

7. When to use

• Every user-facing Excel dashboard, executive brief, and operational report.
• Applications intended for C-suite executives, directors, or operational team leads.

8. When NOT to use

• Personal scratchpad analysis or exploratory data science notebooks.

9. Real-World Analytics Use Case: PwC Call Center (Claire)

Applying these UI/UX principles to Claire's dashboard enabled her to conduct a 10-second operational scan: immediately seeing the $18.9%$ abandonment alert in the top KPI strip, identifying Monday volume surges on the primary trajectory, and isolating Stewart's high handle time on the agent quadrant.

10. Related Concepts

• 🏗️ Excel Dashboard Architecture
• 📊 Excel Visualization Principles
• 🎨 Dashboard Design System
• 📐 Dashboard Wireframe