We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. 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 #89: Analyzing Social Data

tristank
10 - Fireball

I did some basic cleanup of the Global Goals dataset. I wanted to look at original tweets only and split the hashtags by row so I can do some hashtag visualization. Fun stuff!

 

Spoiler
89.png

 

olga_strubbe
10 - Fireball

Thank you, @ChristineB !  Still not able to upload the screenshot - I submitted a ticket to support.  Please see my app attached. 

I used a similar approach for building an app as Christine, you recommended in your solution.  Thank you! 

rachel_lynch
Alteryx
Alteryx
Spoiler
Analyzing Social Data.png

Rachel Lynch
Carolyn
8 - Asteroid

Solved. I went with an App so the user can select their hashtag and then see how many tweets the hashtag is in, and which other hashtags are with it

 

Spoiler
2023-08-10 15_13_41-Window.png

ed_hayter
12 - Quasar
Spoiler
Tried to keep it simple whilst also making the final table flexible for analysis. Opted for a wildcard input to simplify the flow. Split tweets with multiple hashtags into separate rows. We will just need to remember to use a count distinct for IDs when conducting particular analysis to avoid duplication error. I also parsed out the tweet content columns and date time to make them work more effectively. I filtered out cases where the tweet content was unrecognized characters (?????? ????).

Challenge 89 WF Image.png
mithily
8 - Asteroid
Spoiler
not my fave type of data 
gawa
15 - Aurora

Simple analysis

Spoiler
image.png
egalicha
7 - Meteor

My Solution

mithily
8 - Asteroid
Spoiler
used provided 89 solution to visualize
BS_THE_ANALYST
13 - Pulsar

Didn't build a viz yet, just configuring questions for now:

Spoiler