#WOW2021 W05: Can You Predict the Future?

Introduction

For this week’s challenge, we wanted to hit two birds with one stone: try out a new feature from the Tableau 2020.4 and celebrate Black History Month with an interesting dataset on Historical Black Colleges and Universities (HBCU).

Predictions, table calculations, and parameter actions…oh my!  Consider this a feature sampler, building on some previous challenges and adding a predictive element into the mix. 

Viz Responsibly: While predictive analysis in Tableau has never been easier, we encourage you to be intentional in how you use this powerful feature because not doing so (e.g., selecting a model type not appropriate for your data) could lead to inaccurate results.  Click here, to learn more about predictive modeling in Tableau. 

 

Requirements

Requirements:

 

  1. Create a view that shows the actuals (1993-2018) and predicted values (through 2023) for the measure selected by the user
  2. Measures: Total Enrollment (All Students), % of Black Students Enrolled, % of Non-Black Students Enrolled
  3. Dashboard Size: 1200 X 600
  4. Number of Sheets: 2
  5. Color
    1. Actuals Area chart: #00a2b3, opacity: 75%
    2. Prediction Values Line Chart: #5c6068
    3. Selection Options: #00a2b3
  6. No drop-down menus or hard-coded years in calculations
  7. Match tooltips and number formatting

 

Additional Information:

  • Predictive model type used: Gaussian process regression “model=gp”
  • Prediction Residual = Actual Value-Predicted Value

Dataset

This week uses U.S. Dept. of Education National Center for Education Statistics.  You can get it here at data.world

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.  Also include the hashtag #WOW2021 in your description to make it searchable!

Share

After you finish your workout, share on Twitter using the hashtag #WOW2021 and tag @AnnUJackson, @ItsCandraM, @LukeStanke, @_Lorna_Brown and @HipsterVizNinja

Solution

Interactive

Leave a Comment

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top