Creating diagrams in Visio is fairly easy, but do you stop when you have a collection of shapes on the page? If you do, you’re missing most of the real power of Visio. While it’s true that a picture can be worth a thousand words, with Visio, you can take that picture to the next level and make it even more valuable.
In this article you’ll discover techniques that allow you to visualize process data on your maps, and you’ll also learn that you can connect a diagram to data and turn the diagram into a business intelligence dashboard.
Creating the Best Practice View of a Process
Let’s say you’ve created a flowchart of a business process. The diagram represents the “best practice” view of that process. Perhaps a portion of the flowchart looks like this:
People in your organization can use the flowchart to get a sense for how to do their work within the overall process, but how do they know where to go for more information? Or what tools they should use to perform each task? Or who to consult if they need assistance?
Visio makes it really simple to provide all of that information as part of the flowchart. Before we look at an example, we need to define two key Visio features.
Every Visio shape can contain data. Some Visio shapes include predefined data fields, such as the flowchart shapes that incorporate fields for Cost, Process Number, Owner, Function, Start Date, End Date, and Status. Even if a shape doesn’t have predefined fields, you can add your own fields to store data of interest to you.
For example, here is a task shape to which we’ve added data fields:
TIP: You need to open Visio’s Shape Data window to see the data in a shape. To do so, right-click any shape, select Data, and then Shape Data. You can position the resulting window anywhere over the drawing or dock it on any of the four sides of the Visio window.
A Visio data graphic lets you visualize the data in your shapes in one of four ways: You can display data in text callouts, progress bars and graphs, using colored icons, or by automatically applying a color to a shape. Data graphics are dynamic, so as the data in a shape changes, the data graphic responds accordingly.
In the example below, we’ve added two text callouts, one at the top to identify who is responsible for each task, and one below to indicate where someone should look for more information about doing each piece of work.
We can continue to display additional key attributes in a similar fashion. In the following figure, we’ve added the tools for completing each task, and, where appropriate, we’ve identified the person to whom someone might turn for assistance.
Using Process Maps to Monitor Process Execution
Creating a map to depict the best practice view of a process is a great start. What if we could use the same process map to manage individual instances of a process by viewing up-to-the-minute data in the context of the map?
With the data linking feature of Visio, you can. The data connection wizard lets you link a diagram to one or more external data sources. You can connect to data in Excel, in a SharePoint list, in Access, in SQL Server, or in virtually any database anywhere. It’s even possible to link to both Task Lists and Enterprise Projects in Microsoft Project Online.
When you link to a data source, Visio does two things. First, when column names in the data source match existing shape data field names, Visio adds the data values to those fields. Second, if there are columns names that do not match, like the orange ones below, Visio creates new shape data fields and inserts the values into the shapes.
As an example, linking the process map above to data like the Excel worksheet shown below allows us to visualize key performance indicators (KPIs) along with other data values.
Now that we have KPI data in the map, let’s leverage it by creating two additional data graphics. We’ll use an icon set to display actual time vs. budgeted time for each task, and we’ll create a color-by-value graphic to show the status of each task. The results are shown below for three tasks.
If you want to make the resulting diagram more meaningful for its intended audience, two clicks instruct Visio to generate a legend showing the significance of each data graphic icon or color.
In this article, you’ve seen how Visio can help you move far beyond creating simple flowcharts and swimlane diagrams.
- You can display critical data values on a map, thereby positioning the diagram as the focal point of learning and knowledge about the process.
- When you link a process map to data and then visualize KPIs on the map, you gain operational intelligence because you can monitor and manage individual process instances in the context of the original map.
To learn more about the techniques and Visio features described in this article, in my webinar, Visio Basics for Project Managers, now available on-demand.