What do you need to do?
|Charts, graphs, pivot tables|
|Advanced level charts & graphs, complex tables and interactive visualizations|
|Publish charts & graphs or interactive visualizations to web|
|Connect to department shared spreadsheets and databases|
|Geographical (map) visualizations|
|Data analysis, what-if scenarios, ad-hoc work , drill down, forecasting, etc.|
|Download raw data|
|Connect live to dataND data sources|
What are the differences between Excel and Tableau when working with dataND downloads?
- File format: .csv vs .twb
The Excel download buttons in dataND generate .csv (comma separated value) format (compatible with Excel and many other applications). The .twb (Tableau Workbook) format is proprietary to Tableau.
- Longevity of information
The Excel (.csv) format is a SNAPSHOT and therefore becomes stale over time whereas the Tableau workbooks continue to use built-in live connections to the data source.
- Download time
Excel can take a significant amount of time for a large .csv dataset. To lessen the actual download times the system first compresses the file into zip file.
Clicking the Tableau button initiates a live connection which generally takes only a few seconds.
- Preparedness for work
.csv files often require further tweaking such as defining the fields as string, number, date, etc. The download process compresses these into a .zip file and the user must uncompress (extract) before use.
Tableau workbooks have the data fields already set up appropriately.