Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
Advanced Visio Desktop: Working with Data

Advanced Visio Desktop: Working with Data

2h 52mIntermediate2016-11-03

Authors

Scott Helmers

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.

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

Related learn paths

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
zarinpal
zibal