Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #89: Analyzing Social Data

Sr. Instructional Designer
Sr. Instructional Designer

A solution to last week's Challenge has been posted HERE!


This week’s Challenge is a bit different from the norm.  This week, you’ll pick your own Challenge!


We’ve gathered a week’s worth of Twitter data using 10 different hashtags that relate to the most recent meeting of the United Nations General Assembly.  This meeting brought world leaders and diplomats together to discuss a variety of humanitarian concerns which, as you can imagine, generated engagement across social media networks like Twitter.  For this challenge, we collected the most recent data on #hashtags related to the UN’s Sustainable Development Goals.


We’re curious to see what kinds of insights you, the Alteryx Community, derive from the datasets.  Is your Challenge simply to cleanse and organize the data?  Awesome!  Is your Challenge to apply your knowledge of social media analysis to this dataset?  Great!  Is your Challenge to create an app to allow an end user to pull the relevant tweets by date or keyword?  That’s fantastic!  We’re excited to see how you Challenge yourself this week. 


As a heads up: this week’s Challenge is only the beginning of our data mining adventure!  This week, your Challenge is to prepare your data in any way, shape or form for next week’s Challenge: visualizing the data in a platform of your choice (Tableau, Alteryx, Plotly, GIF, etc).  We look forward to seeing your data manipulation prowess on display this week, and your creative ways to visualize data the next week!   


When you're ready, share your unique "solution" by posting your workflow and describing what your next steps will be for visually displaying your findings. 




E_Logo_No UN Emblem-01.png



Alteryx Certified Partner

Hi @ChristineB,


The input files aren't working, can package the workflow up?

Sr. Instructional Designer
Sr. Instructional Designer

Thanks to everyone who alerted me that the input files were missing!  My Challenge for this week: successfully sharing input data in a workflow :)  Now, it's your turn! 

Sr. Instructional Designer
Sr. Instructional Designer

New start file added to address some issues with Tweet and User IDs represented in scientific notation...


The attached package has .yxdb files that were generated for the same keywords using the Alteryx Twitter Search app from the Gallery at!app/Twitter-Search/574db168a248970bdc36d527


The downside is the attached data files are from a different time frame, since the free API only searches 7 days back. The upside is no data loss issues in the ID or Unicode text.


Standardised city and country using Wikipedia lists and created simple report on top trending hashtags, most re tweeted tweet and comparison on number of tweets from different countries/cities

I cleaned up the data by using only one input tool, parsing out the hashtags, converting the date/time to Alteryx, removing nulls and bad characters (?), and summarizing the hashtags by input file.  

Did some very simple data cleansing, and then used Tableau to look for patterns in the data.

Focussed on tweets over time (time of day, and retweets over time); and on the hashtags that got to the most followers


With this one - now caught up with the challenges; and with the leaders ( @NicoleJohnson ; @patrick_digan ; @EstherB47 ; @LordNeilLord - and @nick_ceneviva is catching up very fast!)








Alteryx Certified Partner
Alteryx Certified Partner

@patrick_digan I will try to get to this one later... @MarqueeCrew

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.

I went for the "sustainability is a form of artistic expression" route, and channeled King Triton in my workflow design (although lets be honest, Ariel was really the one with the penchant for reducing-reusing-recycling with her stash of treasure...). At any rate, after a little data cleanup I prepared a few branches illustrating the type of insights I expect to include in Weekly Challenge #90, but also sent the results to a .yxdb file for easy visualizing next week. Thanks for starting us on such an interesting challenge, @ChristineB - fun to be a little more creative this week!


Data cleanup included: Date formatting, Parsing the hashtags and then grouping by all fields to remove duplicate entries (based on information from the same tweet potentially appearing in more than one source file). 

Possible insights: Top 5 Tweets based on # of Retweets, Top 10 Hashtags by order of popularity based on # Tweets, Top 5 Favorite Tweets, Most Active Tweeter, and Most Active Retweeter.


ariel quote.PNG