Lucky_J12's avatar
Lucky_J12
Frequent Visitor
9 months ago

Matrix Magic – Store Performance Insights (Q1 2024)

Overview
This matrix highlights regional and store-level performance for Q1 (Jan–Mar). The goal was to design a clean, insightful matrix using conditional formatting, data bars, color scales, and KPIs without overwhelming the viewer.

What’s Included

  • Region → Store hierarchy

  • Month-wise breakdown (Jan, Feb, Mar)

  • Measures: Total Sales, Total Profit, Profit Margin %, Avg CSAT, On-Time %, Return Rate %

  • Conditional formatting for profitability, delivery accuracy, and returns

  • Data bars for Sales to show visual magnitude

  • Icons for Customer Satisfaction

  • Diverging color scale for Return Rate

Key Insights

  • Store L is the strongest performer with consistent growth and high delivery accuracy.

  • West region shows best On-Time Delivery %, while South shows the biggest performance spread.

  • Store G requires attention due to high return rates.

  • Profit steadily improves from January to March across most stores.

Design Approach
Focused on simplicity, readability, and meaningful color cues. The stepped layout is disabled (flat hierarchy), and text formatting is optimized for clarity. The matrix uses a neutral theme to keep emphasis on insights rather than decoration.

Matrix magic