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

Empowering a leading beverage company with self-service analytics

By Kit Germeroth

Background

A global wine and spirits company owns a wide variety of beverage brands worldwide. With a consumer-focused approach, the organization strives to provide the most relevant products to each of their targeted customer profiles.

Challenge

The company began an engagement with Keyrus to scale their business intelligence (BI) team in order to deliver faster, newer reporting on projects. As a market leader, they knew that they needed to continue to invest and innovate to better understand their customers. This put pressure on the BI team to produce increasingly robust reporting and analytics.

The company found it difficult to hire or train employees for both analytical skills and beverage market expertise, so they decided to augment their staff with a strategic consulting partner who could scale with the demands of the team.

They were using Oracle BI as their main BI editor, but business users found it challenging, both to learn and to use. They wanted to move to a more self-service oriented tool to replace Oracle BI and move away from a traditional BI model. They needed a more scalable data visualization solution to reach their goals.

While implementing self-service analytics, the company simultaneously wanted to pursue advanced analytics in order to make measurable improvements, starting with account segmentation. They wanted to better focus field-sales efforts at the store level and help ensure that brands are positioned correctly during the sales process.

Solution

Self-Service Analytics

The organization had conducted an assessment of the leading self-service tools and chose Microsoft Power BI as a cost-effective editor. Keyrus then led a Power BI proof of concept (PoC) to assess the tool’s ability to address real-life business scenarios and recommend next steps.

The goals were:

  • Build a set of Power BI dashboards to address three use cases that were identified by the company to assess the tool’s ability to answer the business requirements

  • Guide business users on how to use Power BI for self-service analytics

  • Guide the IT team on how to govern Power BI in a bi-modal manner and assess the change impact on the organization

  • Recommend next steps to increase user adoption and successful roll out to the organization

After a successful PoC, our team designed and built a set of Power BI dashboards based on the specifications and mockups provided. The solution deployment and rollout included user acceptance testing (UAT), business and technical training, documentation, and solution handover to the IT team. The Power BI solution is a more modern, visual tool than the company’s previous solution.

Account Segmentation

The organization had started a strategic initiative on account segmentation to better focus field-sales efforts. With more than 250,000 active accounts in the US, they needed a low-touch automatic account segmentation process. They had conducted a PoC with the intent of using a supervised learning algorithm to learn how to automatically label accounts with proper segmentations.

The company engaged Keyrus to productionize the PoC and scale the main components of the machine learning system so account segmentation could proceed automatically with high confidence. We worked with their team to build decision trees in Python, perform data cleansing, and to generate outputs from various input data sources. Our team produced accuracy measurements to give a sense of confidence as to how well the machine was operating, and those metrics were shared all the way up to the executive level.

Our team’s knowledge in the beverage and alcohol space allowed for faster data model deployment and business user training.

Results

With a self-service BI model, the business no longer has to rely on the IT team to build new reports. Power BI dashboards provide live access to the data from any device and alleviate the burden of having to compile excel reports on a monthly basis. Tracking business performance with a self-service tool is now engaging and interactive.

The new Power BI dashboards allow the organization to:

  • Understand and analyze the performance of their products as distributors sell them to retailers. Managers can isolate markets/accounts/brands that are performing outside the norm and investigate what can be improved.

  • Understand what type of accounts the products perform well in and what future opportunities they may have, using an account segmentation matrix built with a machine learning model.

  • Take a deep dive into the account attributes of the retailers that sell the company’s brands. Analysts can understand their performance in high priority accounts and track their growth month-to-month.

  • Assist managers with understanding where the inefficiencies in their account management may exist; if an account moved from low priority to high, is it now selling enough?

  • Gain insight into the pricing strategy ROI and how to adjust for the upcoming months.

  • Evaluate brands in comparison with competitors within their division.

  • Analyze the performance of their brands in major transportation centers.

The outputs from the machine learning project are currently being deployed. They’ll be used as a measurement for the organization’s distribution partners in terms of target expectations for the upcoming fiscal year.

Read more about this project from the organization’s IT Director on our Clutch profile.

For more on Power BI, check out this blog post on how to perform concurrency testing of Power BI reports.

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