Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAJust beginning to learn predictive tools, so this one took a bit of time. Fortunately, we didn't need to know what all those fields actually mean
This was definitely helpful, as I've struggled a few times getting Alteryx to successfully run and score the model (I had tried this one a couple times awhile back). Realized that...
correlation analysis tool to find top 10 variables, use those in the linear regression tool, score tool to test it on the filtered data for the teams instructed, subtract from 162 to get losses, summarize to find max, append, subtract wins from max to find games back
My approach is a little different in that I "automated" the selection of the top 10 predictor variables. First I identify the 10 with the highest correlation (Sort by the correlation in descending order, Sample first 10 records) and then Join this list to the original data set which has been Transposed (so that each team and variable is a single row). This allows me to simply "select all" in the Linear Regression tool (and just deselect the two irrelevant variables).