CASE STUDY · 2026 · BEAUTY
ONGOING · EXECUTIVE DASHBOARDS

A wall of spreadsheets, replaced by one dashboard.

Tracking weeks-of-stock across The Lip Bar's warehouses meant juggling a stack of Excel files, updated by hand every week. I built a single dashboard the operations director refreshes weekly, every product entry, every warehouse, in one view. (Data shown is template/placeholder.)
STOCK DASHBOARD
1

Every warehouse, one view

REFRESH CADENCE
WEEKLY

Updated in minutes, not hours

MANUAL SPREADSHEETS
0

The stack it replaced

The problem.

Tracking week-of-stock across multiple warehouses meant juggling a stack of Excel files, updated by hand every week. It was slow, error-prone, and impossible to get a clean cross-warehouse view from at a glance, exactly the view the operations director needed to make decisions.

The approach.

I built a template dashboard for weeks-of-stock: every product, every warehouse, in one place, designed to be refreshed weekly by the ops director rather than rebuilt from scratch each time. The layout leads with what needs attention, not a raw grid of numbers. (The data shown is template/placeholder.)

The outcome.

The weekly stock review moved from a spread of manual spreadsheets to a single dashboard the ops director updates and reads in minutes. Every product entry across warehouses is now trackable at a glance, the whole process streamlined into one screen.

Running operations out of spreadsheets?

If a weekly process lives in a stack of hand-updated files, I'll collapse it into one dashboard your team actually maintains. One slot open for Q3 2026.

BOOK A 20-MIN CALL