Coca-Cola European Partners employs more than 23,500 staff to make, sell and distribute the world’s most loved drinks brands to over 300 million people in 13 countries. Such large scale operations rely heavily on accurate reporting and analytics. However, prior to Tableau, the combination of outdated tools and growing data volumes was impacting overall productivity.
“We really had some challenges in terms of the amount of data running through our systems, our ability to quickly make sense of it, and how we could distribute key insights to our stakeholders in a consistent way,” recalls Johannes Sæthre, Strategy and Insights Manager at Coca-Cola European Partners.
Previously, reporting was predominantly conducted manually using basic tools such as Excel and PowerPoint. The difficulty of analysing data in Excel, combined with the effort of repeatedly generating and distributing reports via email, meant the process was both labour intensive and time consuming.
To address these issues, Coca-Cola European Partners decided to install a comprehensive new data analytics and reporting solution consisting of Tableau Desktop and Server, alongside Alteryx for data prep and enrichment. This new approach allows a wide range of disparate data sources across the company to be analysed together through a single platform for the first time, resulting in much faster and more accurate reporting.
“A lot of our data is currently running from Redshift (AWS),” says Johannes Sæthre. “We also have supporting databases, where we use CSV files or Excel files, along with some native connectors to applications like Salesforce, all of which are now connected via Tableau.”
Tableau Server allows Johannes and his team to publish live dashboards and reports across the entire organisation at the touch of a button rather than sending mass emails. Employees can then access the information at any time and be confident that what they are seeing is always up-to-date, helping avoid conflicts or confusion.
Critically, Tableau has also enabled the team to automate some of the more time consuming aspects of reporting throughout the company, saving significant amounts of time and eliminating many of the errors resulting from manual analysis.
“We've gone from this ad-hoc, manual approach to an automated solution where I just drink my morning coffee and by the time I’ve finished, everything is up to date,” says Johannes. “Not only can Tableau handle the vast amounts of data we now have to deal with each day, its ease of use and powerful visualisations mean everyone can use it and key insights are never overlooked.”