Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Mastering Data Visualization with Microsoft Visio Professional 2016
Mastering Data Visualization with Microsoft Visio Professional 2016

Mastering Data Visualization with Microsoft Visio Professional 2016: Master the art of presenting information visually using Microsoft Visio Professional 2016 and Visio Pro for Office365

eBook
$9.99 $47.99
Paperback
$60.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Table of content icon View table of contents Preview book icon Preview Book

Mastering Data Visualization with Microsoft Visio Professional 2016

Chapter 2. Understanding How Data Is Stored within Visio

A Visio user may choose to create a drawing from one of the many Microsoft templates, or even from a custom one. In each case, the user sees that a Visio document can have many pages. Each page can contain many shapes. The Visio user interface normally presents many shapes on stencils that the user can drag and drop onto a page. A user may also use the drawing tools to draw rectangles, ellipses, lines, or just add text. The user may use the ribbon buttons to add containers, callouts or connectors.

Data can be stored in Visio in many ways, and the developer chooses the way according to the needs of the usage scenario. This chapter will describe the important parts of the rich Visio object model so that a power user who writes macros, or a developer who writes add-ins, will know how to navigate around the various elements. It will also describe the important sections of the programmable ShapeSheet that is behind every shape...

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:

A very quick introduction to data in Visio

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

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:

A very quick introduction to data in Visio

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...

Understanding the Visio object model

An object model defines how the various objects and collections relate to each other, and their properties, methods, and events. Knowing how to navigate around it is essential for writing quick code in VBA, or more capable code for an add-in or add-on.

Starting with the Application object

The top-level object is the Visio Application object itself. This object contains a collection of documents that are currently open.

Note

Actually, there is also the InvisibleApp object, which a developer can use to interact with a diagram without the Visio application interface appearing on the screen.

Templates, drawings, and stencils are all types of Visio documents, although the user only sees stencils on the panels of shapes on the left of the drawing page. A drawing is usually created from a template document. However, a drawing can also be created from any existing drawing.

A drawing document consists of a collection of pages, each of which can contain a collection...

Getting to grips with the ShapeSheet

Every document, page, and shape has a ShapeSheet that contains a number of sections, rows, and cells. Cells contain formulas that produce a resultant value.

The document ShapeSheet is known as the DocumentSheet in the object model, but it can be referenced as TheDoc in a cell formula. Similarly, the page ShapeSheet is known as PageSheet in the object model, but it is referred to as ThePage in cell formulas.

There are a lot of mandatory sections in the ShapeSheet, and some of them do not even have their own enumerator in visSectionIndices. Instead, they come under visSectionIndices.visSectionObject. In fact, there are 38 shown on the View Sections dialog, but with only 24 section constants:

Getting to grips with the ShapeSheet

It is more efficient to reference a cell by its SRC (Section, Row, Cell) values than by its name. However, there are times when using the name is unavoidable.

If the ShapeSheet is open in the UI, then you can easily find the name of a cell by clicking in the cell, placing...

The Visio file format

Since the 2013 edition, Visio files are Open Packaging Convention compliant, which means that most of the contents are accessible for programmers using some standard techniques. This means that package parts can be more easily extracted, and even modified, without recourse to the Visio type library. Before the 2013 version, Visio files were either binary or monolithic XML files (which were approximately 10 times the size of the binary files). Now that Visio files are zipped-up XML packages, there is greater scope for extensibility. For example, the Visio Web Access control in SharePoint 2010 used XAML to render the graphics on a layer over the top of the Visio binary file. The files had to be published as Visio Web Drawings (*.vdw) to be used, and only the linked Data Graphics content was automatically refreshable. Since the 2013 version, native Visio files are rendered in the Visio Web Access control without needing Silverlight, and any shape cell that is referenced...

Knowing how shapes relate in structured diagrams

The Insert | Diagram Parts tab in the Visio interface provides the ability to add a Container, Callout, or Connector diagram part to a page, as shown in the following screenshot (these are the main parts of a structured diagram):

Knowing how shapes relate in structured diagrams

However, there are also other shapes available from various stencils that exhibit the same behavior. There is also a special type of container called List that can contain ordered items. There are several Microsoft-supplied shapes that are lists, including the UML Class | Class master shape, which is used in the following example. This List shape accepts other specific list item shapes.

This following screenshot contains all of the elements of a structured diagram, namely connections, containers, lists, and callouts:

Knowing how shapes relate in structured diagrams

