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

Abdul 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

  • Mirae Asset Launches $35 Mn Early Stage Fund For India

    The Mirae Asset Venture Opportunities Fund will have an average ticket size of $2 Mn – $4 Mn The early stage fund will back up the Mirae Asset-Naver Asia Growth Fund, which was launched in 2018 Besides its new early stage fund, Mirae Asset has invested in Ola, Bigbasket, Zomato, Shadowfax and other Indian startups […]

  • CES 2021 conference stress importance of security education

    Experts at the CES 2021 conference stress importance of security education The “second age” of quantum computing is poised to bring a wealth of new opportunities to the cybersecurity industry – but in order to take full advantage of these benefits, the skills gap must be closed. This was the takeaway of a discussion between […]

  • Future of HR redefined by AI

    Artificial intelligence is transforming our lives at home and at work. At home, you may be one of the 1.8 million people who use Amazon’s Alexa to control the lights, unlock your car, and receive the latest stock quotes for the companies in your portfolio. In total, Alexa is touted as having more than 3,000 skills […]

  • How AI is transforming Financial Services

    Since its inception, AI has experienced at least two major hype cycles with resulting winters of disillusionment. Although after the first “winter”, many financial firms deployed a number of successful applications, by the 1990s, AI went into its second winter of disillusionment as realization set in that these systems were harder and more costly to build and maintain […]