Business Analysis

From Projects
Jump to: navigation, search

Visual Tools and Model Development

Organizations require effective layouts of information to understand results, discover patterns, tabulate findings and develop strategies based on this data. I have provided a variety of models, reports and visual analysis tools utilizing a wide variety of applications to help businesses uncover information.

Shiny & R Studio

R Studio and Shinyapps allow dynamic visualization and working models, exposing to an online interface. In this example, we've created an online visualization of the "Power of One" - showing the importance of how losing (or gaining) a single call center rep can dramatically impact interval service level.

Tableau Visual Analytics

Xcelsius Models

Resource management requires the analysis of many scenarios to develop effective, cost-efficient strategies for staffing call centers against demand. To assist in the visualization of the impact in changing variables within a model, I have developed a series of call center calculators.

What-If Improvement Models

Call centers are frequently challenged to improve various metrics to lower operational costs; reducing shrinkage, improving AHT, cutting out repeat calls or volume reduction in general, or obtaining higher levels of occupancy. The following calculator was developed to visualize the financial impact when assumptions around improving any or all of these variables were made.

This calculator is powerful in demonstrating that while initial returns can be significant, long-term reduction in operations costs to call centers requires both tight workforce management and a sustained effort to effectively shift customers self-service models for appropriate inquiries.

Headcount Capacity Calculator

How many calls can 100 reps handle, based on ___% Shrinkage and ___% Occupancy for a pool of calls which average ___ AHT? Often, resource management is asked to determine how many calls can be handled by a pool of representatives. This call calculator allows you to quickly dial in the answer

This calculator also allows you to model the impact that shrinkage has on your total workload which can be handled. Training at 5% vs 6%? Absenteeism at 7% vs 10%? Dial in the questions to determine the impact on call capacity that your pool of agents can handle.


Call Capacity Calculator

Simply the reverse of the above, the call capacity allows you to dial in the projected monthly call volume to determine the number of representatives needed to support that call load. This calculator comes in two flavors - zero to 1 million calls and one for zero to 10 million calls per month.


Service Level Recovery Cost

The Service Level Recovery Calculator utilizes the relationship between running at low service levels for sustained time periods, and the increased average handle time. Many studies show a clear relationship between operating a call center where service level is not met, the result of which is a high occupancy level. When agents do not have natural breaks that occur when maintaining service levels where 80% or more of calls are answered under 30 seconds, AHT extends to create breaks within the actual call itself.

This calculator starts with a 1:1 relationship between SL deterioration and AHT increasing, with 10 seconds added to AHT for every 10 points of service level deterioration. This calculator allows you to adjust this relationship based on the tolerance your workforce has in maintaining the same AHT targets under the pressure of operating with service level deterioration.

This calculator is primarily used to demonstrate the cost of operating at a low service level for a sustained period of time.

Collections Cost Per Call Calculator

The Collections Cost Per Call Calculator was developed to be used in modeling a strategy for introducing attribute routing for calls which originate from a service interruption being initiated to collect payment.

This calculator allows call volumes to be segmented into three buckets, assuming the application of attributes to route calls. Once attributes are applied, and volumes identified, the calculator allows different AHT, Occupancy and labor costs to be applied in order to determine a cost per call by segment, as well as a blended cost per call.

This calculator assumes a basic premise that "High Value" calls are contained with an "internal labor rate" and that "Low Value" calls are contained with an "external labor rate". For the "Medium Value" segment, there is a slider which allows you to segment these calls to any % of resources associated with the internal or external labor rate.

The calculator has you dial in the high value and medium value buckets, with low value calculating the balance based on the two higher segments.

Crystal Xcelsius™

The calculators above are built using Crystal Xcelsius™.

What Is Crystal Xcelsius™?

Crystal Xcelsius™ is a leading edge Microsoft Windows application that brings data to life!

Using breakthrough technology, Crystal Xcelsius™ bridges the gap between data analysis and visual presentations, empowering users of all proficiencies to create visually stunning interactive reports and applications.

With Crystal Xcelsius™, users can communicate data in a clear and powerful style that's appealing to the mind and to the eye.

Crystal Xcelsius™ is intuitive enough for beginners and versatile enough for advanced users. Most importantly, it makes the process of generating reports and applications fun, without requiring users to learn arcane programming languages. With Crystal Xcelsius™, simply pointing and clicking your mouse can create rich interactive presentations.