community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #89: Analyzing Social Data

Alteryx Partner

Challenge 89 is done and ready to take into Tableau!

Spoiler
challenge 89 JMS solution.PNG
Alteryx Certified Partner

I was interested in doing some word analysis and see what words kept coming up for the different hasthags. I started by cleaning up the tweets, removing duplicates and removing any words that had an @ or # sign preceeding it as I didn't want to look at tagged users and hashtag words. I split up the tweets on each word to find the recurring words and themes and then built a simple chart in Tableau that shows the top 10 words for each file based on how many times tweets containing the word was retweeted. This could do with more work but I thought it was an interesting way to get a gist of what people were talking about.

 

Spoiler

 challenge_89.PNG

challenge_89_chart.png

 

Asteroid

just some basic cleanup

 

Alteryx
Alteryx

I kept it simple. Adjusted data types, created frequency lists for words and hashtags. Still not sure where I'm going with this...

Alteryx
Alteryx

My solution, did a little data cleanup and explored network relationships between tweets and replies:

 

Spoiler
Capture.PNG
Comet

Here's my solution:

Spoiler
Challenge 89.PNG
Alteryx Certified Partner

I performed sentiment analysis but the workflow seems a bit broken... I think I will discontinue this challenge as I can only limit the stream to tiny amounts of data that I can process

Spoiler
89.png

I stopped the workflow after well over an hour as I could no longer work with this data. My intention was to show the least positive subject (hashtag) and the most positive user (ID) in more detail, but that seems too difficult for this tool to do, unfortunately
Asteroid
Spoiler
2019-07-30 17_26_25-Greenshot.pngLook who's in the Top 10 of Total Tweets with these hash tags

Very interesting that the user 'Nili Majumder', who had the most 'User Total Tweets' has ballooned his tweets since 2017.  He's up to almost up to one million tweets (848k as of 7/30/2019).  Who has time to write that many tweets?  His account exemplifies bot behavior posting ~1,000 tweets/day since 2017.

Alteryx Alumni (Retired)

Made a wildcard for the CSVs, then ran some basic analytics on each hashtag. Cool challenge!

Quasar

I like how this challenge is open ended! Here is my data prep part of the challenge:

 

Spoiler
Capture.JPG