Section 6: Data Visualizer - Build Diagrams Automatically from Excel Data
- The Data Visualizer concept and why it saves enormous time for processes with dozens of steps
- The Excel table structure required: Process Step ID, Description, Next Step ID, Connector Label and Function/Phase
- Building diagrams from Data Visualizer templates: Basic Flowchart, Cross-functional Flowchart and Audit Diagram
- Two-way sync - edit in Excel and refresh into Visio, edit in Visio and update back to Excel - and fixing common issues
- Workshop: turn an Excel step table into a cross-functional flowchart in minutes, then edit and sync back
Section 7: Data Link and Data Graphics - Make Diagrams Show Real Data
- The difference between Data Visualizer and Data Link, and connecting to Excel, SharePoint List, SQL Server and OLEDB/ODBC
- Using the External Data Window, linking data automatically and manually, and setting a unique identifier
- Data Graphics: Text Callout, Data Bar, Icon Set and Color by Value to communicate status instantly, plus building a legend
- Refreshing data and auto-refresh, plus a workshop: link an Excel equipment register to a diagram and show status with Data Graphics
Section 8: Specialized IT Diagrams and System Analysis
- Network Diagram and Rack Diagram: topology, arranging devices by U and adding IP/Hostname via Shape Data
- Cloud architecture diagrams and UML 2.5 (Use Case, Class, Sequence, Activity Diagram)
- Database Model Diagram (ERD): tables, relationships, primary/foreign keys and schema documentation
- Organization Chart from Excel employee data with the Org Chart Wizard, plus Timeline and Gantt Chart
Section 9: Scaled Drawing and Working with AutoCAD Files
- The Scaled Drawing concept, setting the drawing scale and units, and building floor plans with dimension lines
- An overview of engineering templates such as electrical diagrams, P&ID and production process diagrams
- Importing AutoCAD (DWG) files into Visio (up to DWG 2013), setting scale and placing smart shapes over the drawing
- Workshop: import a floor plan, place equipment and attach Shape Data for maintenance work
Section 10: Collaboration and Integration with Microsoft 365
- Storing files on OneDrive for Business and SharePoint Online, and using Visio for the web
- Real-time co-authoring, shape-level Comments and working with Visio files in Microsoft Teams
- Export to Word, create Slide Snippets for PowerPoint, and embed diagrams in Power BI with Visio Visual
- Security and governance: Sensitivity Label, IRM, Version History, GDPR/PDPA considerations and the Accessibility Checker
Section 11: Capstone Project and Setting a Visio Standard for the Organization
- Build a complete set of diagram documents for your own unit, choosing a task by discipline (IT: network diagram + Data Link, Process/QA: cross-functional flowchart from Data Visualizer, engineering: scaled layout plan)
- Use the standard templates and stencils built on Day 1, store on OneDrive or SharePoint and open it for teammates to comment
- Export to PDF, create a presentation with Slide Snippet and present the work together
- Guidelines for standardizing Visio in the organization: file naming, folder structure, version control and appointing a central template owner