Tableau is capable of generating predictive models with relative ease, you only need to know which type of model you want to create; it is possible to create Linear Regression, Regularized Linear Regression and Gaussian Process Regression. We will be using the MODEL_QUANTILE function in Tableau to generate these models, this will return a value which has been calculated using the desired quartile ranges (0>V<1).
![](https://www.thedataschool.co.uk/content/images/2022/07/image-439.png)
Each of these models has their own benefits and limitations; Linear Regression is best used when you have only one predictor and it is independant to your target metric.
![](https://www.thedataschool.co.uk/content/images/2022/07/image-440.png)
![](https://www.thedataschool.co.uk/content/images/2022/07/image-443.png)
Currently the model extends 1 year into the future, generating the values based on those which have preceded it, although not immensely in-depth, the values can be useful to give an indication to a possible trends in the near future. It is also possible to change how far in the future the values are generated for, Simply right-click on your "Time" field in the rows or columns and select Extend Date Range.
![](https://www.thedataschool.co.uk/content/images/2022/07/image-449.png)
Regularized Linear Regression is similar to Linear Regression, however, is best used when you have two or more variables and there is a linear relationship between them, which is know as colinneariality.
![](https://www.thedataschool.co.uk/content/images/2022/07/image-465.png)
![](https://www.thedataschool.co.uk/content/images/2022/07/image-466.png)
Finally, there is Gaussian Process Regression which is best used when there is a continuous dimension such as time, or when there is a nonlinear relationship between the variable and prediction target. The dimension used must be an ordered dimension such as Months in a Year, or multiple unordered dimensions.
![](https://www.thedataschool.co.uk/content/images/2022/07/image-473.png)
![](https://www.thedataschool.co.uk/content/images/2022/07/image-475.png)