Building Building Data Visualization Data Visualization SolutionsSolutionswithwithVisio 2007Visio 2007

Paul HoldawayPaul HoldawayMicrosoft Consulting Services (UK)Microsoft Consulting Services (UK)

AgendaAgenda

Introductions & Overview for 2007DemoDemo “Visio 2007 Features”

Data VisualizationDemoDemo “Retail Floor-plan”

API Details and Best PracticesImport DataLink Data to ShapesDisplay Data

DemoDemo “ “Retail Floor-plan extended”

Data Visualization with Data Visualization with Visio 2007 Visio 2007 - - Data FeaturesData Features

Scenario 1: Network Scenario 1: Network ManagementManagement

UPS18

productionSwitch21 Switch17

production storageSAN-acctg-1

production DBSQL-live-1

production DBSQL-live-2

production storageSAN-acctg-2

production backupBackup-live-1

production webIIS-live-1

UPS13

production backup storageBackup-acctg-1

production backup storageBackup-acctg-2

DB testingSQL-staging-2

DB testingSQL-staging-1

web testingIIS-staging-2

web testingIIS-staging-1

DB developmentSQL-dev-2

DB developmentSQL-dev-1

web developmentIIS-dev-1

web developmentIIS-dev-2

production webIIS-live-2

productionSwitch22

Scenario 2: Business ProcessScenario 2: Business Process

Scenario 3: Data Overlays

Data VisualizationData Visualization

Visualization Makes Data UnderstandableUnderstandable

Ability to Communicate Key Information Simply and RapidlyAbility to Provide Physical and Logical Contexts for Information

Visualization Makes Data ActionableActionable“At-a-Glance” View of Trends, Relationships, Exceptions, Issue-AreasIdentify Patterns and Gain Insight

“You Can See Your Data Better…You Can See Your Data Better…”

Data Visualization with Data Visualization with Visio 2007 Visio 2007 - - Retail Floor-PlanRetail Floor-Plan

Visio: Solutions PlatformVisio: Solutions Platform

Visio: Data WorkflowVisio: Data Workflow

Import Import DataData

Link DataLink Data

Display Display DataData

Refresh DataRefresh Data

Visio: Importing DataVisio: Importing DataObjects & ConceptsObjects & Concepts

DataDataSourcSourc

ee

DataConnectioDataConnectionn DataRecordsetDataRecordset

DataColumnDataColumn

DocumentDocument

DataRecordsetDataRecordset: Manages Storage / Refreshing of Data

DataColumnDataColumn: Exposes Data-type Conversion Functionality

DataConnectionDataConnection: Abstracts Connection to Data-source

Visio: Importing DataVisio: Importing DataCreating ConnectionsCreating Connections

Data SourcesSQL ServerMicrosoft Office ExcelMicrosoft Office AccessSharePoint listsXMLOther OLEDB / ODBC

Office Data Connections for Managed Connections

Import Data Link

Data Display Data

Refresh

Visio: Importing Data Visio: Importing Data Connection ModelConnection Model

ConnectedBest Practice for Most Data SourcesSimplifies Data RefreshProvides Connection String / Command String

Connection-lessUsed for XML DataProvides XML Fragment to Create & Refresh

Import Data Link

Data Display Data

Refresh

Visio: Importing Data Visio: Importing Data RefreshRefresh

Types of RefreshRefresh API MethodsAutomated Periodic RefreshEvents to Respond to User-Driven & Automated Refresh

Optionally Transacted

Import Data Link

Data Display Data

Refresh

*Link(ShapeID,rowID)

*Link(ShapeID,rowID)

*Link(ShapeID,rowID)

RowID Name Age

1 Phil 42

2 Joseph 27

3 Arida 12

Name

Age

Name

Age

Name

Age

Name Joseph

Age 27

Name Phil

Age 42

Name Arida

Age 12

RowID Name Age

1 Phil 43

2 Joseph 27

3 Arida 12

Name Joseph

Age 27

Name Phil

Age 43

Name Arida

Age 12

1 Link = 1 RowID 1 Link = 1 RowID 1 ShapeID 1 ShapeID

Visio: Link Data To ShapesVisio: Link Data To ShapesObjects & ConceptsObjects & Concepts

Import Data Link

Data Display Data

Refresh

Visio: Link Data To ShapesVisio: Link Data To Shapes Shape Data Shape Data

“Shape Data” (formerly “Custom Properties”) Behind Every Visio Shape

Data Source Fields Mapped to Individual Shape Data Items

Use Shape Data Items Built into Shapes or Automatically Create New Items

Automatic Conversion into Visio Types Import

Data LinkData Display

DataRefresh

Visio: Link Data To ShapesVisio: Link Data To ShapesLinking to Existing ShapesLinking to Existing Shapes

Link Single Row via Shape or Selection

Link Multiples via Array Better Performance Achieved

Automatically Link MultiplesBy Matching Data in Shapes & External Source(s)Using One or More Fields

Import Data Link

Data Display Data

Refresh

Visio: Link Data To ShapesVisio: Link Data To ShapesCreating New ShapesCreating New Shapes

DropLinked To Drop Specific Master Linked to a Row of D

DropManyLinkedU To Create Set of Linked Shapes

Visio Best Practice

Import Data Link

Data Display Data

Refresh

Shape Data Graphic

Graphic ItemsVisio: Displaying DataVisio: Displaying DataObjects & ConceptsObjects & Concepts

Import Data Link

Data Display Data

Refresh

Visio: Displaying DataVisio: Displaying Data

75

Label

Label Text Label Abc

Label Abc

MyProp 50

ValueValue

Icon Sets

Data Bars

Ratings

Text Callouts

Tables

Color by Value

Icon SetsIcon Sets

Data BarsData Bars

RatingsRatings

Text CalloutsText Callouts

Color by ValueColor by Value

LabelLabel

Label Label TextText Label Label ABCABC MyProp MyProp 5050

Visio: Displaying DataVisio: Displaying DataCreating Data GraphicsCreating Data Graphics

A Data Graphic is constructed from multiple Graphic Items

Data Graphics and Graphic Items are Visio Masters

Create Data Graphics and Graphic Items using Visio, then apply programmatically

Add a Data Graphic or Graphic Item to the masters collection of a document

Import Data Link

Data Display Data

Refresh

Visio: Displaying DataVisio: Displaying DataApplying Data GraphicsApplying Data Graphics

Add Data Graphic to Shapes By Setting DataGraphic Property

Add Existing Graphic Items to Data Graphics

Change Expression Used in Rules

Change Position

Import Data Link

Data Display Data

Refresh

Data Visualization with Visio Data Visualization with Visio 2007 2007 - - Retail Floor-Plan Retail Floor-Plan ContinuedContinued……

Visualization Workflow in Visualization Workflow in VisioVisioReviewReview

DataGraphicMaster

GraphicItem

GraphicItem

GraphicItem

DISPLAY shape data graphically by building & applying DataGraphics

Shape

LINK DataRecordset rows to “shape data” fields.

DataConnectionSQL AdventureWorks

Refresh

DataRecordset

IMPORT data into a DataRecordset.

DataColumn

© 2006 Microsoft Corporation. All rights reserved.This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.