You are leaving our main website to go to our chinese website hosted in China. For legal reasons there will not be any links pointing back to the main website.
One of the largest international premium beer brands struggled to get a systematic 360-degree view of the key performance indicators driving their business. The necessary data was fragmented, spread across too many sources, and the IT department was overloaded with ad hoc requests for operational business questions. Business analysts with excel-level skill sets weren’t able to systematically combine 10+ data sources to identify performance gaps in sales and marketing initiatives in the required time.
Keyrus partnered with the organization as a full-service BI and advanced analytics partner. The company chose Qlik Sense as their BI tool because of the powerful associative engine that would allow the cross-functional analysis the sales and marketing teams required.
Keyrus created a consolidated data model that integrated all relevant data sources into a single source of truth. We built and delivered key strategic dashboards for the organization that guided and tracked the company’s performance along the critical KPIs.
Our team rolled out the dashboards and provided training sessions so that business users could apply the insights in the day-to-day management of their brands or regions.
Keyrus was able to provide almost immediate value using Qlik Sense’s data modeling capabilities. We consolidated over 20 data sources into a single coherent framework that fed a number of key reports even before a final harmonized data warehouse was constructed. This brought immense and immediate value to the business while a heavier IT-based project continued in the background.
Keyrus rolled out eight consolidated reports that are used by the sales team to identify key gaps in performance and sales metrics. The reports consist of interactive Qlik Sense dashboards for power users and static NPrinting Excel reports for the entire sales organization.
The Qlik reports are structured to provide insight into the factors that affect sales, but they also leave the sales team with immediate and actionable items. For example, accounts missing high rate-of-sale packs are instantly flagged and placed in a table along with the packs they are missing. Sales representatives can then directly instigate conversations with their distributors to ensure the top packs are being placed in outlets.
For displays, any accounts with low displays and high competitor displays are flagged and available for output. The ability to quickly slice and dice transactional data (the main fact table is over 100 million rows large) makes any conceivable analysis possible.
The dashboards include the following:
Depletions Analysis: Dashboard showing sales performance for all relevant dimensions against plans and previous time periods. Identifies accounts with key gaps to competitors and previous periods.
National Accounts Analysis: Dashboard showing sales performance of key national account directors and managers. Comparison to national and state averages highlight underperforming regions.
Display Analytics: Consolidated dashboard between volume and display data showing key gaps to competitors in feature activity and execution. Analysis by size-of-display and location quickly identify accounts with the greatest opportunities.
Distribution Analysis: Dashboard analyzing which stores are selling key mandatory packages. Advanced ETL allows the company to identify the gaps in sales data so that sales representatives have a direct list of actionable packs that they can encourage distributors to place in the store.
Sales Analysis: Dashboard of depletions, display, market, planning, and marketing data in one consolidated report. Sales directors can quickly identify underperforming regions, gaps in display, issues with distribution, and comparisons to key market competitors.
Marketing Analysis: Dashboard showing key marketing metrics, GRPs, media spend, brand health metrics; all tied to volume display and distribution data. Directors can identify how media spend translates into increased volume depletions.
Management Team Report: A high-level dashboard showing KPIs across all business units, specifically designed for market managers.
Volume Planning: An ETL engine capable of facilitating advanced allocations across all business dimensions for annual planning.
The dashboards allow the business to instantly identify underperforming regions, channels, and packs and are used in monthly performance reviews with brand and market teams. RED or underperforming sectors on these dashboards provide instant motivation for the sales or marketing field teams to address performance gaps. VPs started calling sales teams on the phone to ask them about KPIs that were flagged. We saw improvements in subsequent monthly performance reviews in most cases.
Comparisons to market trends and competitors also give the organization the ability to see where they are heading relative to the competition, and then take action to scale up in areas with the biggest opportunities. Point-of-sale activities and compliance can be tracked and leveraged in conversations with distributors or account managers, especially when competitors seem to be out-performing the company in key accounts or periods of the year.
All the dashboards are available on mobile and desktop devices.
Reports that used to require three full-time employees each month can now be automatically generated weekly. Transforming the data into insights through visual analytics has also facilitated person-to-person conversations that increase sales and widen distribution into new opportunities.
Stay updated on the latest articles, events, and more
Your email address is only used to send you the Keyrus newsletter and for commercial prospecting purposes. You can use the link in our emails to opt-out at any time. Learn more about the management of your data and your rights.
Press release
The Keyrus team is excited to announce that we’ve been named one of the top 1000 companies on Clutch’s platform in 2022! This is the second year that Keyrus has been recognized by Clutch as a top company and B2B leader.
Webinar
In 20 minutes, we’ll teach you how to use Alteryx Intelligence Suite to eliminate common problems and inefficiencies in accessing data from .pdf files. In the past, you’d need to run custom Python and complex parsing logic to get any usable data from a pdf. Now, you can parse PDFs with out-of-the-box features in Alteryx Intelligence Suite.
Webinar
The cloud offers new opportunities to save you time and money, allowing you to shift focus from maintaining growing servers and upgrading infrastructure to making your data work for you and the success of your business. Watch the webinar and Q&A to learn how AWS, Tableau, and Keyrus worked together to help Red Ventures migrate to a powerful cloud BI tool that created new pathways for success and a modern data culture.
Event
Keyrus & Anaplan Sponsor Life Science Gross-to-Net (GTN) Summit
Press release
Keyrus achieved Amazon Web Services (AWS) Data and Analytics Competency. To receive the designation, AWS Partners must possess deep AWS expertise and deliver solutions seamlessly on AWS.
Webinar
Wednesday, November 9th, 2022 @ 12:00PM Central Time (US and Canada)
Webinar
Want to optimize your visual analytics in Salesforce? You need the right tools. Tableau Embedded Analytics can be used to help you build and visualize reports in Salesforce.
Success story
C&S Wholesale Grocers worked with Keyrus and Alteryx to implement an analytics center of excellence to help them efficiently and effectively achieve business objectives, maximize return on investment (ROI), and standardize best practices.
Success story
Keyrus partnered with a consulting firm to build an in-house cloud security solution that would automate their verification processes and keep their information safe.
Success story
Keyrus partnered with Pajama Program, a nonprofit organization, to review their Salesforce architecture and improve overall operations.