The consolidate demonstration of many worksheets and all other related information at a single place is known as a Tableau Dashboard. To monitor and compare different types of data simultaneously Tableau dashboards are used. Dashboards are shown as tabs at the bottom of the workbook and they usually get updated with the most recent data from the data source. Views from the worksheet can be added in the workbook while supporting the objects like text areas, web pages and images.
When each view is added to the dashboard it is connected to its corresponding worksheet. So when the worksheet is modified, the dashboard is updated and when the view is modified in the dashboard, the worksheet is updated.
The Sample-superstore, is used to create a dashboard showing the sales and profits for different segments and subcategory of products across all the states by the following steps:
A blank worksheet is created with the help of an add worksheet icon. The dimension Segment is dragged to the columns shelf and the dimension Sub-Category is dragged to the Rows Shelf. Drag and drop the measure Sales to the colour shelf and the measure Profit to the Size shelf and the worksheet is known as the Master worksheet. Right click and rename this worksheet as Sales_Profit and the chart appears as follows:
Another sheet is created to hold the details of the Sales across the States. The dimension State is dragged to the Rows shelf and the measure Sales to the Columns shelf. Next a filter is applied to the State field to arrange the Sales in descending order. Right click and rename this worksheet as Sales_state by the following diagram:
A blank dashboard is created by clicking on the create new dashboard link at the bottom of the workbook. Right click and rename the dashboard as Profit-Dashboard.
The two worksheets are dragged to the dashboard. Near the top border line of Sales Profit worksheet, three small icons appear. Click on the middle one which shows the prompt Use as filter on hovering the mouse above it.
Now in the dashboard click on the box representing Sub-category named Machines and segment named Consumer. It is noticed that the states where sales has happened Right click and rename this worksheet as Sales_Profit. The below chart appears showing linking of the sheets to the dashboard.
Tableau Related Interview Questions
|Microstrategy Interview Questions||IBM Cognos Interview Questions|
|SAP BO Interview Questions||SQL Database Interview Questions|
|MySQL Interview Questions||OBIEE Interview Questions|
|Qlik View Interview Questions||SQL DBA Interview Questions|
|SQL Interview Questions||Tableau Software Interview Questions|
|Spotfire (TIBCO) Interview Questions||Business Objectives Interview Questions|
|OBIEE 11g Interview Questions||Qlik Sense Interview Questions|
|Stored Procedures Interview Questions|
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.