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

Sign in

India's largest platform and marketplace for GCC & AI leaders and professionals
Become a Thought Leader
Become a 3AI Member

Sign in

3AI Digital Library

< Go Back

Terminal Volume Forecasting

3AI September 10, 2020

Leading Player in Oil Processing Industry

Problem Statement

  • In-house forecasting of products was not giving accurate information; company wanted an accurate forecasting model.
  • Company wanted our assistance in understanding the appropriate KPI’s / metrics that have a direct influencing impact on the petroleum sales
  • Company also wanted a 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

  • A peek into how AI will dominate functioning of Next Gen GBS

    Author: Saswata Kar, Head – Analytics & Data Sciences, Philips GBS | LinkedIn – https://www.linkedin.com/in/saswata-kar-95b9074/ Global Business Services or GBS is the collective name given to centralized hubs where big corporations have moved processes that can benefit from centralization, standardization, and automation. The location for these centers is largely governed by cost considerations and talent […]

  • Cross-Validation techniques to assess your model’s stability

    Featured Article: Author:  Sai Nikhilesh Kasturi, Data Science & Analytics, Customer Insights & Analysis, American Airlines One of the foremost interesting and challenging things about data science hackathons in Kaggle is struggling to maintain the same ranks on both public and private leader boards. I also have been a victim in struggling to keep the […]

  • CES 2021 conference stress importance of security education

    Experts at the CES 2021 conference stress importance of security education The “second age” of quantum computing is poised to bring a wealth of new opportunities to the cybersecurity industry – but in order to take full advantage of these benefits, the skills gap must be closed. This was the takeaway of a discussion between […]

  • 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 […]