Business Intelligence and Analytical Reporting

Leave a Comment

Business Intelligence and Analytical Reporting

Analytical reports provided by Expertflow allow for drill-down using Pivot tables, relying on a data warehouse in the form of an OLAP cube, and using historical information from multiple data sources, i.e. internal or external to the contact center.

Your data analysts can slice and dice data from a cube using Excel Pivot tables as seen below, or one of the OLAP clients of your choice, namely SpagoBI, Pivot4j, EazyBI, Tableau, Apache Superset or Microsoft SSRS:

OLAP Cubes and Analytics

Our analytics package for contact centers comes with three pre-defined OLAP cubes, i.e. Agent_Cube, AgentSkillGroup_Cube, CallType_Cube analyzed by different dimensions, Time (year, day, hour,…), Agent, CallType, and SkillGroup. Cubes are used to study and understand what happened, why it happened and what changes should be made in the future. Users are free to have their own use of the cubes they can create their own tables depending on the type of analysis.

Beyond these three core cubes, the ETL (Extract-Transform-Load) layer of our Business Intelligence solution allows you to add further fields to your data analysis. We have also added two cubes for Call Accounting, so the same tool can be used for internal billing/ accounting to cost centers.

Hosted Approach

Some of our clients deploy a data warehouse and OLAP viewer solutions on their own servers. This premise-based approach is however very CPU-consuming and costly in terms of server requirements, especially if you don’t run multiple new reports every hour. This cost can be reduced by at least 90% if a hosted approach is chosen, using underlying technologies such as Amazon QuickSight and Redshift, Google BigQuery or Microsoft Azure Data Factory. In this hosted BI approach, your data is continuously encrypted, transferred to the hosted data warehouse, from where you can then run your data warehouse and analytics work. ExpertFlow can make all your customer collaboration data available on hosted data warehouses and OLAP viewers. The functionality is the same as for a premise-based solution.

Architecture

 

 

For Cisco Unified Contact Center Express (UCCX), Enterprise (UCCE or PCCE). You can request a quote here

Leave a Reply