#WOW2021 Week 5 - Predicting HBCU Future Enrollment

Workout Wednesday 2021 week 5 required you to become familiar with the statistical functions in Tableau as well as being able to create predictions based on those stats. I hadn't done either of these before, so I knew it would be a good learning opportunity.

View the dashboard here

Building the chart itself was simple. I chose to NOT truncate the axis as Candra did because it's not best practice to truncate the axis of an area chart as it skews the magnitude of change across time.

To create the Gaussian process regression, I found information on Tableau's website about the calculation and how to configure it. For Gaussian regression, the help says to use this formula:

MODEL_PERCENTILE(
"model=gp",
AVG([Days to Ship Actual]),
ATTR(DATETRUNC('month',([Order Date])))
)

However, when I did so, the chart and values were not the same as Candra's. So I used the MODEL_QUANTILE function instead. As always, the help within the calculation window was immensely useful.

Great, I now had the line chart. But I couldn't figure out how to get the prediction to extends another five years. A Google search for "predicting the future Tableau" sent me to this link.

View the dashboard here