Coca-Cola Bottling Company’s (CCBCC) business intelligence team handles reporting for all sales and delivery operations. Shawn Crenshaw, Senior Business Analyst, explains how the team answers questions such as: “Are we delivering product at the time we say we're going to deliver it? Are we meeting that budget? And how well are we doing against that forecast budget?”
Previously, the team spent a majority of their time building reports. It could take days to bring together up to 200 million lines of data from 100 different systems into a data warehouse to then build a portion of one usable dashboard. “We were using a Pinto for our data and we needed a Mercedes”, says Kevin King, Director of Reporting and Analytics.
Kevin recalls coming into the office at 7:30 in the morning, seven days a week to refresh the company’s daily sales report, which took about 45 minutes. And the final dashboard had up to ten tabs that leadership had to click through to see any granularity in the data.
When CCBCC adopted Tableau as its analytics platform, teams completely streamlined their processes. For the daily sales report, Kevin set up automatic refreshes in Tableau Server so data updates every day at 5:30 a.m. Leadership can access current numbers every morning, drill down to the lowest level of data, and Kevin and his team can spend their mornings on more productive tasks.