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

Sign in

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

3AI Digital Library

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 will drive next wave of Digital Transformation: A perspective

    In the past months, most of you may have run into a situation where you open the GPS app on your smartphone and it ‘knows’ where you would like to go because it fits a certain repetitive pattern of behaviour or the photo app organizing your pictures based on who are the most important people […]

  • European Union to revamp Cybersecurity rules

    EU last year recorded around 450 cyber incidents involving European infrastructure, notably in the financial and energy sectors, and the pandemic has highlighted Europe’s deep dependence on the internet and exposed security weaknesses.  The European Union unveiled Wednesday plans to revamp the 27-nation bloc’s dated cybersecurity rules, just days after data on a new coronavirus vaccine was unlawfully accessed in […]

  • ISRO Regional Academic Centre for Space at IIT-BHU

    IIT-BHU director Prof P.K. Jain said that the RAC-S will act as a major facilitator for promoting space technology activities in the states of Uttar Pradesh, Madhya Pradesh, and Chhattisgarh. VARANASI: The Indian Space Research Organisation (ISRO) will set up its Regional Academic Centre for Space (RAC-S) at IIT-BHU here. A memorandum of understanding (MoU) […]

  • Microsoft Announces Limited Access to its Custom Neural Voice

    Microsoft announced limited access to its neural text-to-speech AI called Custom Neural Voice. The service allows developers to create custom synthetic voices. . The Custom Neural Voice is a Text-to-Speech (TTS) feature of Speech in Azure Cognitive Services that allows users to create a one-of-a-kind customized synthetic voice for their brand.  Since the preview last year in September, the […]