Delta Lake and Talend

Modern data architecture with Delta Lake and Talend

Read Article

About Wavicle Data Solutions

Delta Lake and Talend

Modern data architecture with Delta Lake and Talend

Read Article
Delta Lake and Talend

Modern data architecture with Delta Lake and Talend

Read Article
Delta Lake and Talend

Modern data architecture with Delta Lake and Talend

Read Article

Wavicle Case Study

McDonald’s Optimizes Food Delivery Performance With Data Analytics

McDonald's

For McDonald’s, Wavicle provided an intelligence solution to manage its third-party food delivery partners, giving restaurant managers new levels of insight and decision-making control. With access to visualized metrics tied to its own corporate data, they optimized their food delivery operations for strategic growth.

3rd party delivery analytics

Data Integration
Data Warehouse
Data Analytics
Customized Reporting
AWS Redshift

Overview: As food delivery surges, McDonald’s improves operations ahead of the curve

McDonald’s, the leading global foodservice retailer, partnered with Wavicle Data Solutions to optimize the performance of its third-party food delivery providers in 40 markets across five continents. McDonald’s needed to measure and track the performance of its growing third-party food delivery function and its effect on the business to ensure: sufficient inventory for popular menu items, adequate staffing, on-time deliveries, and ongoing customer satisfaction. Without these assurances, the company was concerned about losing control of revenue and consumer brand loyalty. An intelligence solution was critical for financial success in a highly competitive market.

Solution: Disparate data transforms into valuable visualized metrics

Wavicle implemented a data model and process to load source data from multiple third-party food delivery partners into a single Amazon Redshift cloud data warehouse, transforming disparate data into valuable operational intelligence.

On-demand customizable reports gave McDonald’s management insight into sales, delivery, customer feedback, and fees, with the ability to “slice and dice” these metrics by restaurant location, food delivery partner, date range, and time of day. With access to visualized metrics, they could continuously measure and improve food delivery operations.

Outcome: Serving up the right food delivery analytics

This solution provides McDonald’s operators with key analytics at a macro-level, giving them the ability to dive into details, resolve specific issues, and optimize food delivery performance. Since implementation, McDonald’s has increased total food delivery orders, which now exceed more than 10 percent of sales in locations that offer delivery. Additionally, the average dollar value per transaction is significantly higher for food delivery vs. non-food delivery. They now attribute food delivery as a key driver of global growth.

This solution combines existing corporate data such as point of sale (POS) with third-party food delivery data to track, measure, and visualize key metrics:

Sales metrics by channel (in-store, drive-thru, and food delivery)

  • Total sales: in dollars, number of orders, percent by channel
  • Average check size: in dollars, number of items by channel
  • Refunded items, based on customer complaints: in dollars, number of orders by channel
  • Uptime by restaurant location: hours per day each location accepted food delivery orders

Food Delivery metrics

  • Average route time (length of time for driver to arrive at restaurant)
  • Average restaurant wait time (length of time driver waits at restaurant to receive order)
  • Average fulfillment time (length of time for driver to deliver to customer after leaving restaurant)

Customer analytics

  • Total sales in dollars, number of orders (new customers vs. existing food delivery provider customers)
  • Market basket analysis to understand what items are selling the most via food delivery, vs. differences from in-store purchase behavior
  • Customer satisfaction scores and feedback by food delivery order (delivered via food delivery apps)

Fees metrics

  • Fees paid by restaurants to food delivery providers
  • Fees paid by customers to food delivery providers

About Wavicle Data Solutions

Wavicle Data Solutions delivers data and analytics solutions that help organizations achieve business results. Wavicle delivers custom solutions to capture, analyze, and share growing volumes of data from traditional on-site systems, cloud applications, social media, and numerous other sources. Wavicle combines its expertise in data engineering and architectures with artificial intelligence and machine learning concepts to help enterprises imagine new ways to manage costs, increase sales, and become more efficient. Wavicle was also recognized as an Inc. 500 company in the 2019 list of fastest growing private companies in America. For more information about Wavicle Data Solutions’ offerings for large organizations that want to get more value from their massive volumes of growing data, please visit https://wavicledata.com/.

Download Case Study PDF