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

Enabling data-driven decisions at a large alcoholic beverage company

By Kit Germeroth

A large alcoholic beverage company oversees the import and distribution of many high-end spirits. The company sells through hundreds of thousands of on-premise and off-premise locations across the United States, and they engage in multiple types of marketing campaigns to promote their products. 

Initially, the company wanted to combine their sales data and marketing spend into a cohesive dashboard to understand which campaigns yielded the best returns. Our team recognized that the organization had bigger ambitions than just building a few dashboards; they needed strategic guidance on how to support a consolidated reporting and analytics platform that the entire organization could use. 

Discovery & Project Plan

Our team analyzed current systems, processes, and data to map out the organization’s current and desired state and to create a prioritized project project plan. During the discovery phase, we found that the company’s data warehouse, master data management processes, and infrastructure couldn’t support their reporting and analytics requirements. 

We selected a robust tech stack and designed the architecture for the solution. We then kicked off the project by setting up the infrastructure to build a new data warehouse. Next, the team had to get all of the relevant tools online, which included SSIS, SSAS for Tabular, MDS, Power BI, and quilliup.

Solution

Consolidating Data for a Single Source of Truth

At the start of the project, the organization used Excel for about 80% of internal data and had no automation set up to facilitate data analysis on a continuous basis. The first phase of the project included a small subset of data sources centered around sales volumes. We added more data sources from marketing and finance, and focused on building integrated views highlighting ROI that could show how the data, and consequently the insights, tie together.  

The company could then see their own and their competitors’ market performance in a single flow and dashboard. Users could drill in from high level to more granular views of a specific product in an account at the click of a button. 

The next phase of the project augmented the initial volume reporting with dollar amounts (since high-volume sales do not necessarily lead to profitable margins), and compared them to operational plans. The sales team’s performance is tracked versus the plan, so we built reports that enable users to instantly see where their brand, team, or market was compared to the plan, and the competition across volume and value sales.

Executive Overview Dashboard

Next, our team finalized an Executive Overview for the CEO and high-level management.  This dashboard contained a top-down view of the company’s performance, with the ability to drill right down to a single account level. Users could track performance compared to last year or plan with a click of a button. The CEO found this dashboard very useful and worked with us on a daily basis to refine the presentation. 

Change Management

The project also included an emphasis on change management and user adoption. A Keyrus change management consultant identified a “super group” of individuals from different roles (e.g., marketing, sales, finance, etc.) and different levels (e.g., analysts, managers, etc.) within the organization. 

We sought to understand the daily activities of each of these user roles in order to more effectively tailor training for the new solution. Once user adoption was established for the super group, the solution would be rolled out across the organization.   

Results

As a result of the project, the company has a single source of truth for their data, and it’s accessible by everyone in the company. The new platform is used in key processes, such as account segmentation and new product launches, and they also use a BI center of excellence to  ensure the project will be successful in the long-term. The management team has a set of core KPI dashboards that they can refer to for monthly and quarterly business reviews. About 70% of employees use the platform consistently with the CEO as a top user.  

The insights and finance teams each save at least one week per month thanks to the new automated reports. They no longer have to spend time maintaining excel spreadsheets and answering questions about the data. 

The executive team saves approximately three days per month because they no longer have to manually compile information for performance reviews of certain markets; the CEO can simply look at the report. 

Overall, the project enabled the company to begin using data to make smarter business decisions that will drive the company forward.

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