All case studies. Browse by sector

DataCactus dataCactus
Case studies How we work
Talk to us

Case studies · Manufacturing

One view of five phone systems for a global manufacturer

Call data from five separate 3CX phone systems is pulled into one Azure data warehouse and reported in Power BI, replacing around ten hours a month of manual collection.

Client
A global bathroom-products manufacturer with five sites
Built with
3CX, Azure SQL, Power BI
Timeline
Four weeks from first installation to rollout

The problem

Each site ran its own 3CX phone system. There was no single view of call activity across the business, no cross-site reporting in real time, and someone spent around ten hours a month collecting the numbers by hand. The high-availability 3CX servers could not be disturbed.

What we built

  1. 1The DataCactus 3CX data integrator installed on each high-availability 3CX server, a few minutes per server
  2. 2Call records consolidated into a central Azure data warehouse
  3. 3Power BI reports on calls, queues and agents across all five sites, built against the KPIs agreed with stakeholders
  4. 4User acceptance testing with the people who read the reports, then rollout and training

What changed

  • —Manual monthly collection replaced by an automated feed
  • —One dashboard across all locations, so sites can be compared on the same numbers

This project became a ready-made offer you can start from.

See the offer

More in Manufacturing

Call outcome tracking restored after a phone-system migration A global bathroom-products manufacturer with five sites