Posts Tagged ‘perceptual edge’

NodeXL: Network Visualizations in Excel (Visual Business Intelligence)

Thursday, February 25th, 2010

[Editor's note: Visualizing complex connection topologies is made easier with a new plugin for Microsoft Excel. Now someone needs to port it to Flash ActionScript 3!]

Republished from Visual Business Intelligence.

This blog entry was written by Bryan Pierce of Perceptual Edge.

The chances are good that you’ve seen network visualizations before, such as the one below in which the circles and octagons represent large U.S. companies and each connecting line represents a person who sits on the board of both companies.

(This image was created by Toby Segaran: http://blog.kiwitobes.com/?p=57)

While these types of graphs have become more common in recent years, there’s still a good chance that you’ve never created one yourself. This is because, traditionally, to create network visualizations, you’ve either needed specialized (and often unwieldy) network visualization software or a full-featured (and usually expensive) visualization suite. That’s no longer the case. A team of contributors from several universities and research groups, including the University of Maryland and Microsoft Research, recently released NodeXL, a free add-in for Excel that allows you to create and analyze network visualizations.

Using NodeXL you can import data from a variety of file formats and it will automatically lay out the visualization for you, using one of twelve built-in layout algorithms.

Continue reading at Visual Business Intelligence . . .