Case Studies 3

Objective: To do demand and sales forecasting for all the products of the company

Solution Approach: Forecasting was done by using time series analysis method that analyzed historical data and demand trends and calculated variance.

Results:

• Achieved better production planning
• 92% of the total demand for core products met
• 83% of the total demand for accessories met

Technology Stack: Oracle, SAP, Salesforce, Informatica and Tableau

Objective: To do Mean time between failures (MTBF) analysis for a sample size of more than 1000. [MTBF is the probability of a mechanical or electronic devise/system to fail during normal system operation.]

Solution Approach: MTBF identified using Dynamic Tableau solution. The analysis was done on the basis of product data available in the organization which gave actual probability value based on the number of products returned to the organization.

Results:

• The company offered a longer factory warranty period
• Customer experience is increased by 18%
• Customer reorder is increased by 23%

Technology Stack: Tableau, Datameer and Oracle