Using the legacy Jet driver
In this recipe, we will use the New York Restaurant Inspections Excel file and use the legacy Jet driver to shape the file so we can have both the inspection date and grade date in the same column. This will allow us to visualize how many restaurants were inspected and graded for a specific date:
Getting ready
To follow this recipe, download the file from the New York City Open Data website using the following URL:
Once you have downloaded the data, save the file as DOHMH_New_York_City_Restaurant_Inspection_Results.xls ...
Get Tableau 10 Business Intelligence Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
