If you’re a mind mapping or concept mapping enthusiast, you know how effective these tools can be. Ideas, processes, and decisions are clarified and presented with powerful visuals–something BigPicture for Excel software does with ease:
But BigPicture can go beyond these diagrams. One of the software’s stand-out features is its ability to link to Excel spreadsheet data, and automatically reflect any changes in that data should it change–creating what we call a ‘live-linked data map’. This feature allows you to automatically display your data as visual maps that can be manipulated, customized, and hyper-linked to other resources.
That means you can take data, such as a compiled list of the final MLB (Major League Baseball) standings, plus other information, for the 2014 season:
This data sheet has one row for each of the 30 MLB teams. It lists the team name, division, league, location, and two hyperlinks for team information. It also lists the number of wins and losses, the winning percentage, and total runs scored for each team.
That information can be easily converted into a map that looks like this:
This map displays League and Division, and features end tables of the teams in a given division, along with their wins, losses, winning percentage, and runs scored. The end tables also show markers and hyperlinks for the teams and their locations. All that data from the spreadsheet is now shown in a visual, logical map that can be easily read and understood.
Want to learn how to do this yourself? Head over to our BigPicture Help Manual, and check out the step-by-step guide, “What is a Data Map and how do I create a Data Map?”