PEPSICO - a consumer feedback solution
PEPSICO - a consumer feedback solution

Pepsico is one of the world’s largest food and drink corporations, and a multibillion dollar multinational has a truly colossal amount of data to consider. Their products are sold in over 200 countries, so each decision is felt on a global scale. Luckily, The Information Lab unlocked their data stories — and the project even won an internal reward.

Project goals

  • To share important insights with senior stakeholders and decision makers
  • Collate and prepare data from multiple sources
  • Develop a repeatable process
  • Ensure all data is accurate and secure with the necessary permissions and access centrally managed

Engagement

  • Requirements gathering workshops with key stakeholders to define report scope, content, features and deadlines
  • Data preparation and validation using Alteryx, which then created Tableau data sources ready for visualisation and analysis
  • The Information Lab provided training on Tableau Desktop, teaching users how to query their own data sources

Results

  • Suite of interactive dashboards that uncovered valuable new insights into Pepsico’s multibillion dollar eCommerce revenue stream
  • Multiple data sources combined into one suite of dashboards allowing a global view of the consumer feedback aspect of the PepsiCo business
  • The project has been nominated for an internal PepsiCo award thanks to its scale and transformative insights