← Back to workNext Up:Clinical AI Chat

Retail Intelligence Dashboard

Visit foxs.com ↗
Next.jsSQL ServerDashboardsIntegrationsLegacy SystemsMarketing Automation

$28M+

Annual inventory spend informed

30+

Daily users

1,000+

Annual vendors managed

20K+

Annual SKUs

Fox's internal business intelligence platform consolidates legacy reporting tools and scattered operational data into one system used daily by 9 buyers, executives, 20+ warehouse staff, and a 5-person e-commerce team.

Problem

  • Legacy reports drove buying, inventory, warehouse, and store ops.
  • Data fragmented across POs, warehouse tickets, and per-store invoices.
  • Product images lived on buyers' laptops with no central store.
  • Reporting was slow, static, and non-interactive.

Solution

I built a centralized business intelligence platform on top of the existing retail data stack. It brings purchase history, vendor data, warehouse activity, store-level invoices, SKU performance, pricing, sell-through, and product images into one internal system. The result is a single operating layer for buying, executive reporting, warehouse workflows, and e-commerce production.

Highlighted features

Central Performance Dashboard

Executive view into sales, inventory, sell-through, and business performance.

Interactive Master Vendor Table

Vendor data in one searchable working surface for buyers and leadership.

Vendor Detail + Best Sellers

Drilldowns for vendor performance, best sellers, pricing, and SKU movement.

Distribution + Process Lists

Reports that support daily warehouse distribution and processing decisions.

Store Email Automation

Weekly per-store email templates generated from new arrivals unique to each store.

Challenges

  • Legacy systems and reports: coming in and understanding a 20+ year old codebase with hundreds of deprecated tables and concepts.
  • Self direction and prioritization: mapping which changes create the highest leverage for driving ROI and value creation across the business.
  • User adoption: working closely with teams in stores, office, and warehouse to train new systems and iterate feedback into changes.