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