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

Sign in

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

3AI Digital Library

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

  • The Impact of AI on Global Economy: Trends and Initiatives to Shape the Future

    Featured Article: Author: Princy Gupta, Data Analytics Leader, Honeywell Artificial Intelligence (AI) is revolutionizing the global economy, providing unprecedented opportunities for businesses and governments to thrive in the age of data. According to McKinsey’s latest report, AI is projected to contribute $13 trillion to the global economy by 2030, a figure equivalent to the output […]

  • A hacker broke into a Florida Water Treatment Plant

    A hacker broke into a Florida water treatment plant and ordered it to increase the amount of lye to extremely dangerous levels, officials said. . A hacker broke into a Florida water treatment plant and ordered it to increase the amount of lye in the water to extremely dangerous levels, officials said Monday. The plant […]

  • The Best Practices for IoT Analytics

    In most ways, Internet of Things analytics is like any other analytics. However, the need to distribute some IoT analytics to edge sites, and to use some technologies not commonly employed elsewhere, requires business intelligence and analytics leaders to adopt new best practices and software. There are certain prominent challenges that Analytics Vendors are facing […]

  • Driving innovation in B2B payments through AI

    Featured Article: Author:  Shireen Ali, Senior Vice President – Analytics, Citi The B2B payments sector is estimated to be a $120 trillion* business. Yet, despite recent technological advancements,  B2B payments still falls behind its counterpart, B2C,  in terms of both customer experience and efficiency. If you have to go out to a café and buy […]