Tuesday, July 29, 2008

Social networking comes to Microsoft Excel

Marc Smith's Community Technologies research group at Microsoft Research has just released .NetMap which is a plug-in to do social network analysis in Microsoft Excel. This was presented at the Microsoft Faculty summit this week. Just import your data into Excel and let .NetMap visualize the social network, calculate centrality, and do all the other stuff that UCINET, Pajek and NetDraw do. Gone are the gzillion steps that you have to do in order to get the visualization of the social network (in my PhD thesis, this involved MySQL to get the actual data in a table format, creating a DL file to import into UCINET, then taking the file and converting it into Pajek to use Pajek features, or visualizing it in NetDraw).

More details of .NetMap are below:

New tools from Microsoft Research make performing many basic network
manipulations and visualization tasks as simple as using Excel. The (Excel)
.NetMap add-in provides directed graph charting features within Excel,
allowing users to create node-link diagrams with control over each node and
edge color, size, transparency and shape. Since .NetMap builds within Excel,
all of the controls and programmatic features of Office are available.
Additional features of (Excel) .NetMap generate social networks from data
sources like personal e-mail (drawing data from the Windows Desktop Search
engine). Arbitrary edge lists (anything that can be pasted into Excel) can
be visualized and analyzed in .NetMap. To download the Excel .NetMap Add-in
and slides, go to the following Web site in CodePlex (Microsoft's version of SourceForge).

I'm going to try it out and see how it works. Of course this could have saved me time in my PhD research analysis!

On Technorati: , ,

No comments: