Tableau is a Business Intelligence Application. Tableau is used to create visualizations and interpret data. Tableau follows the basic principles of BI i.e. extracting raw data, transforming it, and presenting the data visually so that Business users can make informed decisions.
1)Data.Tableau can connect to any format of source data.
2)Data Connectors. Tableau provides over 40 optimized data connectors. To various data sources such as MS Excel, MS SQL Server, Google Big Query, Amazon RedShift, Oracle, and others.
It also provides a generic ODBC connector for systems without a native connector.
Data can be used in-memory or live.
3)Components. The following components handle the server operations a)Application server. Application Server processes (wgserver.exe) handle content browsing, Server- Administration, and authentication to Tableau server web and mobile interfaces.
b)VizQL Server. When a user/client requests a visualization, it sends a request to the VizQL process (Vizqlserver.exe). The VizQL process in turn sends queries to the data source, returning a result set in the form of images.
c)Data Server. It facilitates the management of data sources on the server.
4)Gateway/Load balancer. Gateway directs requests to other components.
5)View. Users can view Tableau dashboards thru Tableau desktop or via zero-footprint HTML 5 in a web or mobile browser.
The basic components of Tableau are Tableau Desktop, Tableau Reader, and Tableau Server.
-The developer uses Tableau desktop to create visualizations, dashboards, and stories.
-Dashboards can be deployed on the Tableau Server. Users can access dashboards stored on the server through the server URL.
Tableau desktop can use data as a “Live” connection or as an “Extract” (TDE).
-Data connection/s used in developing dashboards is reusable. It can be published to the server. Data load schedules can be created to meet user requirements.
-Tableau desktop design file is called a “Workbook”. It has an extension .twb.
-Tableau workbooks can also be packaged with data. This packaged workbook is a zip file with extension .twbx.
-In the absence of the server, Tableau design files can be viewed by using Tableau Reader. Tableau reader is also a free download and can open twbx files.