15 days of manual reporting, replaced by dashboards that update themselves
By the time leadership saw last month’s numbers, the month was already over. A live data warehouse fixed the timing problem for good.
About the client
Custom Truck One Source provides specialised truck and heavy-equipment sales, rentals and service across North America. Growth through acquisition left reporting scattered across multiple ERPs.
The Challenge
A central warehouse feeding live Power BI dashboards
Alphavima built a centralized data warehouse on Azure with automated ingestion pipelines (Azure Data Factory) drawing from each ERP continuously, validating and reconciling data in flight. Role-based Power BI dashboards give executives, branch managers and finance one live view of sales, rentals, service and inventory, replacing the 15-day Excel assembly line entirely.
How the rollout ran
Discovery
ERP audit, reporting inventory, data mapping
Warehouse build
Azure foundation and pipeline development
Dashboards
Power BI models, role-based views, UAT
Go-live & adoption
Rollout, training, managed handover
What changed
- 15-day manual reporting
- Disconnected ERPs
- Data silos
- Delayed decisions
- Real-time dashboards
- Centralized warehouse
- Automated ingestion
- Improved reporting accuracy