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

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 #24: ARIMA Time Series

DemandEngineer
8 - Asteroid

I enjoyed this for the most part as I've never worked on forecasting with time-series data.

 

I thought I was going crazy or using the tools wrong... My High and Low forecast didn't match...  Then I finally gave up and checked the solution and it turns out the solution had the same values.  But these are different than the supplied Answer in the start file.  Please update the start file.

 

Does the ARIMA tool assume the data is sorted order already as it doesn't ask for a time field... only the frequency.

SgdPackard810
8 - Asteroid

Quirky little challenge to solve the missing data at the beginning; simple ARIMA and TS Forecast tools thereafter (auto settings, no need to perform any seasonal or non-seasonal differencing to stationarize the data, we were told to use ARIMA so no need for holdout data and comparison against an ETS model). 

 

Had a little bit of trouble with my TS Plot tool, the decomposition plot was unavailable even though two full periods (2 years of 52 weeks) were present in the dataset. Would have liked that feature, used in conjunction with the ACF and PACF plots to help me manually agree to the settings chosen by Alteryx within the ARIMA tool. 

 

Oh well! Fun challenge all the same.

JethroChen
10 - Fireball
Spoiler
challenge_24_jc.PNG
phottovy
13 - Pulsar
13 - Pulsar

Another challenge down!

JoePC
9 - Comet

Solution Attached

AlexC2
8 - Asteroid

haven't used the Time Series tools much, great challenge to try it out.

 

Spoiler
AlexC2_0-1599577605569.png

 

Per
11 - Bolide

Not too hard (until all the parameters need tweaking that is)

Tokimatsu
12 - Quasar

Solved.

Spoiler
2020-09-21_13h12_29.png

liamholland
8 - Asteroid

Solution:

Spoiler
Screenshot.png
LHolmes
9 - Comet

Great fun! Love the interactive tour in the ARIMA I output anchor. Would be great for Alteryx to include some general good/bad ranges for the accuracy tests or provide in the documentation -  I though the results were more in the "fair" zone.

 

Spoiler
024 - Solution.PNG