All work

Retail

Retail Analytics Dashboard

Store-level analytics for a national retailer, refreshed hourly.

Problem

Regional managers had no visibility into store performance until weekly PDF reports arrived.

Solution

A cloud data warehouse and an executive dashboard with role-based views down to the SKU.

Impact

Measured outcomes

  • Same-day corrective action on outliers
  • 3.4% lift in same-store sales
  • Reporting effort down 80%

Stack

  • Power BI
  • SQL
  • Python
  • Azure

Next project

Manufacturing BI Platform

Continue