Free Trial

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.