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

Sign in

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

3AI Digital Library

Price Index Report Automation

September 10, 2020

Top FMCG manufacturer in the world

Problem Statement

  • Company was reporting price index figures of 200+ variants from over 28 countries
  • Sales volume and sales value of each of these variants came from separate legacy systems
  • The systems reported the dates in varying formats (some even incorrect and some in native language)
  • Company had to manually process these in excel which was taking over 2 weeks for every monthly report

Analytics Led Approach

  • Built a robust algorithm to overcome the manual reformatting effort that was required to prepare the global price index reports
  • A common algorithm was formulated to handle any report that came from any of the legacy systems currently in place
  • Provisions were provided to handle more formats that can arise in the future

Business Impact

  • Results can now be generated at the click of a button in Alteryx
  • Greatly reduced the manual effort involved in processing the reports in excel
  • A reusable module was given that can be used to handle new brands and variants as and when they get introduced
  • Reports can be run from anywhere in the world
  • Error reporting greatly reduced time spent on quality checks

Critical Success Factors

  • Process that took 2 weeks was reduced to less than 1 minute
  • Highly scalable solution – algorithm designed to handle newer formats for new brands & variants
  • Portable Solution – report can be run from anywhere in the world

    3AI Trending Articles

  • Human Behavior & Human Data: Beyond Big Data

    In recent years, there has been a lot of hype around “big” data in the marketing world. Big data is extremely helpful with gathering quantitative information about new trends, behaviors and preferences, so it’s no wonder companies invest a lot of time and money sifting through and analyzing massive sets of data. However, what big data fails […]

  • Using AI to Outwit Malicious AI

    Robust Intelligence is among a crop of companies that offer to protect clients from efforts at deception. IN SEPTEMBER 2019, the National Institute of Standards and Technology issued its first-ever warning for an attack on a commercial artificial intelligence algorithm. Security researchers had devised a way to attack a Proofpoint product that uses machine learning to identify spam emails. The system produced email headers […]

  • Cloud Infrastructure market: Amazon, Microsoft, and Google continue to thrive

    Even in the middle of a pandemic, companies including Amazon, Microsoft, and Google continue to thrive thanks to their control over the cloud infrastructure market. When we talk about regulating big tech, the discussion usually centers on online privacy and location tracking, but we never seem to discuss the control these companies have over a vast […]

  • Blockchain-Based Stock Exchange in Japan by 2022

    The exchange reportedly planned by SBI and SMFG is expected to be the first of its kind in Japan. SBI Holdings has reportedly partnered with Sumitomo Mitsui Financial Group (SMFG) to launch a digital stock exchange slated for spring 2022. SBI and SMFG are expected to launch the platform in Osaka to compete against the […]