arrow_back Back to My Works

Portfolio / Case Studies / The Home Depot RFP

Retail Operations
RFP Dashboard

An enterprise retail business intelligence concept designed to centralize sales performance monitoring, inventory health, and store-level operations in React.

Client
The Home Depot
Role
Product Designer
Engagement
RFP Dashboard Concept
Platform
React Web App
Store Operations Command Center
LIVE STORE SYNC
Executive Hub
Inventory Health
Regional Map
Fulfillment

Q3 '26 Category Performance

ALL REGIONS AGGREGATED
+14.2% YOY
Total Store Revenue
$24.5M
Inventory Stockout Risk
Low
BOPIS Fulfillment Rate
96.4%

01 — Project Overview

The Retail Operations
Data Challenge

The Home Depot is one of the world's largest home improvement retailers, serving millions of customers through its physical stores and digital commerce platforms.

Managing retail operations at this scale requires continuous monitoring of sales performance, inventory health, customer behavior, store operations, and supply chain efficiency. As part of a Request for Proposal (RFP), MathCo was tasked with designing a modern enterprise analytics platform that demonstrated how retail executives, category managers, and operational teams could monitor business performance through a centralized dashboard experience.

"The objective was not simply to redesign an existing reporting interface, but to envision a future-ready analytics platform capable of transforming fragmented operational data into meaningful business insights."

The dashboard needed to showcase MathCo's design capabilities while illustrating how intelligent retail analytics could support faster decision-making across the organization. As the Product Designer, I was responsible for designing an interactive dashboard concept that balanced executive-level reporting with operational analytics while maintaining a clean, scalable, and presentation-ready user experience.

02 — Problem Statement

Fragmented Retail
Reporting Systems

Large retail organizations generate massive volumes of operational data across sales, inventory, logistics, customer engagement, and store performance. However, this information is often distributed across multiple reporting systems, making it difficult for stakeholders to gain a holistic understanding of business performance. Key challenges included:

Scattered Dashboards

Business metrics were scattered across multiple disjointed dashboards.

Fragmented Overview

Executives lacked a consolidated operational overview of business health.

Slow Risk Spotting

Identifying declining sales or inventory risks required navigating multiple separate reports.

Complex Store Checks

Store-level comparisons and operational audits were time-consuming and manual.

Operational decisions relied heavily on manually generated reports, and existing dashboards prioritized data density over usability. The challenge was to design an enterprise analytics experience that simplified decision-making while effectively communicating MathCo's design and product capabilities during the RFP process.

03 — Goals & Criteria

Establishing a Single
Source of Truth

Centralized Dashboard
Provide a centralized business performance dashboard consolidating metrics.
Sales & Stock KPIs
Improve visibility into sales, inventory levels, and operational KPIs.
Faster Choices
Enable faster executive decision-making and risk mitigation.
Scalable Components
Create reusable dashboard components for future product line expansions.

04 — Responsibilities

My Design Role

As the Product Designer, I led the experience design for the dashboard concept, translating business requirements into an enterprise-grade analytical interface, responsible for:

Discovery

Understanding retail business workflows and identifying KPIs.

Info Architecture

Designing dashboard information architecture and wireframing flows.

Dashboard Design

Designing high-fidelity dashboard screens and building reusable UI components.

Handoff & QA

Creating interactive prototypes for client presentations and supporting design reviews.

05 — Interactive Prototype

The Home Depot RFP
Retail Simulator

Adjust the "Sales Target Growth %" slider and parameters to simulate the responsive dynamic rendering of Revenue, Forecast, Footfall, and YOY Growth metrics.

RETAIL OPERATIONS DASHBOARD
REACT COMPONENT
Product Category
Select Region
Sales Target Growth %
Target: 10%

Hardware & Tools Performance

