India's largest platform and marketplace for AI & Analytics leaders & professionals

Sign in

India's largest platform and marketplace for AI & Analytics leaders & professionals

3AI Digital Library

Terminal Volume Forecasting

3AI August 12, 2020

Leading Player in Oil Processing Industry

Problem Statement

  • In-house forecasting of products was not giving accurate information; client wanted an accurate forecasting model.
  • Organization wanted assistance in understanding the appropriate KPI’s / metrics that have a direct influencing impact on the petroleum sales
  • Organization also wanted an forecasting model which will forecast at a Customer / Channel / Terminal level; to plan the inventory.

Analytics Led Approach

  • Selection of Response variables based on Statistical Tests.
  • Understand and identify the key KPI’s for each segment
  • SPSS to analyze data using Statistical techniques, user friendly (Multiple Regression Analysis)
  • Correlation Analysis to identify the relationship.
  • Regression Analysis to predict / forecast.
  •  

Business Impact

  • Pricing – Based on the existing / recent demand, pricing can be done without any intuition (By an Account Manager)
  • Trend Analysis. And structured steps to understand the relationships between multiple fields in the datasets.

Critical Success Factors

  • Channel Behavior – Depicts the prevailing fluctuation and also helps us in tracking the product at a channel level.
  • Pantry Loading – Over loading of products can be avoided and Inventory can be planned accurately to meet demand.

    3AI Trending Articles

  • Data Science/Machine Learning and Software Quality

    Featured Article: Author: Biju Kalleppilli, Director-Performance Engineering, SAP Labs India Endless possibilities of data science applications in Software quality are probably an underrated one. At various stages of product testing life cycle, huge amount of data is generated and remain unexplored., primarily because the top management often become happy by looking at the quality metrics […]

  • Data Science redefines Consulting to transform Digital Business Model

    Consulting firms the world over, are looking to develop competencies that would create a definite competitive advantage for them in the market. The consulting sector is no longer immune to disruptive technologies that have significantly influenced other digital-enabled businesses and is flooded with new players having a non-traditional approach toward consulting. Globally, companies seeking a […]

  • Global Captive Centers – The true enablers of Collaboration (Part-2)

    Featured Article: Author: Vinodh Ramachandran, Neiman Marcus Group In my previous article, I had spoken about some challenges due to a siloed working model within data & analytics teams in large retailers and how setting up a Data & Analytics CoE within the GCC can be a good solution. Lets look at a few ways […]

  • Combining the power of Generative & Predictive AI

    Featured Article: Author: Shuvajit Basu GenAI has taken the world by storm. I certainly don’t have to outline the numerous possibilities it brings to bear. Both GenAI and Predictive AI have their share of strengths andbopportunities. However, if we can combine the power of these Generative models with Predictive AI/ML models, we might be able […]