- Tableau has helped shorten customer wait times and create greater transparency throughout the business
- Restaurant managers can track their restaurant’s performance against others on Tableau dashboards
- Speed of service improved by 6% with 20% more customers serviced an hour
A core principle of the McDonald’s customer experience is the ease and speed of ordering and receiving a meal. But for a restaurant with a menu of over 100 items, delivering on this promise requires that the entire restaurant runs like a well-oiled machine. Each employee must know their exact role, and every part of the process needs to run seamlessly, starting with the customer placing an order, the food being prepared, drinks poured, and the meal packed in tray or bag, before finally being delivered to the customer. Food Folk is the master franchisee for McDonalds’ Nordic operations and as its Head of Finance, Jacob Hansen had a mission to help McDonald’s Danish franchisees and Restaurant Managers to use their data to create an even better customer experience.
Can we get more out of our data?
The good news for Jacob was that McDonald’s has been relatively good at collecting data from their thousands of daily customer interactions; now they just needed to find a way to present their data in an easy and accessible way - making the data come alive in the organization.
“First, we didn’t have an effective way to share data,” says Jacob. “We created manual reports in Excel that were sent by email. I knew that there must be a better way to do it, like creating dashboards with real-time data.”
“Secondly, we could use our data even better,” he continues, “There was the potential to get an even better overview of the business and optimize it.”
What is great? Benchmarking against other restaurants
The first step McDonald’s and Inviso by Devoteam took together was building a collection of interactive dashboards in Tableau that covered what both used to be shown in the manual reports, as well as a host of new data that was previously unavailable. The reports contain a number of advantages for the company:
- Dashboards are updated automatically - there is no more waiting on manual reports, and consistency and quality is always ensured.
- All Restaurant Managers are given access to the dashboards and can follow the status of their own restaurant and how it compares to others.
- Previously hard to access data can now be used as a benchmark for the performance at each restaurant, creating a clear picture of which restaurants possessed valuable experience for other restaurants to learn from.
- Because the dashboards are interactive, each restaurant can “zoom in” on the data points that are most relevant to them. The dashboards also enable data granularity that was not previously possible with the manual reports, giving restaurant or franchise managers a tool to precisely identify where future problems might lie.
Before we got the [Tableau] dashboards, the Restaurant Managers could not see ‘what is great’. Maybe they knew their own speed of service at a high level, but when they could not compare with other restaurants, it was of little worth to know.
Jacob HansenHead of Finance, Food Folk
Shorter waiting in restaurants and drive-through
An example of how data has helped McDonald’s improve in the KPI called ‘speed of service’. This is a measure of the time it takes from when an order is registered, until the meal is delivered to the customer.
Speed of service was one of the data points that was not possible to see before working with Inviso.
Jacob explains: “Before we got the dashboards, the Restaurant Managers could not see ‘what is great’. Maybe they knew their own speed of service at a high level, but when they could not compare with other restaurants, it was of little worth to know.”
When they were able to access the new data in interactive dashboards, it gave a completely new opportunity to see how a single restaurant is performing in relation to the others on a specific point.
Jacob continues: “Now they can see how they are performing compared to the other restaurants. But what is even more important is that they can now click through the dashboards and find out why their speed of service is different than expected. Now they can easily zoom into e.g. the point of the day when service is not as fast as expected, or the time of the week when it happens. It means that they can now see when the problems start and launch solutions that are within their own circle of influence.”
The possibility to diagnose problems and pinpoint precisely when they originate has led to McDonald’s restaurants throughout Denmark improving their average speed of service by 6% and increasing drive-through customers served per hour by 20% in 2020; impressive results in a year where restaurants’ operations have fundamentally changed due to COVID-19.
The [Tableau] dashboards have a strong motivation effect, there is no doubt about it. Now we act more on facts and less on gut feeling.
Jacob HansenHead of Finance, Food Folk
Dashboards on the walls
McDonald’s has a strong performance culture. Among the employees there is a focus to always deliver service of the highest quality - and be the best at doing it. Therefore the introduction of these dashboards has fit in well with the company culture. At a few of the restaurants Jacob has visited, the dashboards have crossed from the digital to physical world, printed and hung up on the wall in the break room as motivation to be the top restaurant.
“The dashboards have a strong motivation effect, there is no doubt about it,” says Jacob. “Now we act more on facts and less on gut feeling, and we can see that the whole organization has really taken to it, the dashboards have been viewed over 100.000 times already. We are just getting started working with data and creating transparency in our business. We have come a long way, but there are still so many ways we can go from here.”
Learn more about how Tableau has helped McDonald’s create a better customer experience in this webinar.