Case Studies

Business Insights

Business Challenge: A beverage client needed a complete annual business review Approach: Exhaustive analysis of sales and share trends for client brand and competition, pricing activity, promotional activity, performance by class of trade, by region and for key retailers, evaluate new product activity

Automation

Business Challenge: A CPG manufacturer had a manual data load and refresh process and they were spending over a week every month to update forecasts in their Business Plans. They were not spending enough time to understand drivers of forecast variance to better inform their forecasts. There were manual errors from copying & pastin...

Visualization

Business Challenge: A CPG manufacturer wanted to integrate data from different sources and provide reports via a web based tool to the Sales & Marketing team to be able to track and analyze sales performance of products and brands. Approach: Developed a reporting and visualization application for custom and dy...

Data Integration

BUSINESS CHALLENGE: A CPG manufacturer needed to integrate, align and provide robust reporting capability for real time analysis. They had multiple, disparate data sources, with different definitions for product, geography and channel. Manual efforts to align resulted in substantial work with significant accuracy issues ...

Inventory Optimization and Obsolescence Mgmt

BUSINESS CHALLENGE: A Retailer was seeking to reduce the size of inventory, reduce ordering costs and prevent Out of Stock APPROACH: Developed a replenishment model taking into consideration factors like space availability, inventory carrying capacity, cost etc.) and deployed an inventory optimizer tool.

Travel Expense Forecasting

BUSINESS CHALLENGE: A CPG manufacturer wanted to leverage their Travel expense reporting system to forecast travel expenses based on historical and known events as well as understand key drivers of change in travel expenses quarter on quarter. APPROACH: Integrated internal data (expenses by type/unit, etc.) an...

Employee Satisfaction Analysis

BUSINESS CHALLENGE: A technology company was seeking answers to the following questions - What is my overall employee satisfaction score? Which departments are more satisfied and what are the significant drivers of satisfaction? Is there a correlation between staff satisfaction and sales? APPROACH: Developed eco...

Customer Retention

BUSINESS CHALLENGE: A retailer wanted to identify shoppers who are most likely to switch to competitive retailer and also understand the triggers of switch so that they can pro-actively retain the high risk customers through marketing communications APPROACH: Developed customer value segments from purchase data ...

Customer Growth

BUSINESS CHALLENGE: A retailer wanted to develop a scoring algorithm to identify customers who have a higher propensity to buy from among dormant accounts for effective targeting APPROACH: Developed algorithm using propensity modeling, scored loyalty members on propensity to buy and selected those who have the...

Customer Acquisition

BUSINESS CHALLENGE: A retailer wanted to use POS data to determine which items have a higher propensity to attract shoppers to the store and also identify which households have the highest propensity to convert into frequent shoppers. APPROACH: Integrated POS data with variables such as loyalty index and store ...

Page 1 of 21 2

Top