1 / 27

Building Data Visualization Solutions with Visio 2007

Building Data Visualization Solutions with Visio 2007. Paul Holdaway Microsoft Consulting Services (UK). Agenda. Introductions & Overview for 2007 Demo “Visio 2007 Features” Data Visualization Demo “Retail Floor-plan” API Details and Best Practices Import Data Link Data to Shapes

axel
Download Presentation

Building Data Visualization Solutions with Visio 2007

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Building Data Visualization SolutionswithVisio 2007 Paul Holdaway Microsoft Consulting Services (UK)

  2. Agenda • Introductions & Overview for 2007 • Demo“Visio 2007 Features” • Data Visualization • Demo “Retail Floor-plan” • API Details and Best Practices • Import Data • Link Data to Shapes • Display Data • Demo “Retail Floor-plan extended”

  3. Data Visualization with Visio 2007 - Data Features

  4. Scenario 1: Network Management

  5. Scenario 2: Business Process

  6. Scenario 3: Data Overlays

  7. Data Visualization • Visualization Makes Data Understandable • Ability to Communicate Key Information Simply and Rapidly • Ability to Provide Physical and Logical Contexts for Information • Visualization Makes Data Actionable • “At-a-Glance” View of Trends, Relationships, Exceptions, Issue-Areas • Identify Patterns and Gain Insight • “You Can See Your Data Better…”

  8. Data Visualization with Visio 2007 - Retail Floor-Plan

  9. Visio: Solutions Platform

  10. Visio: Data Workflow Import Data Link Data Refresh Data Display Data

  11. Data Source Visio: Importing DataObjects & Concepts DataConnection DataRecordset Document DataColumn • DataRecordset: Manages Storage / Refreshing of Data • DataColumn: Exposes Data-type Conversion Functionality • DataConnection: Abstracts Connection to Data-source

  12. Visio: Importing DataCreating Connections • Data Sources • SQL Server • Microsoft Office Excel • Microsoft Office Access • SharePoint lists • XML • Other OLEDB / ODBC • Office Data Connections for Managed Connections

  13. Visio: Importing Data Connection Model • Connected • Best Practice for Most Data Sources • Simplifies Data Refresh • Provides Connection String / Command String • Connection-less • Used for XML Data • Provides XML Fragment to Create & Refresh

  14. Visio: Importing Data Refresh • Types of Refresh • Refresh API Methods • Automated Periodic Refresh • Events to Respond to User-Driven & Automated Refresh • Optionally Transacted

  15. Visio: Link Data To ShapesObjects & Concepts 1 Link = 1 RowID  1 ShapeID

  16. Visio: Link Data To Shapes 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

  17. Visio: Link Data To ShapesLinking to Existing Shapes • Link Single Row via Shape or Selection • Link Multiples via Array • Better Performance Achieved • Automatically Link Multiples • By Matching Data in Shapes & External Source(s) • Using One or More Fields

  18. Visio: Link Data To ShapesCreating New Shapes • DropLinked • To Drop Specific Master Linked to a Row of D • DropManyLinkedU • To Create Set of Linked Shapes • Visio Best Practice

  19. Visio: Displaying DataObjects & Concepts Graphic Items Data Graphic Shape

  20. MyProp 50 Visio: Displaying Data Icon Sets Label Data Bars Ratings Color by Value Text Callouts Label Text Label ABC

  21. Visio: Displaying DataCreating 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

  22. Visio: Displaying DataApplying 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

  23. Data Visualization with Visio 2007 - Retail Floor-Plan Continued…

  24. Visualization Workflow in VisioReview

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

More Related