Reporting time cut from days to minutes with low-code dashboards
We built custom Retool BI dashboards for two clients: real-time fleet tracking for Poppy and fountain usage analytics for O25. Replaced multi-day manual reporting with on-demand dashboards.
At a Glance
- Reporting time cut from days to minutes
- 2 client dashboards built on Retool
- Live operational data for both businesses
Challenge
Two enterprise clients needed live business data but had no internal tooling to get it. Poppy required visibility into car rental fleet performance, document processing status, and revenue trends. O25 needed to track smart water fountain usage, water quality metrics, and sustainability impact across their growing network.
In both cases, reporting was a manual process. Staff compiled data from multiple sources into spreadsheets. It took days and produced static snapshots instead of live data. Neither team had the engineering bandwidth to build custom dashboards from scratch.
Solution
We built custom BI dashboards for both clients using Retool's low-code platform, connecting directly to their existing databases and APIs.
Poppy Dashboard
The Poppy dashboard tracks fleet availability in real time, shows document processing status, and charts revenue and booking trends. Automated reports replace the manual spreadsheets.
O25 Dashboard
The O25 dashboard shows live fountain usage, water quality metrics, environmental impact calculations, and user engagement. Operational cost tracking shows the team what the network costs to run.
Both dashboards run custom SQL queries, pull data from existing systems through their APIs, and refresh automatically so the numbers stay current.
Key Features
- Real-time fleet tracking: Live vehicle availability and booking status for Poppy
- Fountain usage analytics: Consumption, quality, and impact metrics for O25
- Custom SQL queries: Analysis that off-the-shelf reports don't cover
- API integrations: Direct connections to existing backend systems
- Automated refresh: Data updates on configurable cycles without manual intervention
Results
- Days to minutes: Reporting time reduced from multi-day manual processes to on-demand dashboards
- Decisions on live data for both fleet and fountain operations
- Better resource allocation, based on what the dashboards show
- Operational visibility for both businesses without building a custom application
Let's build your product
Tell us what you're building. We'll tell you how we'd approach it, what it takes, and how fast we can move.
We'll tell you honestly if we're the right fit. And if we're not, we'll point you to someone who is.