The Insider 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.
Thank You!
After doubling revenue and tripling headcount in a span of three years, Analytics8 earned a spot among the fastest growing and most innovative companies on the Inc. 5000 list.
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.
💌 Become an Analytics8 Insider! Become a newsletter subscriber to get curated data and analytics content, tips, and advice from our expert consultants.
+1 312 878 6600 Mon-Fri 8:30am-5:30pm CT
Connect with us on LinkedIn
"*" indicates required fields
Our monthly newsletter is full of resources to help you on your data and analytics journey.
Sign up to get expert-written insights, tips, and advice on how to get more value from your data.
See previous newsletters >
Thanks! You’ve been subscribed.
Food & Bev
Qlik
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.
Schedule a meeting with one of our data analytics experts who will review your data struggles and map out steps to achieve data-driven decision making.
Once a month, get expert-written insights, tips, and advice on how to get more value from your data.
This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
