community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
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.

Challenge #89: Analyzing Social Data

Challenge 89 is done and ready to take into Tableau!

Spoiler
challenge 89 JMS solution.PNG
Asteroid

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...