This project had 3 huge Excel files as the data source, comprising of Outbound calls, Inbound calls and data generated by my client’s PBAX call log. The client wanted to reconcile costs and call volumes as shared by the mobile service provider and what was generated by the PBAX.
Technology stack used:
– MS Power BI
– Query Editor
The project was completed in 1 day
Quick analysis and reconciliation of costs. Condensed time taken from 3 hours to 30 minutes