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.
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.
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
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.
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
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).
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.
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.
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.
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.