SOUTHEAST REGION
ON TRACK
Total Revenue
$0
+0% vs Last Qtr
Revenue Forecast
$0
Based on Target
Store Footfall
0
+0% vs Last Qtr
YoY Growth
0%
+0% vs Last Qtr
Quarterly Revenue Trajectory

06 — Design System

Component Architecture

A modular component library was created to ensure consistency across dashboard experiences and support future scalability:

KPI Summary Cards
Interactive Filters
Geo Visualizations

07 — Research & Discovery

Retail Workflow Audits

Process Understanding

  • • Studying retail executive reporting workflows.
  • • Understanding complex inventory and sales management processes.
  • • Reviewing modern retail analytics platforms.

Pain Points Mapped

  • • Benchmarking enterprise BI dashboards.
  • • Identifying decision-making pain points for business stakeholders.
  • • Defining the KPIs most relevant to retail leadership.

The research highlighted that decision-makers valued clarity, speed, and business storytelling over large volumes of disconnected charts.

08 — Design Process

Iterative Methodology

1. Business Disc.
Understanding workflows & goals.
2. KPI Prioritization
Selecting launch success metrics.
3. IA Structure
Organizing into analytical sections.
4. Wireframing
Optimizing layout for scanning.
5. Hi-Fi UI
Polishing React interface specs.
6. Prototype
Simulating dashboard navigation.
7. Stakeholder Review
Iterating based on internal reviews.
8. Dev Collab
Ensuring technical feasibility.

09 — Journey Flow

Retail Executive
Monitoring Flow

Authentication & Overview
Login and access the Executive Overview Dashboard to review business KPIs instantly.
Analyze & Investigate
Analyze Sales Performance, monitor Inventory Health, and compare Regional Performance.
Drill-Down & Filter
Investigate operational anomalies by applying interactive filters (location, category, period).
Generate & Share
Generate custom business insights and share analytics reports with leadership.

10 — Key Decisions & Features

Architectural Choices

Executive Dashboard First

The experience opens with a concise executive summary featuring the most critical business metrics, allowing stakeholders to understand overall retail performance within seconds.

KPI-Driven Layout

Rather than organizing information by departments, the dashboard groups related KPIs together to support faster business decision-making.

Progressive Analytics

High-level metrics seamlessly transition into detailed analytical views through drill-down interactions, enabling users to explore underlying trends without leaving the dashboard.

Retail-Oriented Visuals

Charts, scorecards, inventory indicators, and performance heat maps were selected specifically to communicate retail business performance.

13 — Technical Challenges

Navigating Constraints

Stakeholder Appeal

Designing a dashboard capable of appealing to diverse retail corporate stakeholders during an RFP presentation.

Scope Limitations

Demonstrating advanced analytical capabilities and data volume clarity within a limited RFP timeline.

14 — Final Solution

Retail Operations Envisioned

The final solution delivered a modern enterprise dashboard that transformed fragmented retail metrics into an intuitive analytical experience. By emphasizing business storytelling, KPI prioritization, and interactive exploration, the design enabled stakeholders to move efficiently from executive summaries to operational insights. The dashboard also demonstrated MathCo's ability to combine strong UX thinking with enterprise-scale analytics, strengthening the overall RFP proposal.

15 — Business Impact

RFP Business Value

0
Unified Platform
Centralizes sales, inventory, and operations performance monitoring.
0%
Executive Visibility
Consolidates overall operations visibility into one overview page.
> 0
Reusable Design
Established components suitable for future product line expansions.

18-19 — Project Completion

Summary & Learnings

Designing an enterprise dashboard for an RFP reinforced the importance of communicating business value through design. Unlike production products, RFP engagements must simultaneously demonstrate strategic thinking, technical feasibility, visual excellence, and future scalability within a limited timeframe.

Enterprise Dashboard Design Retail Analytics UX Data Visualization KPI Framework Design Information Architecture Business Storytelling RFP Experience Design
Next Case Study
Otsuka Drug Launch Dashboard →
← Return to All Works