Everything but the two incoming connections at the top left of the screenshot are selected in order to limit the number of items under consideration in the following paragraphs.

Notice that the container...

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.

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...

Left arrow icon Right arrow icon
Download code icon Download Code

Key benefits

  • A complete guide to data visualization with Microsoft Visio Professional 2016
  • Visualize information to meet the needs of your business
  • Get the quick way to learn Microsoft Visio 2016

Description

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.

Who is this book for?

This book is aimed at the departmental-level business intelligence professional or Microsoft Office power-user who wants to create data diagrams with Microsoft Visio that can accurately represent business information visually.

What you will learn

  • Add external data from a variety of data sources
  • Represent information with data graphics
  • Create custom data-like shapes
  • Export data from structured diagrams
  • Present information graphics to non-Visio users
  • Automate visualizations from data
  • Develop custom templates and code for others
Estimated delivery fee Deliver to Thailand

Standard delivery 10 - 13 business days

$8.95

Premium delivery 5 - 8 business days

$45.95
(Includes tracking information)

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : May 27, 2016
Length: 334 pages
Edition : 1st
Language : English
ISBN-13 : 9781785882661
Vendor :
Microsoft
Category :

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Estimated delivery fee Deliver to Thailand

Standard delivery 10 - 13 business days

$8.95

Premium delivery 5 - 8 business days

$45.95
(Includes tracking information)

Product Details

Publication date : May 27, 2016
Length: 334 pages
Edition : 1st
Language : English
ISBN-13 : 9781785882661
Vendor :
Microsoft
Category :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total $ 187.97
Mastering Data Visualization with Microsoft Visio Professional 2016
$60.99
Microsoft Visio 2013 Business Process Diagramming and Validation
$60.99
Mastering Windows Server 2016
$65.99
Total $ 187.97 Stars icon
Banner background image

Table of Contents

12 Chapters
1. Data within Visio Essentials Chevron down icon Chevron up icon
2. Understanding How Data Is Stored within Visio Chevron down icon Chevron up icon
3. Linking Data to Shapes Chevron down icon Chevron up icon
4. Using the Built-In Data Graphics Chevron down icon Chevron up icon
5. Using the Pivot Diagram Add-On Chevron down icon Chevron up icon
6. Creating Custom Master Shapes Chevron down icon Chevron up icon
7. Creating Custom Data Graphics Chevron down icon Chevron up icon
8. Validating and Extracting Information Chevron down icon Chevron up icon
9. Automating Structured Diagrams Chevron down icon Chevron up icon
10. Sharing Data Diagrams Chevron down icon Chevron up icon
11. Choosing a Deployment Methodology Chevron down icon Chevron up icon
Index Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.2
(6 Ratings)
5 star 66.7%
4 star 16.7%
3 star 0%
2 star 0%
1 star 16.7%
Filter icon Filter
Top Reviews

Filter reviews by




Michael Krispin Sep 19, 2019
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I bought it to understand better how use Visio also in a process automation environment as HMI
Amazon Verified review Amazon
Campbell S. Rankine Jul 30, 2020
Full star icon Full star icon Full star icon Full star icon Full star icon 5
It is the most thorough treatise on Visio.
Amazon Verified review Amazon
Amazon Customer May 17, 2018
Full star icon Full star icon Full star icon Full star icon Full star icon 5
David Parker is the Guru of MS Visio, and his book is probably best source of MS Visio related knowledge you can find. Excellent book, good writting style, usable examples. Hope he'll write some new book soon.
Amazon Verified review Amazon
KE Jan 25, 2017
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Its very good book
Amazon Verified review Amazon
Amazon Customer Oct 14, 2019
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
To learn new methods for my career. As far as I can tell this is a very in-depth look at what you need to make visually appealing presentations of the contents of your data.
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is the delivery time and cost of print book? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela
What is custom duty/charge? Chevron down icon Chevron up icon

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order? Chevron down icon Chevron up icon

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges? Chevron down icon Chevron up icon

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

  • If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
  • Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.
How can I cancel my order? Chevron down icon Chevron up icon

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy? Chevron down icon Chevron up icon

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

  1. If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
  2. Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
  3. You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
  4. Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
  5. If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
  6. Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged? Chevron down icon Chevron up icon

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use? Chevron down icon Chevron up icon

You can pay with the following card types:

  1. Visa Debit
  2. Visa Credit
  3. MasterCard
  4. PayPal
What is the delivery time and cost of print books? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela