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 #296: Breaking News - Headlines and Keywords

SylviaP
Moderator
Moderator

Weekly Challenge Image 296.pngHi everyone!

 

A solution to last week’s challenge can be found here.

 

In this weekly challenge, you will find a dataset containing the New York Times articles from January 1, 2020 to December 31, 2020.

 

Your first task is to identify which day of the week has the highest number of sports articles published.

 

Your second task is to identify how many times the word "Football" or "football" is in the headline or keywords on the day of the week that has the highest number of sports articles published.

 

As a final result, you have to write a statement similar to this: The word football appears ____ times in sports articles published on _____.

 

BONUS!

Forecast in what future month articles will surpass the 20 million comments milestone using the high end of the 70% confidence interval. (HINT: Consider a cumulative sum for all posts since 2020)

 

For the bonus, you will need to Download and Install Predictive tools [https://help.alteryx.com/20213/designer/download-and-use-predictive-tools]. Also, don’t worry if your output it’s slightly different from the output here. What is important is to understand the results.

 

Good luck!!

Aaron_Harter
11 - Bolide

Lots of Monday morning quarterbacks in the news!

Spoiler
0.PNG
patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1638198092002.png

 

PhilipMannering
16 - Nebula
16 - Nebula

Task 1 and 2 below,

 

Spoiler
PhilipMannering_0-1638198528423.png

 

alexnajm
17 - Castor
17 - Castor

Task 1 and 2 below, bonus perhaps to follow...

challenge_296_start_file_Alex Abi-Najm.PNG

 

Spoiler
Mine takes into account if the data updates and the "most published day" changes! 

 

 

binuacs
21 - Polaris
Spoiler
binuacs_0-1638200458690.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

I completed the Bonus challenge, but the value is a little different.

 

Spoiler
AkimasaKajitani_2-1638201733680.png

 


 

AkimasaKajitani_1-1638201563577.png

 

 

 

rafaaelgeo
6 - Meteoroid
Spoiler
rafaaelgeo_0-1638201976828.png

 

Spalders
8 - Asteroid

Tasks 1 & 2 without predictions

Spoiler
Spalders_0-1638202425085.png

 

Tony_Castillo
9 - Comet

Did not do the Bonus

 

Spoiler
Tony_Castillo_0-1638206295990.png