Note from Ann: Today’s guest post is from Johanna Morariu, Director of Innovation Network, AEA DVRTIG Chair, and dataviz aficionado.
Basic social network analysis is something EVERYONE can do. So let’s try out one social network analysis tool, NodeXL, and take a peek at the Twitter hashtag #eval13.
Using NodeXL (a free Excel plug-in) I will demonstrate step-by-step how to do a basic social network analysis (SNA). SNA is a dataviz approach for data collection, analysis, and reporting. Networks are made up of nodes (often people or organizations) and edges (the relationships or exchanges between nodes). The set of nodes and edges that make up a network form the dataset for SNA. Like other types of data, there are quantitative metrics about networks, for example, the overall size and density of the network.
There are four basic steps to creating a social network map in NodeXL: get NodeXL, open NodeXL, import data, and visualize.
Do you want to explore the #eval13 social network data? Download it here.
Here’s where SNA gets fun—there is a lot of value in visually analyzing the network. Yes, your brain can provide incredible insight to the analysis process. In my evaluation consulting experience, the partners I have worked with have consistently benefited more from the exploratory, visual analysis they have benefited from reviewing the quantitative metrics. Sure, it is important to know things like how many people are in the network, how dense the relationships are, and other key stats. But for real-world applications, it is often more important to examine how pivotal players relate to each other relative to the overall goals they are trying to achieve.
So here’s your challenge—what do you learn from analyzing the #eval13 social network data? Share your visualizations and your findings!
Dan Goldstein
Nov 1, 2013 -
Very cool tool, thanks for sharing!
Ann K. Emery
Nov 4, 2013 -
Hi all,
Here’s a visualization from Marc Smith (@marc_smith), which uses the post-conference week data: https://twitter.com/marc_smith/status/396303552596803584
Once you click the link for his social network map, try clicking on “view an interactive version of this graph.” I like that version because it helps you see the strength of the relationships between players.
Enjoy! Ann
Joitske Hulsebosch
Nov 4, 2013 -
Hi Johanna, I always have troubles showing the labels – I sometimes manage and sometimes I don’t – do you know the trick?
johannamorariu
Nov 4, 2013 -
Hello Joitske, let’s see, for the version of NodeXL I’m using, the steps are:
1. Working in the “Vertices” tab of the spreadsheet: In column C (“Visual Properties” section, column “Shape”), change the value for all cells to “Label”. You can do this by selecting all of the cells and clicking on the NodeXL tab, then on “Vertex Shape” and then on “Label.”
2. In column H (“Labels” section, column “Label”), change the value for all cells to reflect the lable you want displayed—often a copy-paste from the name of the vertex itself.
3. On the map, click “Show Graph” or “Lay Out Again.” Your map should now have labels. It might be messy, but they’re there! Now make it pretty:)
Hopefully that works for you, too!
Johanna Morariu on #eval13 Network Analysis with NodeXL · AEA365
Nov 7, 2013 -
[…] What do you see when you look at the #eval13 network? To do your own analysis of the dataset, access it here. […]
petrudumitru
Dec 12, 2013 -
Hi, thank you for sharing. What about using Twitter data stored into an excel file? How to place them in Nodexl and get different visual outcomes?
Ann's Blog | New-ish Charts for Evaluation
Jan 12, 2014 -
[…] to create your own? Check out Johanna Morariu’s tutorial on using NodeXL, a free Excel […]
ASK THE CENTER: How to use data visualization to better tell your story (February 2014 FGN) | Family Giving News
Feb 28, 2014 -
[…] a bar chart or line chart. Later on, once you’ve mastered the basics, try dot plots, slopegraphs, social network maps, tree maps, or waterfall […]
| The Dataviz Design Process: 7 Steps for Beginners
May 1, 2014 -
[…] charts—try bubble charts, bullet charts, dot plots, heat maps, scatter plots, slope graphs, social network maps, tree maps, waterfall charts, and […]