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

gawa
16 - Nebula
16 - Nebula
Spoiler


image.png

I recently started to use Power BI. It's fun,

karlhansen
9 - Comet
Spoiler
solution_90.jpg

output_90.jpg

mithily
8 - Asteroid
Spoiler
used provided solution to visualize
H_a_n_g_C_h_e_n__x3
8 - Asteroid

Reused the one from last challenge

mshishido
8 - Asteroid

Decided to make a different approach: use a LLM to generate insights after cleaning the data. Here are some results:

output (1).pngTop 10 Most Common Hashtags.pngoutput.png
  • Total Tweets: 107,775
  • Average Retweets: 263.97
  • Average Favorites: 1.00
  • Unique Users: 54,625
  • Most Retweeted Tweet: "RT @araburu_fafa: ????????????????????????????????????????????????????????? https://t.co/zOJ4OwMXSt"
  • Most Favorited Tweet: "Bro.. Unga Visuals ku Match pannanumla ?? Nandri ???? https://t.co/cHtXWPQgwk"
DaisukeTsuchiya
14 - Magnetar
Spoiler
90_スクリーンショット 2024-09-08 110724.png
Bobbyt23
12 - Quasar

Just created a simple bar chart with the data to highlight top 10 hashtags.