PepsiCo’s success hinges on near-perfect sales forecasts. Analysts must constantly compare sales results against forecasts for their largest retailers to drive inventory and production plans.
- PepsiCo’s team is responsible analyzing performance sales for 10+ retailers to provide guidance, which required each analyst to manually build and update 4-5 reports weekly.
- Analysts leveraged Excel and Access, which was slow, laborious and prone to error.
Solution with Trifacta
- Trifacta allows PepsiCo to wrangle data at an organizational scale as a centralized solution to prepare data for forecasts in Tableau.
- With Trifacta, reporting time has been reduced by 70% and build time has been reduced as much as 90% from their previous method, allowing PepsiCo to respond to sales trends more quickly to reduce waste and cost.
PepsiCo products are enjoyed by consumers one billion times a day in more than 200 countries and territories around the world. PepsiCo generated more than $66 billion in net revenue in 2014, driven by a complementary food and beverage portfolio that includes Frito-Lay, Gatorade, Pepsi-Cola, Quaker and Tropicana. PepsiCo’s product portfolio includes a wide range of enjoyable foods and beverages, including 22 brands that generate more than $1 billion each in estimated annual retail sales. For more information visit www.pepsico.com.