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

Sign in

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

Sign in

3AI Digital Library

< Go Back

Price Index Report Automation

3AI 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

  • AI in Drug Discovery

    Featured Article: Author: Vijay Morampudi, Director & Head of AI, Wavelabs Technologies Drug discovery takes 12-15 years and a median investment of nearly $1 billion to bring a new drug to market. While the true cost of research and development may be as high as $2.5 billion per marketed therapy, when factoring in abandoned trials and […]

  • Mindtree achieves Application Development Partner Specialization in the Google Cloud Partner Advantage Program

    Mindtree on Monday announced that it has achieved the Application Development Partner Specialization in the Google Cloud Partner Advantage Program Technology services company Mindtree on Monday announced that it has achieved the Application Development Partner Specialization in the Google Cloud Partner Advantage Program. “This specialization highlights Mindtree’s expertise and success in building customer solutions in […]

  • PoS Terminals Open Consumers to Fraud

    Point-of-sale terminal vendors Verifone and Ingenico have issued mitigations after researchers found the devices use default passwords. Point-of-sale terminal vendors Verifone and Ingenico have issued mitigations after researchers found the devices use default passwords. Researchers are detailing widespread security issues in point-of-sale (PoS) terminals – specifically, three terminal device families manufactured by vendors Verifone and […]

  • Way to make object-recognition models perform better

    Adding a module that mimics part of the brain can prevent common errors made by computer vision models. Computer vision models known as convolutional neural networks can be trained to recognize objects nearly as accurately as humans do. However, these models have one significant flaw: Very small changes to an image, which would be nearly […]