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

Optimizing the multi-channel customer experience for a fast casual restaurant chain

By Kit Germeroth

Background

An American fast casual restaurant chain has rapidly grown to over 200 locations in 15 countries. Their success and popularity come from their distinct customer service experience, which brings back customers time and time again.

Challenge

One of our client’s greatest challenges is ensuring a consistent customer experience during each visit and across all restaurants. The company needs to understand their customers’ expectations, likes and dislikes, and behavior to repeatedly and seamlessly delight each customer, in each interaction, and in each sales channel. 

However, it wasn’t clear how customers used their multiple sales channels or how this influenced their purchasing behavior. The company lacked access and insight into critical customer data but understood that this data could be used to enhance the customer experience. For this project, the business and technical objectives included:

  • Increasing operational efficiency by automating and centralizing their data infrastructure

  • Consolidating the view of restaurant data for use by BI tools and other business applications

  • Building operational ability to update records and solve data quality issues in one platform

Data Strategy Approach

In close collaboration with the client, our initial discovery and review of their current environment revealed that there was:

  • No single cross-channel view of guest data

  • No timely and simple access to restaurant operations data

  • No centralized repository of transactional data 

  • Insufficient governance and control for its data infrastructure

To bridge these gaps, the client asked Keyrus to:

  • Define a holistic data strategy that outlines the supporting architecture and toolset capable of meeting long-term business and technology objectives

  • Detail a specific and actionable implementation roadmap adapted to existing resources and data readiness

In our proposed data strategy roadmap and solution, Keyrus recommended implementing a data warehouse, fully productionalized and configurable ETL framework, and a data governance solution to consolidate all of their data to meet their business needs. 

Solution

The solution architecture is hosted in AWS and consists of:

  • DWH/BI solution (Talend and Snowflake) focusing on guest data and item-level sales data 

  • Data governance solution (Semarchy xDM) focusing on mastering all restaurant location related information 

  • Dashboards (Tableau) for visualizing the data

  • Supporting implementation with a change management effort

Centralizing Sources and Cleaning Data

First, we centralized the main sources of restaurant data from their point of sales and ordering systems and several excel sheets. We used a combination of Talend and Semarchy xDM to handle data uploads and provide back-to-consuming applications.

After profiling the data, we used enrichers and validations in the Semarchy xDM platform to clean and enrich the existing data to ensure high-quality restaurant data for matching, consumption, and use across the organization (primarily in the DWH and BI-layers). 

Consolidating the Data 

The different sources of data were then consolidated using Semarchy’s extensive matching capabilities. Additionally, survivorship rules were configured to identify what values from what sources to keep for the single golden source of data. 

Ensuring Smooth User Experience 

The Keyrus team built business-friendly views of company data using Semarchy’s extensive UI functionality to support use cases such as cross channel customer analysis. 

As new restaurant locations open or existing ones change, workflows ensure that current restaurant updates and new restaurant locations get vetted by data stewards before being exposed to users and before these location values are used in reporting.

Results

Our solution fully aligns with the organizational objectives in both the short-term and long-term. The client now has one centralized solution throughout the organization to conveniently access all restaurant-related information.

Keyrus’ actionable data roadmap allowed for immediate implementation and the following outcomes:

  • Data is validated, updated, maintained, and governed using solution functionality and workflows

  • Expanded use of Tableau and self-service analytics across the organization

  • Opportunities for further development and integration of technologies in the data landscape are clearly outlined

Now that the data across multiple sales channels (mobile app, website, in-person cash transactions, kiosks, and third-party delivery) are consolidated, the team can gain insights on:

  • Customer acquisition and channel conversion analysis

  • Customer purchasing frequency analysis

  • Cohort analysis by purchasing behavior 

The client is now equipped with reporting dashboards on sales, customer demographics, and purchasing behaviors to drive and enhance their customer experience. 

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