Note: you can download the Visio and Excel files that accompany this article at the end of the post…you know, way down there, at the bottom! The Data Setīefore we can begin to visually analyze data we, obviously, need data to analyze in the first place.
So… roll up your sleeves, fire up your copies of Excel and Visio, and let’s get comfortable with the power of Visio 2007 Professional Edition Pivot Diagrams. We’re going to do this in a relatively few number of steps, and without the headache of the overwhelming set up required for those Excel Pivot Tables. So let’s look at how Visio Pivot Diagrams are constructed and how to work with them to maximize the understanding of the underlying data. The old adage that a picture is worth a thousand words can easily be extended to be “a single hierarchal diagram is worth ten thousand grid-like cells”. Visio Pivot Diagrams allow you to visually “Drill In” and “Roll Up” data and understand structure and hierarchy. Visio Pivot diagrams are the visual alternative to structured, yet still tabular data as shown in Excel. With the introduction of Microsoft Office Visio 2007 Professional, the Visio development team created a new, and FAR easier way to “slice and dice”– to visualize complex data sets in an intuitive and visually appealing manner.
If you have ever created a Microsoft Office Excel 2007 Pivot Table you will understand that they are (a) very powerful indeed, and (b) less than intuitive and more than frustrating to create in the first place. David is a fellow Microsoft Visio Most Valuable Professional (MVP), a one-time co-worker of mine at Visio Corp., and is currently the CTE/Director of Consulting Services at.
This guest post and content was created and written by David Edson. Visio lets you drill in and roll up the data to understand structure and hierarchy the way we were meant to understand it: visually! If you’ve ever created pivot tables in Excel, then you’ll want to see how you can create Pivot Diagrams in Visio 2007 Professional.
0 kommentar(er)
