proxim managed analytics case studies

Client is Insurance Provider operating several large call centers. Agents handle new policies, claims, and other inquires. Agents have expected metrics related to number of calls they are expected to take daily per client.  KPI also includes total amount of time agents are expected to spend on calls.

Problem:

Measuring agent performance in real time, as well as analyzing historical performance was a laborious process requiring several admins. Data could never be made available in real time so management could adjust operation on daily/hourly basis to meet client’s expectations and to manage changes in supply/demand.

Solution:

Proxim Managed Analytics was deployed leveraging best practices for analytical data modeling to materialize multiple data layers for staging, data integration, data denormalization, and OLAP.
ETL was implemented having framework driven inclusion of lineages, and technical controls.
Source data is loaded with 10 minutes latency to managed analytics storage.
Incremental data loads take less than 2 seconds.
Managed Analytics BI dashboards include drill into and drill across reports.

An International organization has a waste management operation in Latin America. Metrics relevant to driver hours, tons of waste being processed, routes, as well as maintenance cost need to be made available in real-time fashion so management can have insight in how efficient business operates and if business objectives are being met.

Problem:

Information was collected manually in spreadsheets, sourced from vehicle logs and waste management stations logs. Staff working on compiling data often made mistakes with populating data into workbooks. Reporting was limited to Excel reports. Data was made available to management with weeks delays, delivered via emails, difficult to review, especially away from the office, on mobile devices. There were no capabilities to provide historical reporting for more than 2 months.

Solution:

Proxim Managed Analytics was deployed leveraging best practices for analytical data modeling to materialize multiple data layers for staging, data integration, data denormalization, and OLAP.
ETL was implemented having framework driven inclusion of lineages, and technical controls.
Source data is loaded with 10 minutes latency to managed analytics storage.
Incremental data loads take less than 2 seconds.
Managed Analytics BI dashboards include drill into and drill across reports.

Large US based Power company needed insight in accounts payable header and detail as well as purchase orders records for last nine years. Source data resides in SAP and Oracle Financial. Data needed to be available for historical analysis, identifying errors/exceptions, including the ability to drill into all hierarchies of data as well the ability to drill across all available dimensions.

Problem:

Information could not be queried from source systems to provide analysis across time.  Reporting tools used didn’t provide for analytical capabilities expected by analysts.

Solution:

Proxim Managed Analytics was deployed leveraging best practices for analytical data modeling to materialize multiple data layers for staging, data integration, data denormalization, and OLAP.
ETL was implemented having framework driven inclusion of lineages, and technical controls.
Source data is loaded with 10 minutes latency to managed analytics storage.
Incremental data loads take less than 2 seconds.
Managed Analytics BI dashboards include drill into and drill across reports.