Book Image

Mastering Data Visualization with Microsoft Visio Professional 2016

By : John Marshall, David Parker
Book Image

Mastering Data Visualization with Microsoft Visio Professional 2016

By: John Marshall, 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.
Table of Contents (17 chapters)
Mastering Data Visualization with Microsoft Visio Professional 2016
Credits
About the Author
www.PacktPub.com
Preface
Index

A very quick introduction to importing and linking data


Visio Professional 2016 added more buttons to the Data ribbon tab along with some new Data Graphics, but the functionality has basically been the same since Visio Professional 2007. The new additions, as seen in the following screenshot, can make this particular ribbon tab quite wide on the screen. Thank goodness that wide screens have become the norm!

The process to create data-refreshable shapes in Visio consists of simply carrying out the following steps:

  1. Import data as recordsets.

  2. Link rows of data to shapes.

  3. Make the shapes display the data.

  4. Use any hyperlinks that have been created automatically.

The Quick Import tool introduced in Visio Professional 2016 attempts to merge the first three steps into one, but it rarely gets it perfectly, and it is meant only for simple Excel data sources. Therefore, it is necessary to learn how to use the Custom Import feature properly.

Knowing when to use the Quick Import tool

The Data | External Data...