Tableau Desktop is a data visualization product from Tableau. It connects to a variety of data sources for combining disparate data sources without coding. It provides tools for discovering patterns and insights, data calculations, forecasts, and statistical summaries and visual…
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Tableau Desktop supports data-driven decisions by helping users to answer questions more quickly, solve harder problems more easily, and uncover new insights.
Tableau Desktop connects directly to hundreds of data sources, both on-premises or in the cloud, with the goal of making it easier to start analyses. Interactive dashboards, drag and drop functionality, and natural language queries help users of all skill levels quickly discover actionable insights, all from its visual interface. Users can ask deeper questions by quickly building calculations, adding trend lines and seeing statistical summaries, or clustering data to see relationships.
| Deployment Types | On-premise |
|---|---|
| Operating Systems | Windows, Mac |
| Mobile Application | No |
Use Case 1
Cooking the data is very important & this is one of most general use case
Here are the steps of creating own data model/data warehouse & reporting via Tableau Desktop
i) Create your own bus matrix to make sure the you are clear about the requirement. Bus matrix gives you an overview about how each fact and dimensions is associated with each other
ii) Extract, transform all the data either using the ETL tool or using SQL in the database
iii) Build your facts and dimensions using the best practices (Build a star or snowflake or hybrid schema based on the requirement)
iv) Bring those facts and dimension in a separate tool for creating the relationship and associate them( for example SSAS). Basically create a SSAS cube and deploy it in server and push it to EDW or DataMart
v) So now the data is residing in a organized way in EDW or DataMart. It is cooked and ready for reporting and visualization
vi) Open Tableau Desktop and connect the cube using the Microsoft SSAS connector
vii) Build your own datasets, visualization, workbooks, dashboards
viii) Once done deploy them to Tableau server for online access
Let me give a perfect scenario where Tableau shouldn't be used -
If you are planning to ETL the data, create your fact and dimensions and bring them inside Tableau for creating your relationship and hierarchies then you are wrong. Tableau doesn't support any sort of data modeling options inside it. If you are ETLing the data and creating your relationship and hierarchy in a separate tool and pushing them to EDW and are expecting to report and visualize out of a reporting tool, then Tableau would be a perfect tool to do that.
