Opportunity

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.

Challenges

  • 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.

Company Background

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.

Resources

PepsiCo demonstrates their use of Trifacta at Strata + Hadoop World 2015 NYC

Watch Video

How PepsiCo leveraged Trifacta to generate more accurate sales forecasts, faster

Download Case Study

Learn how PepsiCo's CPFR team leveraged Hortonworks and Trifacta to reduce analytic build time by 90%

Watch Webinar

How adopting Hortonworks, Trifacta and Tableau enabled PepsiCo to improve the speed and accuracy of their reporting processes

Watch Webinar

Read our customer success story to learn how PepsiCo cuts analysis time by up to 90% with Tableau + Trifacta

Download case study