Analytics & dashboardsFacilities · Retail
Contractor performance (modeled on CVS)
Which maintenance contractors cost the most and miss their deadlines
18%of work orders overdue, on average
Made-up data, modeled on how a CVS facilities team could work. I built it because I wanted to work with CVS; it isn't CVS data.
Open the live dashboard (opens in a new tab)See the code on GitHub (opens in a new tab)
Proof you can check:Live dashboardCode on GitHubLimits said openly
Analytics & dashboards
Some vendors miss half their deadlines
- 18%of work orders overdue
- $1,340average work order
- 134 minaverage response
- Midwest$1,418
- West$1,352
- Northeast$1,339
- South$1,276
Lubo Bali · lubobali.com
The problem
Big retail chains pay many contractors to fix their stores. Without measuring them, late and expensive vendors stay hidden in the budget.
What I built
A small pipeline (Flask API → PostgreSQL → daily CSV export) and SQL that answers 4 questions: cost per order, who is late most, who costs most, how fast they respond. Tableau puts it on one executive screen.
Tech & why
SQL and Tableau, the tools facilities and finance teams already use, so anyone can check the numbers and rerun them every month.
- SQL
- Tableau
- PostgreSQL
- Flask
- Python
The result
An average order costs $1,340 (the Midwest costs most), 18% of orders are late and some vendors miss half their deadlines: clear targets for the next contract talk.
See the real dashboard
Similar projects
- Data pipelinesTicketDesk-AIA support desk on Databricks Lakebase, built like a trading terminal180 tests, run against a real Postgres database
- Analytics & dashboardsSupply chain delaysWhich shipping methods arrive late, and where the profit really comes from37% of First Class orders arrived late
- Analytics & dashboardsFood delivery customers: who buys whereWhich channels customers really use, and which ones overlap, from 2,022 delivery customers23,474 in-store purchases, vs 16,634 on the web
Have a problem like this? Get your free AI blueprint in about a minute.
