Tableau Forecasting Tutorial

  • date 21st March, 2020 |
  • by Prwatech |
  • 0 Comments

Tableau Forecasting Tutorial, in this Tutorial one, you can learn about Forecasting in Tableau. Are you the one who is looking for the best platform which provides information about Forecasting in Tableau and its different types? Or the one who is looking forward to taking the advanced Certification Course from India’s Leading Tableau Training Institute? Then you’ve landed on the Right Path.

Forecasting is the method of estimation of the future by taking into account the past and present data.It helps in the determination of direction of future trends. Forecasting helps in planning of business actions and create budget to cover the uncertainties as much as possible. Tableau uses exponential smoothing method for forecasting purpose. Exponential Smoothing is a method of time series forecasting for uni-variate data which can be extrapolated to understand the seasonal component and trend. It assigns exponentially weights for new to old observations, i.e.,   more weights are assigned to newer data than the older ones as newer data are considered to be more relevant.

Let’s see how to make forecasts in Tableau. Here, we have used Sample EU Superstore data which is provided by Tableau by default.

Drag the variable Order Date from Dimension section to Columns shelf. Also, drag the variable Sales from Measures section to Rows shelf. Now from Show Me section, click on lines chart to create a line chart as shown by the arrows in the diagram given below.

Forecasting Step by step implementation 1

Now move on to Analytics section as shown by the arrow in the diagram.

Forecasting Step by step implementation 2

Now click on Forecast under Model section and drag it over to the line chart as shown in the diagram below.

Forecasting Step by step implementation 3

Now it will show the forecasted line as shown below in the diagram.

Forecasting Step by step implementation 4

Now right click on the forecasted line, click on Forecast from the drop down menu and again click on Forecast Options as shown by the arrows in the diagram given below.

Forecasting Step by step implementation 5

From the new window, click on Until, under the Forecast Length section and increase it to 2 years. Also, tick on the box beside Fill in missing values with zeroes and then click on OK. The arrows in the diagram below explain the step.

Forecasting Step by step implementation 6

The diagram below shows the final forecasted line as per the requirements.

Forecasting Step by step implementation 7

Again, right click on the forecasted line and click on Forecast from the drop down menu and then click on Describe Forecast in order to get all the details of the forecast for better understanding. The diagram below explains the step.

Forecasting Step by step implementation 8

The window which appears shows the details of the forecast along with the trend and seasonality of the data. The diagram below shows the same.

Forecasting Step by step implementation 9

The Below mentioned Tutorial will help to Understand the detailed information about types of forecasting in tableau. So just follow all the tutorials of India’s leading Best tableau training institutes in Bangalore and Be a Pro Tableau Developer.

Leave a Reply

Your email address will not be published. Required fields are marked *

Quick Support

image image