The City of San Francisco’s Health Department is always busy making sure our local restaurants are meeting food safety standards. Thanks to SF Open Data, scores and violations for every restaurant are available to anyone. Naturally, I wanted to take this data and give it life in Tableau. But before getting into Tableau, I had to blend and and geo-match the data using Alteryx.
From spreadsheets to a useful dashboard complete with maps, I like to think the final product below has made this data much more accessible. Three years of data were analyzed for this visualization, beginning in June 2013. Now anyone can use this dashboard to drill into their neighborhood and find local restaurants along with their associated health safety scores and violations. Is your favorite restaurant a high scorer or do they prefer keeping a steady family of rats on the premise? Take a look for yourself below, and feel free to explore the original data source.