Question

Discuss the similarities and differences between Tableau and Excel. All sources need to be cited?

Answer 1

similarities-

• both are data analysis tools with different approaches.
• both are user friendly but tableau is better to understand.
• both can be used for business purposes.
• they both include table views with different conditioning.
• tableau can connect to excel as data source.

differences-

• excel is a spreadsheet tool whereas tableau is a data visualisation tool.
• excel is used for calculations and data organization whereas tableau is used to represent the insights of the data.
• excel can manipulate the data and descriptive statistics whereas tableau is much more interactive and user friendly because of its visualization.
• excel is used by developers and data scientists whereas tableau is used by data analysts,data scientists and for business intelligence.
• excel requires coding background but tableau does not require any prior coding knowledge.
• excel works on small data while the other works on big data problem representation.