Advanced Visio Desktop: Working with Data
2h 52mIntermediate2016-11-03
Authors

Scott Helmers
Partner with the Harvard Computing Group (HCG)
Course details
Build beautiful and effective visualizations driven by external data with Microsoft Visio 2016. Visio MVP Scott Helmers offers advanced techniques for working with data in Visio diagrams.
First, learn how to apply data and display fields to shapes and run the many prebuilt reports offered in Visio 2016, as well as customize your own. Then find out how to visualize data with callouts, data bars, and icon sets; change the color of shapes as data values change; link diagrams to external data from Excel and Access; align data with flow charts, timelines, organization charts, and other Visio diagrams; and share your new data-driven diagrams with others—even if they don't have Visio. This course will help you accomplish more than you ever thought was possible with Visio, and communicate more effectively than you ever could with static data alone.
Learning objectives
Identify fields specific to the developer tab when defining the shape data.
Recall how to have Visio keep a copy of the shape on the screen while dropping it on the Stencil.
Explain how to indicate the column order when generating a custom report.
Recognize how to know each row is linked to shapes in the External Data window.
Name what the Custom Import button was called in previous versions of Visio.
Explain what Configure Refresh can be used for.
First, learn how to apply data and display fields to shapes and run the many prebuilt reports offered in Visio 2016, as well as customize your own. Then find out how to visualize data with callouts, data bars, and icon sets; change the color of shapes as data values change; link diagrams to external data from Excel and Access; align data with flow charts, timelines, organization charts, and other Visio diagrams; and share your new data-driven diagrams with others—even if they don't have Visio. This course will help you accomplish more than you ever thought was possible with Visio, and communicate more effectively than you ever could with static data alone.
Learning objectives
Identify fields specific to the developer tab when defining the shape data.
Recall how to have Visio keep a copy of the shape on the screen while dropping it on the Stencil.
Explain how to indicate the column order when generating a custom report.
Recognize how to know each row is linked to shapes in the External Data window.
Name what the Custom Import button was called in previous versions of Visio.
Explain what Configure Refresh can be used for.
Skills covered
VisioDiagrammingMicrosoft OfficeData VisualizationData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Welcome
- 02 - What you should know before watching this course
- 03 - Using the exercise files
1. Understand and Find Shape Data
- 04 - What is shape data
- 05 - Which shapes contain data Part 1
- 06 - Which shapes contain data Part 2
2. Define and Use Data Fields
- 07 - Define text and numeric fields
- 08 - Define list fields
- 09 - Define date and duration fields
- 10 - Define currency and Boolean fields
- 11 - Use advanced data attributes
- 12 - Reuse shape data fields
- 13 - Insert display fields
3. Run Reports
- 14 - Run built-in reports
- 15 - Define custom reports
- 16 - Refine custom report definitions
4. Visualize Data
- 17 - Visualize data with text callouts
- 18 - Visualize data with icon sets
- 19 - Visualize data with data bars
- 20 - Visualize data with color by value
5. Link Diagrams to Data in Excel
- 21 - Link a Process Diagram to data in Excel
- 22 - Link a Network Diagram to data in Excel
- 23 - Add Shape Data fields while linking data
- 24 - Change attributes before linking to data
- 25 - Link to a subset of available data
- 26 - Use Visio 2016 Quick Import
6. Link Diagrams to Data in SharePoint or a Database
- 27 - Link to data in a SharePoint list
- 28 - Link to data in a database
7. Manage Linked Data Sources
- 29 - Link to multiple data sources
- 30 - Link one shape to multiple data sources
- 31 - Delete or change a link to a data source
8. Create Diagrams from Data
- 32 - Build an org chart from data and photos
- 33 - Build a timeline from data in Excel
- 34 - Build a timeline from a project plan
9. Practical Uses for the Data in Your Diagrams
- 35 - Create a BI (business intelligence) dashboard from an org chart
- 36 - Visualize KPIs in a swimlane diagram
- 37 - Leverage data-driven floor plans
10. Sharing Data-Driven Diagrams
- 38 - View Visio diagrams without Visio
Conclusion
- 39 - Summary
Related courses
- Hands-On AI: Computer Vision Projects with Ultralytics and OpenCV
- Deep Learning with Python: Convolutional Neural Networks
- Hands-On AI: Image Processing with Python
- Computer Vision for Data Scientists
- Strategic Vision and Decision-Making for Senior Executives and C-Suite Leaders
- Leading with Vision
- Vision in Action: Leaders Live Case Studies
- Advanced AI: Transformers for Computer Vision
Related learn paths
- Optimizing Enterprise Security and Productivity Using Microsoft 365
- Become an Online Marketing Manager
- Prepare for the MTA: Software Development Fundamentals Exam (98-361)
- The Top Skills Project Management Professionals Have Right Now
- Advance Your Skills in User Experience Design
- Develop Your Skills in Agile Software Development
- Advance Your Skills in Graphic Design
- Prepare for the CompTIA Network+ (N10-008) Exam