Sign up to receive our monthly newsletter, and get the latest insights, tips, advice, and all the resources you need to transform your business with data.
Count on us to be a resource for you. Our webinars equip you with data and analytics best practices and expert insights about the industry. You can also find us guest speaking at industry conferences and user group meetings.
To thrive with your data, your people, processes, and technology must all be data-focused. This may sound daunting, but we can help you get there. Sign up to meet with one of our analytics experts who will review your data struggles and help map out steps to achieve data-driven decision making.
+1 312 878 6600 Mon-Fri 8:30am-5:30pm CT
Thanks for your inquiry! Someone will be in touch shortly.
CPG, Food & Bev
We were never able to explain—with data—the root cause of our performance issues; we had too much data, in too many different systems, and not enough people with knowledge to analyze the data in a timely manner. With our new analytics solution, we now spend our time on fixing the issues within our logistics operations instead of trying to understand what happened. We’re more productive, more effective, and our performance and financial KPIs are reflecting that.
The Tier 1 logistics division at Anheuser-Busch InBev (AB InBev) is responsible for warehouse and transportation logistics, which includes tracking shipment targets for twelve breweries across the nation. As a data-driven organization, they established key performance indicators (KPIs) that focus on quality, service-level, throughput, and productivity by which they measure their performance. The data to measure each of these KPIs came from multiple data sources, most of which were developed in-house and highly customized. The warehouse teams would manually extract data from their warehouse management system (WMS) into MS Excel and Access, manipulate the data, determine root cause for missed goals, and then make business decisions. This manual method of performance measurement created several issues for them, including:
AB InBev needed an analytics system that brought accuracy and standardization of analyses across all business sites. They requested a system that put focus on their top KPIs with metrics updated on hourly basis so that they could respond faster to gaps in performance. If for some reason a brewery did not reach their daily targets, they wanted a quick and reliable source to explain the root cause.
To solve AB InBev’s reporting problems, Analytics8 implemented a comprehensive data and analytics solution using Qlik Sense. The first step was to capture historical information across all 12 breweries to give context when measuring performance. We built a data staging layer and implemented incremental loading techniques to minimize impact on the production environment. The solution now holds more information than the source systems themselves – currently, 100+ million records are captured for a 10-minute snapshot of work at each brewery! The Qlik Sense solution built allows for several data refreshes a day.
We also built a dimensional data model in Qlik Sense that combines data from all 12 breweries and allows KPI analysis to be done in a consistent, governed manner via a single analytics application. Instead of using Excel and doing a lot of work to visually filter data, the new application gives more context to users by utilizing common dimensions to see potential relationships between KPIs. Users can now start their analysis at a high level, and then drill-down and drill-across dashboards to answer their business questions.
We also conducted dashboard design sessions with the business team to understand their root cause analysis process for missed targets. Given this information, we designed dashboards that clearly illustrates KPI performances and allows them to speed up decision making in a guided manner.
The solution we built gives corporate deeper insight into company performance by allowing them see data across all breweries in one view.
The new analytics solution at AB InBev enables business users who are not highly trained in logistics to identify issues and make data-driven decisions faster, more consistently, and more reliably. Data gathering now takes minutes, instead of days, giving them more time for problem-solving. With consolidated historical data across all breweries, they can easily identify patterns over time and traverse multiple metrics by their common dimensions (products, carriers, breweries, employees, and time). Additionally, leadership has more insight into missed goals and can keep their employees more accountable.
Some of the measurable time and costs savings realized from this solution include:
Changing the analysts’ day-to-day operational work from pulling data, compiling reports, and fixing broken transactional jobs to feed reports, to now doing more data analysis has been invaluable to AB InBev.
Anheuser-Busch InBev is a publicly traded company (Euronext: ABI) based in Leuven, Belgium, with American Depositary Receipts on the New York Stock Exchange (NYSE: BUD). It is the leading global brewer and one of the world’s top five consumer products companies.
Sign up to meet with one of our analytics experts who will review your data struggles and help map out steps to achieve data-driven decision making.