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

Sign in

India's largest platform 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

  • Emerging role of Generative AI for Businesses

    Featured Article: Author: Rajan Gupta, VP & Head of Research & Analytics, Analyttica Datalab Artificial intelligence (AI) has revolutionized the way businesses operate, and Generative AI (GAI) is quickly becoming a hot topic in this field. Generative AI is the technology behind applications that can produce new content, such as images, sounds, and even text. […]

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

    Featured Article: Author: Vinodh Ramachandran, Neiman Marcus Group Through my experience working for large retail GCCs I. have observed that most retailers, in addition to having a central data & analytics team (typically within tech rolling up to the CIO), also have analytics teams within the businesses running independently and managing all their data, reporting […]

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

  • Impact of AI on Data Anonymization

    Featured Article: Author: Mohan Khilariwal, DGM, Data Engineering, Analytics and Data Science, HCL Technologies Data anonymization has become much more critical as we are into the era where data sharing is becoming a necessity in order to serve the customer, new business opportunities, Governments want to take help from the industry to serve its people […]