Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #94: Have we reached Peak Pumpkin?

ChristineB
Alteryx Alumni (Retired)

A solution to last week's Challenge has been posted here.   I loved seeing the variety of solutions that our Challengers came up with!  Admittedly, my solution probably has more tools than it should but it gets the job done...with only one Join tool!  In the spirit of friendly competition, especially with the self-imposed challenge of "how many Join tools does it take to calculate pumpkin production", I thought I'd give a shout out to our "winner".  Last week, our Challengers' solutions contained an average of 4 Join tool.  Our "winner" with the Fewest Join Tools used: @vishalgupta, with 0 Join tools!  You read that right...ZERO!  There are a few Find/Replace tools in there, though...but I'll take it!  Take the time to check out everyone's solutions; the variety is awesome, and I learned a few new tricks myself! 

 

This week's Challenge will give you the chance to show off your skills with the Predictive Tools to answer one of the most pressing issues of our time: Have we reached Peak Pumpkin?  Is the time of the demand for EVERYTHING PUMPKIN losing steam?  Has Maple Pecan become a force to be reckoned with?

 

For this week's Challenge, we have five input files, one for each branch of a store, with data on pumpkin product sales from 2010 to 2016.  Amalgamate the data into a single data stream to forecast the total expected sales for each product category for the year 2017.  

 

Notes:
- Any Null values should be filled with the average value of that product for that week, across all stores.
- You will need to install the Predictive tools to use the Time Series tools (if you don't have them installed already). 
- Choose the time series model whose Akaike Information Criterion, corrected (abbreviated by AICC) are consistently lower. The data from Store 1 is the best and most complete dataset to use for deciding on a model since it contains no Null values.
- The Predictive District on the Gallery has some tools and samples that you may find helpful for this exercise!

 

Notes for Users on versions 2018.2 and more recent: 

Changes to the version of R used in the Predictive tools have caused ARIMA calculations to yield different results than those in the original post.  Please reference the following instructions and start/solution files:

Any Null values should be filled with the average value of that product for that week, across all stores. 
- You will need to install the Predictive tools to use the Time Series tools (if you don't have them installed already). 
- Perform this challenge using an ETS model to forecast values for the next year.  Leave all settings, aside from those needed to configure the model, to "Auto". 

- Expect your output to contain negative values

- Refer to the start file "challenge_94_2018_2_start_file.yxmd" and solution file "challenge_94_2018_2_solution.yxmd" that I posted to my reply to another Community user on page 3 of this Challenge's post. 

 

 

 

    

LordNeilLord
15 - Aurora

Hey @ChristineB,

 

Is this the correct start file? It looks the same as last weeks :)

ChristineB
Alteryx Alumni (Retired)

@LordNeilLord It's only lunch and I've already reached Peak Monday!  The Start File has been updated.  Thank you for setting me straight!

patrick_digan
17 - Castor
17 - Castor
Spoiler
2 for the price of 1! I thought there was an error with the factory tools, so I created a quick batch with the normal TS tools. Turns out it was just user error :) 

I used the directory tool and the 2 dynamic inputs to get all the data aggregated. I transposed it and just sent store 01 through the ARIMA and ETS to see that ARIMA had a lower AICC. Then I filtered the data for nulls and got the average to fill the holes. I summarized the data at the week and product level before running it through the time series tools (my quick batch process vs the factory tools).
Capture.PNG
LordNeilLord
15 - Aurora

I spent ages trying to get the answer just using the standard time series prediction tools but I couldn't get the right result....so I switched to using the Predictive District tools and STILL couldn't get the correct result. After much swearing I finally realised that I had only imported 4 out of 5 excel files! Lesson learnt...make sure you import all of the data first!

 

Spoiler
Weekly Challenge 94.png

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
I created a macro to loop through each of the different products and get their forecasts.

challenge 94.PNG
NicoleJohnson
ACE Emeritus
ACE Emeritus

My solution!

 

Spoiler
Very similar to @Kenda - went the Batch Macro route as well. Also, I clearly need more forecasting practice in my life. :)

WeeklyChallenge94.JPG

NJ

paul_houghton
12 - Quasar

This is my first version. Everything matches except for the produce. Not sure why yet

 

Spoiler
Challenge 94 test run.jpg
paul_houghton
12 - Quasar

Doesnt look like the solution has been packaged right. Lots of broken macros.

ChristineB
Alteryx Alumni (Retired)

@paul_houghton, it's packaged now!  That should be better!