Visualizing Information with Microsoft Visio 2007
Download
Report
Transcript Visualizing Information with Microsoft Visio 2007
Smart Diagrams for IT Pros
David Parker, bVisual ltd
Microsoft MVP (Visio)
Microsoft MCP (Visio, SQL)
Pre-Microsoft acquisition
Post-Microsoft acquisition
http://www.visiotoolbox.com/productdetail.aspx?productid=9
WBS Modeler for Visio and Project
McGraw-Hill, 2007
http://www.visualizinginformation.com
DataLegends – Visio add-in to add Data Graphic legends
•
Microsoft Visio Solution Provider since 1999
Speaker at Microsoft Office Visio Conferences 2006 & 2008
Visio Solution Provider Training for Microsoft EMEA
Visualizing Information with Microsoft Office Visio 2007
•
Visio Business Partner, 1996-8
Speaker at Visio Conferences 1997 &1998
Started bVisual in 1998
www.wbsmodeler.com
Visio Blog
•
http://bvisual.spaces.live.com/
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
Review of Basics
Shape Data and User Defined Cells
Linking Data to Shapes
Connecting Items to Each Other
Summarizing Information with PivotDiagrams
Database Wizard
Using Data Graphics to Reinforce Information
Using Smart Tags and Actions
Creating Reports
Themes, Backgrounds, Borders, and Titles
Creating Custom Templates, Stencils, and Masters
Reviewers’ Comments
Preparing for Publication
Using Code to Enhance Functionality
Document Management and Security
Scenarios
Epilogue
Visualise complex information to better
understand it
Analyse information to identify trends and
issues and act on them
Communicate using diagrams that can be
shared with a broad audience
Customise and extend Office Visio 2007
programmatically to fit customised needs
• Templates in Categories
• Some templates load Add-ons
Standalone Editions
Office Visio 2007 Standard
Database wizard
Office Visio 2007 Professional
Data connectivity (new)
Database reverse engineering
UML models
Visual Studio 2005 Enterprise Architect
Visio 2003 Enterprise Architect
Database forward engineering
UML code generation
Drawing, Template and Stencil files
XML files
Binary (*.vsd, *.vst, *.vss)
XML (*.vdx, *.vtx, *.vsx)
7-10 larger than binary
Not yet a zip file (like the big three Office 2007
applications) with sub-folders and files
Files compatible with Visio 2003
Unless using new ShapeSheet formulae
Web
Browser
Visio Drawing
Graphics
Shape
Data Source
Prints
Data
Reports
Import
>
Link
>
Display
>
Communicate
Custom Properties
Definable cells in each shape to hold data
Limited data typing
Some Masters delivered with them
Database Wizard
Copies data to/from data source fields to shape cells
Only one data source per shape
Uses ODBC
Read and Write (optional)
Refresh on demand
Shape Data
Renamed from Custom Properties
Link Data to Shapes
Multiple data sources per shape
Read only
Uses Office Data Connections (*.odc files)
PivotDiagrams
Diagrammatic version of PivotTables (but slower)
Uses Office Data Connections (*.odc files)
Data Graphics
Data sensitive text and graphics on shapes
The Microsoft Active Directory Topology
Diagrammer reads an Active Directory
configuration using ActiveX Data Objects (ADO),
and then automatically generates a Visio diagram
of your Active Directory and /or your Exchange
200x Server topology. The diagrams include
domains, sites, servers, administrative groups,
routing groups and connectors and can be changed
manually in Visio if needed.
http://www.microsoft.com/downloads/details.aspx?Fa
milyID=cb42fc06-50c7-47ed-a65c862661742764&DisplayLang=en
The Microsoft Office Visio 2007 WBS Modeler
improves the project planning process by
generating Project Plans from a Work
Breakdown Structure (WBS) using a graphical
representation of elements.
http://www.microsoft.com/downloads/details.asp
x?FamilyID=34c28a49-e14c-4a7d-8d4990061fe08ab4&DisplayLang=en
This download contains a Microsoft Office
Visio stencil with shapes for Microsoft
Exchange Server 2007.
http://www.microsoft.com/downloads/details.asp
x?FamilyID=45f7ea49-ceb2-4b04-8d462b0ae5e10694&DisplayLang=en
The Office Communications Server 2007 Visio
stencil contains icons for Office
Communications Server 2007 server roles and
components.
http://www.microsoft.com/downloads/details.asp
x?FamilyID=543705f6-d02a-436e-8b345c796550022a&DisplayLang=en
Download SQL Server 2005 Data Mining Addins for Office 2007. This package includes two
add-ins for Microsoft Office Excel 2007 (Table
Analysis Tools and Data Mining Client) and
one add-in for Microsoft Office Visio 2007
(Data Mining Templates).
http://www.microsoft.com/downloads/details.asp
x?FamilyID=7c76e8df-8674-4c3b-a99b55b17f3c4c51&DisplayLang=en
The Microsoft Office Visio 2007 Connector for
Microsoft Baseline Security Analyzer (MBSA)
lets you view the results of an MBSA scan in a
clear, comprehensive Microsoft Office Visio
2007 network diagram.
http://www.microsoft.com/downloads/details.asp
x?FamilyID=95e0f821-9c2c-4287-915749c1205e08ef&DisplayLang=en
Download the Visio add in and the web server
component to connect and generate datasets to
connect to your existing diagrams or auto generate
your diagrams for your infrastructure monitoring
needs. See your data from OpsManager and
ConfigManager live in Visio diagrams.
http://www.microsoft.com/downloads/details.aspx?Fa
milyID=521b3884-1eda-4b9d-8ad767d00fe9ce8a&displaylang=en&Hash=t8clem7dZDwimL
32n1JJsW%2frz%2f2dGTAaQeI1XI0IKF1DiXbdjTA5pm4g
nKEc%2f%2foFUtJ%2fxHHUyj2Rsp6G6YUkYw%3d%3d
Start at VisioCafe
www.visio.cafe.com
Any shape can have Shape Data
Been around since 1996
Uses ODBC data sources - Read and/or Write
Single link per shape - Refresh on demand
Drag and drop shapes
Select record
Data imported
Same Master used for whole table/view
Shapes added to page
Data / Link Data to Shapes…
Right mouse menu in External Data Window
Name data columns to match Shape Data labels
Select a Master – Drag data row(s)
Select a Shape – Drag a data row onto it
Shape Data key field(s) contain values AutoLink
Basic Data Graphics usually added by default
• Right mouse menu
Either File / New /Business / PivotDiagram
Or Data / Insert PivotDiagram…
Create a new connection or use an existing one
Total Pivot Node automatically added at the
top left of page
Breakdown data into Categories
Sort
Merge
Promote
Collapse
Uses Master from any stencil to reinforce node
type
Import Cubes or Perspectives
Text
Data Bar
Icon Set
Color By Value
Text values, with optional label
Variable size depending on data value
Maximum of 5 icons per set, specify values for
icon display
Colours can be customised
Legends for Icon Sets & Color By Value
VSTO Add-in
COM Add-in
Add-ons
VBA
Full Visio
Client App
Visio Drawing
Control (ActiveX)
ShapeSheet, Smart Shapes
Visio Engine
Visio Viewer
Extensibility Support
Data Diagramming
ML
Visio Object Model (COM)
Save
As
Web
Visio
Drawings
Sample code
Tools & Wizards
ShapeStudio
Visio SDK
.NET Primary Interoperability Assemblies (PIAs)
Legends for:
External Data recordsets
Data Graphic Icon Sets
Color By Value
PLUS extra Data Graphic Callouts for:
Headings
Text Callouts
Data Bars
Icon Sets
Link Data to Shapes
Automation
Connecting
Layouts
PivotDiagrams
For companies
New Microsoft Certified Partner Specialization
Information Worker Competency
Data Visualization Specialization
https://partner.microsoft.com/40039095
For developers
New MCP Exam 70-545
Microsoft Office Visio 2007, Application Development
http://www.microsoft.com/learning/exams/70-545.mspx
Deploying Visio Solutions
Working with External Data
Developing Visio Libraries
Automating Visio Diagrams
Publishing and Viewing Visio Diagrams
Visio 2007 SDK
Visio 2007 Solution Development Workshop
http://blogs.msdn.com/visio/
Visio MVP web site
http://msdn2.microsoft.com/en-us/office/aa905478.aspx
Visio Insight blog
http://www.microsoft.com/downloads/details.aspx?FamilyID=332c211e581e-4029-9839-8f45de10b4c2&DisplayLang=en
Visio Developer Portal
http://msdn2.microsoft.com/en-us/library/ms409183.aspx
http://visio.mvps.org/
Visio IT Pro Toolbox
http://www.visiotoolbox.com
David J Parker
Microsoft MVP (Visio)
http://www.bVisual.net
Book just released
http://www.visualizinginformation.com
http://www.compman.co.uk/scripts/browse.asp?ref
=835685
[email protected]