2. Understanding How Data Is Stored within Visio | Mastering Data Visualization with Microsoft Visio Professional 2016

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Mastering Data Visualization with Microsoft Visio Professional 2016

By : David Parker

4.2 (6)

Mastering Data Visualization with Microsoft Visio Professional 2016

4.2 (6)

By: David Parker

Overview of this book

Microsoft Visio Professional is a data visualization application that is used by many different market sectors and many different departments to represent information visually, from network infrastructure to organization charts, from process diagrams to office layouts. Starting off with a brief introduction to Visio Professional 2016 and then moving on to data storage, linking data to shapes, and working with SQL Server to create a solid foundation. Then we’ll cover topics such as refreshing data, working with geographical data, working with various graphics, and diagrams, and more. Finally, you’ll find out how to deploy custom stencils, templates, and code.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Data within Visio Essentials

1. Data within Visio Essentials

Why use Visio for data diagramming?

The evolution of data in Visio before the Microsoft acquisition

The evolution of data in Microsoft Visio

Other significant current add-ons that use data

Sadly missed add-ons that used data

Summary

2. Understanding How Data Is Stored within Visio

2. Understanding How Data Is Stored within Visio

A very quick introduction to data in Visio

Understanding the Visio object model

Getting to grips with the ShapeSheet

The Visio file format

Knowing how shapes relate in structured diagrams

Summary

3. Linking Data to Shapes

3. Linking Data to Shapes

A very quick introduction to importing and linking data

Creating data links to the shapes

Summary

4. Using the Built-In Data Graphics

4. Using the Built-In Data Graphics

Displaying data with graphics

Understanding the Graphic Item types

Adding a legend

Analyzing the composition of a Data Graphic

Summary

5. Using the Pivot Diagram Add-On

5. Using the Pivot Diagram Add-On

Choosing a data source

Configuring the default Data Graphics

Breaking down by category

Applying shapes to enhance legibility

Configuring the PivotDiagram options

Laying the nodes out

Overlaying linked data

Summary

6. Creating Custom Master Shapes

6. Creating Custom Master Shapes

Modifying the ribbon

Preparing shapes for data linking

Making graphics respond to data value changes

Sharing custom Templates, Stencils, and Masters

Summary

7. Creating Custom Data Graphics

7. Creating Custom Data Graphics

Understanding the structure of graphic item Masters

Modifying graphic items

Summary

8. Validating and Extracting Information

8. Validating and Extracting Information

Introducing validation rules

Getting information from data diagrams

Summary

9. Automating Structured Diagrams

9. Automating Structured Diagrams

Structuring diagrams overview

Selecting a Master shape to drop

Dropping and linking shapes to data

Connecting shapes from data

Adding data-linked shapes to containers

Adding data-linked shapes to lists

Adding Callouts to shapes

Summary

10. Sharing Data Diagrams

10. Sharing Data Diagrams

Thinking about sharing

Viewing Visio documents without Visio

Sharing a Visio document

Exporting a Visio document

Summary

11. Choosing a Deployment Methodology

11. Choosing a Deployment Methodology

Sharing custom stencils

Sharing custom templates

Sharing custom code

Summary

Index

Index

A very quick introduction to data in Visio

There are many templates and tools within Visio that either import or export data.

The following diagram shows the various data sources or targets listed vertically in the center. The Visio features that can import data are on the left-hand side, and the features that export are on the right. There are many features that use data, but the most relevant features and data sources are enhanced with a thicker outline:

I have omitted SharePoint workflows from this diagram because it is so specialized.

Note

Visit http://blog.bvisual.net/2015/11/16/data-import-and-export-features-in-visio-2016-and-2013/ for more information about this diagram.

Most of these features utilize the Shape Data capability of Visio shapes, pages, and documents. The following table lists the Visio features that import values into Shape Data rows:

Note

SQL Server stored procedures can also be used as a data source in code in addition to the tables and views that are accessible from the...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Mastering Data Visualization with Microsoft Visio Professional 2016

Search

Your notes and bookmarks