Project overview

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

Completion:
The project was completed in 1 day

Benefits:

  • Quick analysis and reconciliation of costs. Condensed time taken from 3 hours to 30 minutes