Challenge #90: Analyzing Social Data (Part 2)

This week’s Challenge is a continuation of last week’s analytic adventure!

Now that you’ve analyzed the Twitter data containing hashtags related to the most recent assembly of the United Nations, you’re ready for your next Challenge: visualizing the data to tell a compelling story about the insights you’ve found. You may choose to communicate your findings through a Tableau dashboard (and you want to try that new cool thing you learned at last week’s TC!), or you may find that your findings are best explained with a viz you can whip up in Plotly. As for me, I’ll be spending some time playing with the Visual Layout Tool in Designer to create a report that’s part of an output from the app I created.

How will you Challenge yourself to visually tell the story behind your insightful analysis? Share your completed viz below to complete this week’s Challenge!

Not caught up on the Challenges yet? Take a look at Challenge 89 where our analytics adventure begins! Use the data from the start file to analyze the Twitter data in any way you choose, then create a visualization of your analysis!

Reporting

Advanced

Data Analysis

Reporting and Visualization

Difficult

Accepted answers

All comments

SeanAdams

Hey @ChristineB,

:-) seems I can re-use last week's submission!

This was done using a Tableau Story, so then notes on-top are self-descriptive.

challenge_89_SeanSolution.yxmd

VisualizeTweets.twb

patrick_digan

Spoiler

I used the standard Alteryx reporting tools to produce a pdf with hashtag count:

challenge_90_start_file.yxmd

Kenda

Spoiler

I stuck with the Alteryx Reporting tools for this output.
most hstg.PNG

challenge_90_BarnesK.yxzp

jezknee

Hi!

This is my first Alteryx challenge, so I hope I've done a decent job! My viz is here on Tableau Public. Feedback is very welcome, as I'd like to improve it.

It looks like this:

Pic - UN development.png

JefBus

I threw it into Gephi, and came to this beauty, a little rough around the edges, it's my first time using Gephi,
This is 5K tweets instead of 1.5K, too many connections makes my laptop sweat, going to give it a try on the bog machine tomorrow.

This is fun!

As for the story behind it: Just follow the little arrows down the rabit hole...
I've been exploring this map for 20 min now, and nowhere near done, I swear Bill Gates is in there somewhere!
The entirety, we see quite some poles of increased activity

Dan_Unga and the questionmark people ("??? ?? ???? ???? ?? ??????? ????"-type tweets ring a bell? quite a few of those)

The UN itself

Go Ladies! ( I may have accidentally resized suzy chap and Sakoya3333

and look who's here

NicoleJohnson

Catching back up! Gotta make sure I'm nice & limber for that 100th Challenge summit...

Did my visuals playing around in PowerBI. Fun exercise to see some pretty results from all this fun data crunching! Included a date range filter, Top 10 Hashtag Count, # of Tweets & Retweets by Date, Top 5 Favorite Tweets, and a display of Tweets & Retweets based on users with the most followers.

estherb47

Worked quickly on this, so not 100% satisfied with the organization of the page. On the Tableau dashboard, you can click on an influencer to see what they are tweeting about. You can control the # of influencers to show using the slider on the right.

If you don't have Tableau, you can grab the free reader from Tableau dot com, and play around with the dashboard. Except that I'm unable to upload my workbook, which is saved as a twbx. Any ideas/suggestions?

LukeL

I analyzed the last 10 days of Twitter data for Alteryx -- workflow below:

Most of the metrics relied on a calculated affinity score -- a weighting of both retweets and favorites (combined into a single metric):

score formula.PNG

Output graphics below:

rt affinity avg.PNG rt affinity.PNG rt count.PNG
tokens wordcloud.PNG top tweets table.PNG

LandonG

Solution attached.

challenge_90_start_file.yxzp

philipmannering

Looks like people give up on the hashtag business a few days into the conference. Tableau workbook attached.

challenge_90 - Snip.PNG

LordNeilLord

Finally got round to doing this one]

Weekly Challenge 90 Output.png

