Tableau 10 Bootcamp: Intensive training for data visualization and dashboarding by Joshua N. Milligan & Joshua N. Milligan & Donabel Santos & Donabel Santos

Author:Joshua N. Milligan & Joshua N. Milligan & Donabel Santos & Donabel Santos [Milligan, Joshua N.]
Language: eng
Format: azw3
Tags: COM005030 - COMPUTERS / Enterprise Applications / Business Intelligence Tools, COM018000 - COMPUTERS / Data Processing, COM089000 - COMPUTERS / Data Visualization
Publisher: Packt Publishing
Published: 2017-09-26T04:00:00+00:00

Choose DOHMH_New_York_City_Restaurant_Inspection_Results.xls, and select Open with Legacy Connection:

In the Connections window, remove the existing connection to the one sheet in the Excel file:

Drag New Custom SQL to the main connection pane:

Add the following code to the Edit Custom SQL window:

SELECT [DBA], [CAMIS], [CUISINE DESCRIPTION], [INSPECTION DATE], [GRADE DATE], [INSPCTION DATE] AS [Date], 'Inspected' AS [Type] FROM [DOHMH New York City Restaurant$] UNION ALL SELECT [DBA], [CAMIS], [CUISINE DESCRIPTION], [INSPECTION DATE], [GRADE DATE], [GRADE DATE] AS [Date], 'Graded' AS [Type] FROM [DOHMH New York City Restaurant$]

In the preview window, click on the Abc symbol above the Date field and select Date to change the data type to Date:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.