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

  • Accentuating customer experience: Digital Chat Agents & Chatbots

    As e-commerce (and retail in general) becomes increasingly global and competitive, business leaders understand that AI can be a valuable tool in reconnecting with consumers. AI has the power to analyze huge amounts of data from numerous sources, including human behaviors and emotions. This can then be used to create more meaningful customer experiences. Take, […]

  • Changing face of Algorithms

    In the age of Big Data, algorithms give companies a competitive advantage. Today’s most important technology companies all have algorithmic intelligence built into the core of their product: Google Search, Facebook News Feed, Amazon’s and Netflix’s recommendation engines. “Data is inherently dumb,” Peter Sondergaard, senior vice president at Gartner and global head of Research, said […]

  • Property Registration in Karnataka to use Blockchain Technology

    Property registration in Karnataka is all set to become more secure and hassle-free, with the state government developing a system based on blockchain technology for online property documentation. The new system, developed in collaboration with IIT-Kanpur, promises an immutable electronic storage of property data through blockchain. In other words, data once stored cannot be changed, […]

  • Transformation of Talent Acquisition by Algorithms

    Business leaders have long recognized that the ability to hire the right talent plays a significant role in any organization’s performance. Views about the challenges to acquiring and retaining such talent have evolved over time. We have moved on from a focus on the notion that a talent shortage is creating a “war for talent,” an […]