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
15 - Aurora
15 - Aurora
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"