Challenge #147: EMEA Grand Prix Prelims - Time Series

Happy 2019! Your first weekly challenge of the year is a question from the 2018 EMEA Grand Prix preliminary round. You are tasked with building a time series model to predict how many units of a product should be stocked in the future to keep up with demand.

And, if you hadn't heard, we are hosting our first ever APAC Grand Prix at the Inspire on Tour event in Sydney on 21 March 2019. So if you plan to join us in Sydney, head over the Grand Prix blog and sign yourself up for the preliminary round.

challenge_147_start_file.yxmd

Developer

Preparation

Predictive Analysis

Intermediate

Predictive

Accepted answers

All comments

patrick_digan

Spoiler

challenge_147_start_file.yxmd

cgoodman

Bit of a cheat given I did this in the prelims.

Spoiler

Challenge 147 solution.yxmd

NicoleJohnson

My Solution!

@patrick_digan, I see you are starting off 2019 with your "Notify me the second the Weekly Challenge posts" alarm up and running...

Spoiler

Cheers to a new year of my favorite weekly activity!!

challenge_147_NicoleJohnson.yxmd

CharlieS

Challenge_0147-CharlieS_Solution.yxmd

JoBen

Cheers!

Spoiler

challenge_147_Joben_Solution.yxmd

TylerNa

Happy New Year!

Spoiler

WC147 Time Series TN.yxmd

estherb47

Happy 2019 everyone! So happy to return to one of my favorite weekly activities.

Spoiler

challenge_147_EHB_Solution.yxmd

KevinW

Spoiler

challenge_147_solution.yxmd

WilliamR

Hello,

here is my solution.

Spoiler

I have used the imputation tool because first I have tried to use the TS Forecast Factory and some products have missing values.

challenge_147_WilliamR.yxmd

robertlenius

Spoiler

RL - challenge_147_start_file.yxmd

Ladarthure

Nice Challenge!

challenge_147_start_file.yxmd

AGoyal

Done.

Spoiler

challenge_147_start_file.yxmd

ipeng

Nice challenge! My solution attached.

IP_challenge_147_start_file.yxmd

jamielaird

Happy New Year! Hope everyone had a wonderful break. I'm looking forward to an Alteryx-filled 2019.

Here's my solution:

Spoiler

challenge_147_JL.yxmd

pjdit

Happy 2019! here's my solution.. Always fun. :-)

Spoiler

challenge_147_PD_Solution.yxmd

ddiesel

Thumbs up on this challenge!

My solution looks like everyone else's.

Spoiler

challenge_147_end_file_ddiesel.yxmd

JosephSerpis

Challenge Completed

challenge_147_Joe_Serpis.yxmd

vsoni

Nice and quick

Spoiler

challenge_147_completed.yxmd

RolandSchubert

My solution

challenge_147_solution.yxmd

clant

Here is my solution

Spoiler

challenge_147_start_file_finished.yxmd

chpoland

My solution

Spoiler

challenge_147_start_file_CP.yxmd

sprodger

My Solution, using a similar approach to others!

Spoiler

challenge_147_solution_SP.yxmd

ggruccio

Same forecast. I've labeled my first period 2014.

challenge_147_gg_finish.yxmd

That was interesting! My solution with 8 tools including in/out:

Spoiler

I think downloading the Time Series tools took longer than my actual solution, in the end. I thought we were going to have to do all kinds of cleaning of the date fields, but the ETS tool is amazing!!