Showing posts with label Datalinked. Show all posts
Showing posts with label Datalinked. Show all posts

Saturday, July 13, 2013

Data-linked diagrams: Multiple data graphics with a single shape

AppId is over the quota
AppId is over the quota

Yana Terukhova is a Product Marketing Manager on the Microsoft Visio team.

Visio makes it easy to build visually compelling organization charts and enhance them to meet your specific business needs. You can create a data-linked diagram connected to your organization’s key business indicators and then make sure your information is always current by linking it from an external source. Then you can display the information with data graphics. You can bring even more business insight into your diagram by showing multiple data graphics with a single shape.

Shapes can be associated with a single data point—for example, the percent of budget spent by employee—but you can also create diagrams where each shape shows multiple data points, such as the number of employees in each department, sales attainment for employees in revenue-generating roles or other metrics that are important in your organization.

There are a few different ways to do this, but the most simple is to add multiple data elements to a single data graphic. For example, if we wanted to show the number of employees in each department on our organization chart, we could edit our existing data graphic and add a text call out under the main shape.

Visio allows you to specify where you’d like data graphics to show up on shapes--just uncheck the Use default position box and select a position that is better suited to what you are hoping to achieve.  In this case, we chose the Center, Below Shape position.

If you want to change the fill of the data graphic, select that element and change the fill as you would for any other shape.

With our organization chart we can create a diagram that represents multiple dimensions of data in an easy-to-follow format. The first thing to think about is whether the Coin diagram type is the best way of representing data. In situations where I’m showing multiple data graphics per person, I like to use shapes that are open. In this case, I’ll switch to the Bound style. (Go to the Org Chart tab to select the shape style that best fits your needs.)

You may need to use the height and width controls to make the shapes large enough hold the data graphics you’d like. Once you have the shapes looking the way you’d like, you can use the layout controls to adjust spacing between shapes.

Considering the amount and variety of information we want to display on this diagram, and that the data graphics are usually very visual and colorful, we can switch to Simple design for the diagram itself. (Go to the Design tab to select the design style that best fits your needs.) This way we can read our business-intelligent diagram most effectively.

Using Ashima as an example, you can see we added three additional shapes to the organization chart, grouped them, and applied data graphics to them:

Note that not every data graphic needs to be applied to every shape. In the organization chart example, only some employees produce revenue, so they have sales metrics attached to their names, while other employees do not.

Here is our final dynamic data-linked diagram:

Use Visio Services to share your diagram with others and make it available to everyone, from nearly any device.

–Yana Terukhova, Product Marketing Manager


View the original article here

Saturday, May 11, 2013

Data-linked diagrams: Linking data from an external data source

AppId is over the quota
AppId is over the quota

Yana Terukhova is a Product Marketing Manager on the Microsoft Visio team.

Visually displaying always up-to-date information on clearly laid out diagrams helps to communicate information effectively. In this post, we will see how to connect data from external sources to a diagram.

Linking data to Visio diagrams was first introduced in 2007 and has been overwhelmingly popular. We’ve improved the functionality since then and the capability has become increasingly more powerful. Associating data with shapes on a diagram does not require any code. There’s a simple wizard which guides you through linking your data source to your diagram. Once you’ve linked data to diagram shapes, apply data graphics to shapes--text, data bars, icons, or color by value conditional formatting--to visually display numerical data. The important point here is that data-linked diagrams are dynamic; the data graphics change when data is refreshed in the source (like Excel). 

To get started, we created a simple organization chart in Visio. We’ve chosen the coin layout for this example. Once we have added the data, we can change the layout to better match the data format. As you can see, we have name, title, and photos for each of the members in our organization.

You can imagine that all types of data that be visualized--from vacation status/training completion, to number of documents in a particular step in a process, and to percent budget attained. Options are vast.

Before you add any data to a diagram, it is a good idea to decide exactly what data you want to see, because this will define which data visualization format best fits your needs.

A common task in organizations of all sizes is to track budget and spending, either by department or at the budget owner level. Let’s see how we can use Visio to show how each person is doing against their budget.

In this example, we will display revenue attainment, budget, and number of employees reporting to certain people. Here is the current view of our data in Excel.

Using this file as the data source, you could also link it directly to real-time budget information in a back office system (such as Microsoft Dynamics and other data sources).

It is important to remember that your data needs to be consistently arranged in the source, so Visio can understand all the logic behind it. For example, keep rows filled with consistent data and name all the columns in a consistent manner. Very often, when data is not displaying appropriately in a Visio data-linked diagram, there is a problem with how this data was originally organized in the source.

There are two steps to link data in Visio:

Import the data source into Visio. This creates the link between your Visio file and the data source, but does not link any of the shapes to that data.

Now we can see that the Excel and Visio files are linked together.

Link shapes to data. Once the data is associated with your diagram, you can associate individual rows in the data with shapes on the page (a single row may be associated with multiple shapes, such as visualizing multiple dimensions of data). Data can be associated by dragging individual rows from the shape data window or by automatically linking (if you have columns that correspond to shape data elements).

We linked automatically in this example, and Visio quickly associated all the shapes by unique names of each person in the chart.

You may be surprised by the result--there are text links to the right of the shapes. This is the default data graphic as text. Now we can change and add data graphics to the diagram to make it look exactly as we want it.

--Yana Terukhova, Product Marketing Manager


View the original article here

Data-linked diagrams: Creating a diagram

AppId is over the quota
AppId is over the quota

Yana Terukhova is a Product Marketing Manager on the Microsoft Visio team.

Visio offers over 60 types of professional templates to build compelling diagrams, and organization charts are among most the frequently created. Visio organization charts are simple and visual, but what if you want to connect them to key business indicators tracked by your organization, such as sales by region, budget by department, vacation status, or training progress? Sometimes this information is located in another source, like Excel or  a complex database. Data-linked diagrams let you add data to Visio diagrams--no code required--and anyone in an organization can quickly create such dashboards to get better insights into data using Visio Professional 2013 or Visio Pro for Office 365.

We’ll start with an organization chart diagram like this one.

The data you add to the organization diagram can be in an Excel file, populated from Exchange/Active Directory, or constructed manually by dragging shapes on a page.

Tip: if you pull data from Active Directory or Exchange, you must have Outlook installed and configured with an active profile--the requirement is a MAPI connection. Visio uses MAPI to get data, so if you don’t have one, the data import will fail.

In this example, the Excel file has three columns: Name, Title and Reports To. Visio uses this information to determine how to organize the reporting relationships in your organization chart.

From the Visio start screen, select or search for Organization Chart.

Once the wizard starts, select Information that’s already stored in a file or database. Then you can tell Visio what columns have your hierarchy information and where to import pictures from, if you have them.

 You can specify a folder with your pictures, and as long as there is a field that Visio can match to (such as Name). Visio will automatically associate them with the correct organization chart shape.

Once you’re finished, you’ll have an organization chart that looks like this:

Now you can click the Org Chart tab on the ribbon and make changes to reflect what you’re looking for, including spacing and other variants.

In this case, we used the Coin design to add a splash of color:

Although this example focuses on mapping departments of people, you can use the Organization Chart Wizard to map all sorts of hierarchical data--a website map, for example--as long as you can clearly format that data in Excel.

–Yana Terukhova, Product Marketing Manager


View the original article here