Tableau facilitates in forecasting the continuation of a particular trend of a variable by using Trend lines. By observing the trend of two variables, Trend lines helps to recognize the correlation between the two variables. Trend lines are established by many mathematical models for which four options are provided by Tableau – Linear, Logarithmic, Exponential and Polynomial. This tutorial covers the linear model. One dimension and one measure are used to create Trend Lines by Tableau.
The Sample-superstore is used to identify the trend for the value of the measure sales for next year by the following steps:
The dimension Order date is dragged to the column Shelf and the measure Sales to the rows shelf. Choose the chart type as Line chart. In the Analysis menu go to model -> Trend Line. Clicking on it brings up a pop up showing different types of trend lines that can be added. Choose the linear model as shown below.
On finishing the above step various trend lines appear. It also shows the mathematical expression for the correlation between the fields, the P-Value and the R-Squared value.
The detailed description of the Trend Line is obtained by right clicking on the chart and selecting the option Describe Trend Line. It shows the coefficients, intercept value and the equation. The details thus obtained can be used for future analysis by making a copy of them on a clipboard.
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 © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.