Back to the wall of works
Quest IIDashboard
Lumen Ledger
A spending dashboard small studios actually open every morning.
Turned a wall of spreadsheets into a calm dashboard with forecasts, alerts and one-click monthly reports.
RankA
- Patron
- Lumen Finance
- Role
- Full-stack Developer
- Year
- 2024
Dashboard
The threat
The finance team rebuilt the same twelve spreadsheets every month and only spotted overspending weeks after it happened.
The strategy
I designed the dashboard around the three questions the team asked every day, then automated the reports they used to assemble by hand.
The victory
Month-end reporting went from three days to twenty minutes, and overspend alerts now arrive within the hour.
Spoils of victory
- Reports in 20 minutes, not 3 days
- Overspend alerts within an hour
- Used daily by 40 people
Instruments
- React
- Node.js
- Recharts
- SQLite
Your chapter
Have a commission like this?
Tell me about it. I will reply within two days with ideas, a plan and an honest estimate.
Contact me