Tableau for Good: A Social Distancing Floor Plan for Restaurants

Data

Tableau for Good: A Social Distancing Floor Plan for Restaurants

As a result of the widespread measures taken by various governments around the world to mitigate the spread of COVID-19, a lot of business industries have been adversely impacted by these initiatives—none more so than the restaurant and food service industry, where businesses have had to endure over three consecutive months of decreased sales due to COVID-19 regulations. The past few weeks, however, have provided us a glimmer of hope as economies around the world are starting to cautiously tiptoe towards reopening. That being said, it is evident that we will need to get used to a new and different dining experience in the aftermath of the pandemic. For businesses to survive, they will have to adapt to the new normal and think of creative and innovative ways to thrive in the midst of adversity.

A Personal Loss

Regretfully, one of my favorite restaurants which I have been frequenting since my childhood has had to close due to the financial strain caused by the pandemic. It was a traditional dim sum restaurant that served an extensive menu of classic items like shrimp dumplings, pork buns and custard tarts. Like many Chinese families, eating dim sum—also called “yum cha” (饮茶), which translates to drinking tea—is a weekend brunch-hour tradition that played a significant part in my cultural upbringing and childhood. Little did I know that I would have to bid farewell to a place filled with many fond memories under such circumstances.

Like many Chinese families, eating dim sum—also called “yum cha” (饮茶), which translates to drinking tea—is a weekend brunch-hour tradition that played a significant part in my cultural upbringing and childhood.

In Crisis, We Turn to Data

As a result, I was motivated to write this short blog post to help restaurant owners in these unprecedented times. I have published a Tableau dashboard in this article that can serve as a visual reference point for the food and beverage industry to think through potential seating layouts. The goal of this dashboard is two-fold:

  • To ensure that restaurants comply with their local public health department’s social-distancing requirements
  • To empower restaurants to maximize their seating utilization, which will ultimately lead to higher potential revenue by testing out various seating configurations

How to Use the Tableau Dashboard

This dashboard is meant to be interactive, so you can test out various seating configurations. See below for the full list of functionalities you can interact with:

  1. Language Parameter – this is a fully bilingual dashboard that will allow you to toggle between English or Mandarin Chinese.
  2. Chair Configuration Parameter – this is perhaps the ‘secret sauce’ of the dashboard. There are five different seating configurations to choose from, two of which (B and C) assume that individual seats need to be distanced with your distancing requirements, and two other layouts (D and E) which assume that groups of chairs can be clustered as discrete, distinct groups.
  3. Social Distancing Parameter – the dashboard is defaulted to create a buffer distance of 1.5 meters from each seat. Feel free to increase or decrease your distancing threshold, and if the circles do not overlap between seats or groups of seats, you are in compliance with social distancing guidelines.

Next Steps

In terms of replicating and tailor-fitting this template dashboard for your own custom needs, I have made this Tableau workbook freely available for you to download. The only thing left would be to obtain a visual image of your restaurant seating plan and capture the x and y coordinates of your seats. This can be done easily with InterWorks’ Drawing Tool for Tableau. From there, you can simply replace the coordinate data points in my table schema with your layout’s coordinates and upload your floor plan image to replace the sample template’s.

We’re All in This Together

I hope you enjoyed this blog and found some tangible insights you can leverage to help our friends in the food and beverage industry. Please feel free to message me, or reach out if you have any questions as I’d love to continue the conversation! Also, keep an eye out for upcoming posts in this series about using Tableau for good as we explore various examples of how data and analytics can make a positive impact on our world.

More About the Author

Mendelsohn Chan

Solutions Lead
Hands-On Alteryx: An Intro to Regular Expressions for Text Analytics A regular expression, also commonly known as RegEx (pronounced as /reh-JEKS/), is a powerful text-processing framework that uses a ...
Tableau for Good: A Social Distancing Floor Plan for Restaurants As a result of the widespread measures taken by various governments around the world to mitigate the spread of COVID-19, a lot of ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072