Data visualization for call center

Case


The project goal was to develop a set of KPI for the call center and then create system of online updated dashboards using the data in several database sources (Oracle, SQL Server, MySQL)

Solution


Dashboards creation with interactive visualization and possibility of drilling down to detailed information about valuable KPI and performance indicators. All the dashboards were implemented using Microstrategy.

Challenges


Online updated databases with no historical information
Serious database capabilities restrictions with no possibilities to create datamarts for dashboards

Project info

Industry
Telecommunication
Case
Estimate the call center performance and establish a set of KPI
Technologies
PL/SQL, MySQL, Microstrategy
Team
2 DB Developers, Data Analyst, Project Manager.
Terms
2 months overall