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.

Go to chinese website
Logo - Keyrus
Logo - Keyrus
  • Playbook
  • Services
  • Insights
  • Partners
  • Careers
  • About us
    Company purpose
    Innovation & Technologies
    Committed Keyrus
    Regulatory compliance
    Investors
    Management team
    Brands
    Locations

Success story

Using performance dashboards to increase sales at an international beer company

By Razvan Nistor

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.

The Solution

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.

Sales performance dashboards

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.

Results

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. 

whatsapptwitter
linkedinfacebookworkplace
newsletter.svg

Never miss an insight

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.

Continue reading

Press release

Keyrus named amongst Top B2B Companies on Clutch

December 12, 2022

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

PDF Parsing with Alteryx Intelligence Suite

December 1, 2022

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

Modern Cloud Analytics in Action: Keyrus and Red Ventures

November 11, 2022

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

Pharma/Biotech GTN Summit 2022

October 27, 2022

Keyrus & Anaplan Sponsor Life Science Gross-to-Net (GTN) Summit

Press release

Keyrus Achieves AWS Data and Analytics Competency Status

October 6, 2022

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

Live Webinar: Lessons on workforce capacity planning and optimization from Optum (UnitedHealthcare)

October 19, 2022

Wednesday, November 9th, 2022 @ 12:00PM Central Time (US and Canada)

Webinar

Tableau Embedded Analytics: Optimizing insights from Salesforce data

September 20, 2022

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

How C&S Wholesale Grocers maximized ROI with an analytics center of excellence

September 7, 2022

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

Implementing a cloud security automation tool at a global consulting firm

September 2, 2022

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

Leveraging Salesforce to improve operations at Pajama Program

July 25, 2022

Keyrus partnered with Pajama Program, a nonprofit organization, to review their Salesforce architecture and improve overall operations.

Logo - Keyrus
New York City

252 West 37th st., Suite 1400 New York, NY 10018

Phone:+1 646 664 4872

LinkedInInstagram
PlaybookServicesInsightsPartnersCareersAbout us
Company purposeInnovation & TechnologiesCommitted KeyrusRegulatory complianceInvestorsManagement teamBrandsLocations
Legal notice & Terms of use
Privacy policy
Data protection