Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

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 #90: Analyzing Social Data (Part 2)

A2H
11 - Bolide
Spoiler
Challenge_90_A2H_Page_1.jpgChallenge_90_A2H_Page_2.jpgCapture d’écran, le 2020-11-18 à 13.00.21.png
Qiu
21 - Polaris
21 - Polaris

Just learn, not good at Visulization.

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Workflow(little changed from challenge89)

Spoiler
90wf.jpg

Tableau Dashboard:

 I focused on

 - How spread it is(total follower).

 - Who most retweeted

Spoiler
dashboard.jpg
Hast tag WTD2017, UNGA2017 and IY2017 has spike.
Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my dashboard !

PhilipMannering
16 - Nebula
16 - Nebula

Solution to part 1 attached.

Tokimatsu
12 - Quasar

These are the hashtags that were tweeted at the same time as the UNGA and other hashtags. Among these, IRAN, FREESOUTHERNCAMEROONS, and RESTORATIONNOW were tweeted more times by one person than the others.

2021-01-24_13h25_42.png

tammybrown_tds
9 - Comet

I might revisit this one when I have more time and make something in Tableau, but for the challenge, I did some charting and layouts using Alteryx Reporting Tools.

 

Screenshot 2021-02-08 153002.jpg

Sashikumar
8 - Asteroid

Solution.

Spoiler
ch90.PNG
mpennington
11 - Bolide

I built out two charts, one summarizing top hashtag counts and the second segmenting tweets by region.  Attached.

 

Spoiler
WorkflowWorkflowPDF OutputPDF Output
Laurap1228
11 - Bolide

My very simple chart, actually took me ages to make in Alteryx 😕

Spoiler
 Laurap1228_0-1626999289667.png