The ability to reproduce patterns makes building CPFR tools a more efficient, automated process.“We’re able to turn customer data around and present it to the rest of our company, in a way that everyone can understand, faster than our competitors,” says Mike.PepsiCo’s customers provide reports that include warehouse inventory, store inventory, and point-of-sale inventory. Analysts knew their ability to quickly standardize data across all retailers—and speak the same language as their customers—was critical to preparing data faster for their forecasting and planning efforts.The team primarily relied on Excel for analysis, creating large quantities of messy data. An empty shelf also risks consumers choosing a competitor's product, which has harmful, long-term effects on the brand.Wrangling this data was a challenge. At the same time, the team needed a visual analytics tool that could help the team make the most of PepsiCo data.This has dramatically reduced time spent on data preparation and increased the overall quality of the data. Now it takes less than 20 minutes,” says Mike.Trifacta integrates natively with Tableau Data Extracts (TDE), allowing PepsiCo analysts to seamlessly transition between the two technologies. Coke had customer level information and could target promotions and incentives more effectively than Pepsi. PepsiCo then reconciles this data with its own shipment history, production numbers, and forecast data.© 2003-2020 Tableau Software, LLC, a Salesforce Company. This process allows analysts to directly manipulate data using Trifacta.“Now we’re not taking our time putting the data together; we’re spending our time analyzing the data, telling the story, and finding problems,” Mike says.The journey to analytics success was not easy. Mike's team also collaborates with large retailers to supply the right quantities of product for their warehouses and stores.“Tableau not only serves as the corporate standard for business intelligence—the reporting on top of the enterprise data warehouse—but also as a self-service tool for analysts and departmental uses cases,” says Mike.By using Tableau to analyze Trifacta's normalized data, PepsiCo has reduced the end-to-end run time of analysis by as much as 70 percent. PepsiCo Latin America's trucks went out full and came back empty, says Diego Saenz, but the company needed to invest in big data in order to make sense of … For PepsiCo, the journey to analytics success was not easy. “Part of the ethos of the PepsiCo organization is selecting technology that will enable the business to self-serve and get IT out of the job of responding to every single question or demand from the business.”PepsiCo can now predict trends, adjust sales, and ultimately sell more of the right product to improve their bottom line.The combined use of Tableau, Hortonworks, and Trifacta helps the CPFR team drive the business forward, increasing visibility into customer orders.
I graduated from the University of Chicago in 2006 with degrees in…As a former CIO I think it starts with the CIO. It starts with asking the right questions and then taking the time to find the answers, this tends to be an iterative process as answering one question will raise more questions as you begin to discover the meaning and opportunities hidden within the data. Organizations like Procter and Gamble assign embedded data analysts to business units, and these analysts are dedicated to helping the business units team do this kind of analytics work.