Coca-Cola

8 CASE STUDY coca-colacompany.com ALTERYX + COCA-COLA TASTE THE FEELING: COCA-COLA + ALTERYX Visiting The Coca-Cola Company headquarters in downtown Atlanta feels a bit like stepping back in time, while simultaneously catching a glimpse of the future. Coca-Cola’s long and storied history “The part I play in that vision is begins in 1886, when imaginative behind the scenes. Picture all the pharmacist Dr. John S. Pemberton took places you could buy a Coca-Cola his most recent invention, a concentrated within a one-mile radius of your syrup, to his local pharmacy, where it home. Now think about that idea at a was to be served from the newfangled larger scale—all the places you could soda fountain. During his first year in get a Coca-Cola product across the business, Pemberton sold approximately globe. That’s the volume of data we nine glasses of Coca-Cola a day. Today, deal with every day,” Jay explains. over 1.9 billion Coca-Cola beverages are enjoyed daily around the globe. “My role is explicitly analytical, but in today’s day and age, every group How did Coca-Cola grow from a modest is dependent on data, from audit and neighborhood concoction to one of finance to production and delivery. the most beloved beverages and iconic We need to understand every single brands in the world? The answer to that step of our customers’ journey to question is as mysterious as the top- continue delivering on our promise secret Coca-Cola recipe itself, yet one of happiness. thing is crystal clear. Over the years, ALTERYX IS ONE OF THE Coca-Cola has managed to balance a commitment to its rich history with a PLATFORMS WE USE TO relentless pursuit of innovation around MAKE SENSE OF ALL THAT one simple goal: making people happy. ESSENTIAL INFORMATION I’ve worked at Coca-Cola for 18 years,” We use Alteryx to merge, prepare, and offers Jay Caplan, Senior Business analyze data from multiple disparate Analytics Manager at Coca Cola. “A lot of sources and make our insights things have changed—the campaigns, the accessible across the organization. trends, the technology—but our vision It’s the key to unlocking the value of has stayed the same. our data. COCA-COLA STILL REPRESENTS PAUSING FOR A MOMENT OF HAPPINESS. Alteryx + Coca-Cola

8 CASE STUDY “The first time I used Alteryx was about three years ago, before anyone in my office had started using it. I was trying to make sense of our bottling data. The massive datasets I was pulling in from our data repository kept blowing up Access and Excel. I downloaded an Alteryx trial, and within three hours I was able to create the database I needed, despite being completely new to the tool. The fact that I could process over 4.5 million rows of data from separate data sets without writing a single line of code was just incredible. From that moment on, I was hooked.” A long, double-sided line of tape “We recently decided that we wanted spans the length of Jay’s windowpane, to expand our reach externally and covered in stickers of his favorite use machine level Freestyle data to Alteryx workflow tools, each one a help restaurant owners make more visual representation of an analytical data-driven business decisions. functionality, such as a fuzzy match join I SUPPORT ONE OF OUR and a Naïve Bayes classifier. “The 21st LARGEST GLOBAL ACCOUNTS, century toolbelt,” Jay jokes. TASTE THE FEELING™ “Ever since that first use case, I’ve WHICH IS COMPRISED OF been a huge fan of Alteryx. In fact, the THOUSANDS other day when I showed one of our OF FRANCHISEES internal analysts a newly completed SELLING CLOSE TO workflow, they were so impressed that they got their own team Alteryx 1 BILLION licenses. There’s just something BEVERAGES PER YEAR contagious about it. Alteryx has spread far and wide within Coca-Cola. We I can mine troves of data from have several hundred users across the Freestyle machines across the country. organization, from the supply chain group to our data science team, all Using Alteryx, Jay was able to gleaning insights from Coca-Cola data collate and summarize historical data using Alteryx. My coworker and I co- and automatically generate lead an internal Alteryx user group that and send over bring together local and virtual users 600 personalized reports across those groups to share ideas and to restaurant owners. best practices throughout Coca-Cola. Jay’s analyses empower restaurant “Honestly, I use Alteryx for too many owners to understand and optimize projects to count, for everything their inventory, reducing out of stocks from geospatial intelligence to time and increasing profit margins. series forecasting and predictive modeling. One of my biggest wins as “I remember building out a prototype of late involves the Coca-Cola Freestyle for ten stores. It ran in less than one 600 machine, a touch screen fountain that minute. I was standing at my desk personalized allows users to create their own perfect jumping up and down, saying, ‘This mixture of flavors. Consumers love can’t be right!’ People outside my reports it, because they have the freedom to office were asking if I was okay. I did COMPRISED OF customize and choose what makes a little victory dance and yelled, ‘It them happy. We love it too, because worked!’ I can’t even imagine how THOUSANDS we’re getting a level of insight into the long it would have taken me to build OF FRANCHISEES Coca-Cola experience that has never and run that kind of analysis. SELLING CLOSE TO been possible. Behind the scenes, we use Alteryx to predict things like which “I simply can’t imagine doing 1 BILLION components will require maintenance my job without Alteryx,” Jay insists. BEVERAGES in the near future and what flavors “Nor would I want to,” he adds PER YEAR provide the best product mix in with a smile. different regions of the country. SOLVE IMPOSSIBLE PROBLEMS. Download your alteryx trial today at alteryx.com/trial Alteryx + Coca-Cola