Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEACan finally attach files, although cannot edit my previous reply
Cheated a little bit... Changed the URL to this one which only has the last 7 days of data
Just made it way quicker to download a much smaller data set that didn't need half the filtering.
A challenging and very interesting exercise - learned a lot, especially the value of caching data - yikes!
DURANGO MOUNTAIN RESORT would be the place to be on 11/24/2019 if there was any snow happening this early in the season.
As of today it could be once again relevant to do this type of analysis - opposed to doing this challenge in spring/summer time.
Workflow
Macro: