Tools Comparison

What do you need to do?

Excel

Tableau Logo

Tableau

Charts, graphs, pivot tables Checkmark Checkmark Checkmark Checkmark Checkmark Checkmark
Advanced level charts & graphs, complex tables and interactive visualizations Checkmark Checkmark Checkmark Checkmark Checkmark Checkmark
Publish charts & graphs or interactive visualizations to web Redx Checkmark Checkmark Checkmark
Connect to department shared spreadsheets and databases  Checkmark Checkmark Checkmark Checkmark
Geographical (map) visualizations Redx Checkmark Checkmark Checkmark
Data analysis, what-if scenarios, ad-hoc work , drill down, forecasting, etc. Checkmark Checkmark Checkmark Checkmark Checkmark
Download raw data Checkmark Checkmark Checkmark Checkmark Checkmark Checkmark
Connect live to dataND data sources Redx Checkmark Checkmark Checkmark
Printed output CheckmarkCheckmark Checkmark

 

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. 

Back to top