challenge_90_LNL.yxmd

ggruccio

Tableau dashboard from last week attached - I may not know exactly what makes a compelling viz for this type of data - but it was fun to put together! Zipped because the site doesn't like .twbx file format.

challenge90_gg_finish.7z

samN

nothing fancy

challenge_90.yxmd

jamielaird

Here's my viz, focusing on the #GlobalGoals hashtag.

Spoiler

challenge_90_solution_JL.twbx

jasperlch

Solution attached.

challenge_90_JL.yxzp

Natasha

I also was curious about the tweet / retweet development overtime. In general the ratio of tweets and retweets is about the same. There are some interesting outliers however. For example #sdginnovation has only five original tweets, but it was retweeted more than 300 times!

I also spend a bit more time in Tableau than originally planned. Below is the link to the dashboard and a screenshot

https://public.tableau.com/shared/5M7K2Q5PQ?:display_count=yes

Screen Shot 2018-01-07 at 15.48.13.png

Challenge_90_Natasha.twbx

challenge_89_Natasha.yxmd

kcgreen

I created a word cloud around "We" statements in Power BI to see what was being tweeted and retweeted on behalf of the collective "We." I thought it was fascinating to see all these statements and to see which ones resonated more based on how often it was tweeted or retweeted.

In this dataset, the most recurring "We" phrase was "We must do more." That seemed like an appropriate sentiment to get the most support.

I loved challenges #89 and #90. They were tons of fun

challenge_89_start_file.yxmd

Elena_Caric

My viz is out on Tableau Public: Go to Tableau Public to see the viz

ANALYSING TWEETS AND HASHTAGS.jpg

Elena_Caric

ANALYSING TWEETS AND HASHTAGS.jpg

JosephSerpis

Challenge Complete

Challenge_90_Joe_Serpis.yxmd

kelly_gilbert

This week, I wanted to challenge myself to use Alteryx's reporting tools. I spent A LOT of time on this simple report (and it still doesn't line up quite right). However, I learned a lot,and now I am MUCH more familiar with the reporting and layout tools now!

challenge_90_output_klg.pdf

challenge_90_solution_klg.yxzp

danilang

Simple Chart of most popular tweets

Chart 90.png

Spoiler

Dan

challenge_90_solution_dl.yxmd

kat

Spoiler

I chose to venture a little into Alteryx charting. Can't wait for 2018.3 visualizations!
Challenge #90.PNG

Challenge #90.yxzp

JoBen

Cheers! I think I jumped the gun on the previous challenge, so I came up with a few new things.

Spoiler

These are two Tableau graphs that show a time phased map that corresponds to the number of times a particular country or continent is mentioned in a tweet (according to the English spelling of the country). In first one, the larger the bubble, the greater the number of times that country is mentioned. In the second one, the redder the color, the more times a country in the continent is mentioned.

Times a country is mentioned in a tweet per day

Continental view of previous graph

jssandom

A simple dashboard

pasccout

Nice little graph based on my values for Challenge 89

challenge_90_my_solution.yxmd

AJauniskis

Spoiler

I chose to show most popular hastags and most active users; tweets by date/time of day. Nothing fancy, just Alteryx reporting tools

Spoiler

challenge_90_AJ.yxzp

ipeng

It is great to see all these fancy charts! I also did a network analysis (tried to greatly simplify the data, only take the first two hashtag combination for network plot.

IP_challenge_90_start_file.yxmd

RichoBsJ

Hi! I added a Interactive Chart tool to the app of the challenge 89 (modified )

Spoiler

challenge_90_richobsj.yxzp

cplewis90

I made some adjustments to last week's output by adding some titles, an image and just some other cleanup. I also added an output report so I can send it to others.

Spoiler

challenge_90_CL.yxmd

RolandSchubert

My solution - added some interactive charting to last weeks workflow.

Challenge_90_solution_rsc.yxmd

JoshuaGostick

Feels a bit like cheating but here's the chart I built for the previous challenge.

Spoiler