With Data Visualizer Automatically Create Process Diagrams from Excel Data

This update, which is available to Visio Pro for Office 365 users, helps reduce manual steps while giving business analysts even more ways to create process diagrams in Visio.

Share online:

Data Visualizer, a new Visio feature, helps reduce manual steps while giving business analysts and other users even more ways to automatically create process diagrams is available as on Monday.

The new feature release to Visio Pro for Office 365 users, automatically converts process map data in Excel into data-driven Visio diagrams.

Data Visualizer enables users to represent process steps and associated metadata in a structured Excel table and quickly convert that information into a Visio diagram — either by using a premade Excel template or a spreadsheet of their own.

Data Visualizer for Visio Pro

The premade templates are availabe for basic and cross-functional flowcharts—and includes predefined columns for process step number, description, dependencies, owner, function, phase and more. Once a table is populated, you can complete all reamining steps using Visio's wizard to transform Excel data into a Visio process diagram.

If you customize this table with own columns or create one of your own, "the wizard helps you map certain flowchart parts, like swim lanes and connectors," wrties Office team. "The resulting diagram then links to the Excel table, so if the underlying process data is modified, the diagram updates accordingly. "

Likewise, shape modifications in Visio are preserved if the Excel data changes.

Additionally, using "Export as a Template Package" feature, analysts can save their Visio diagrams and underlying Excel mapping table as a single package. And, then these packages can be shared and reused by others.

Microsoft Teams gets big updates on iOS, and Windows 10 Mobile as part of April update. Teams for Office 365 subscribers is arlready avaialble now in 181 countries. The new features to the app on these platforms includes the following enhancements on iOS:

  • Connect face to face using immersive video calls
  • Tailored user experience for iPad
  • Easily add or remove team members
  • Create new channels
  • Rename group chats and add new members to existing chats
  • Improved image viewer lets you zoom and pan easily
  • Improved support for previewing files in conversations

Meanwhile, Windows 10 Mobile version received following changes:

  • Single sign-in with other Office 365 apps
  • You can now @mention teams and channels
  • You can open emails sent to a channel
  • Improved mobile support for Connector messages
  • Support for certificate based authentication
  • Support for mobile device management
  • Ability to un/follow channel from creation menu

In a new animated video series dubbed 'Explanimators,' from Microsoft Story Labs, is providing an easy guide to learn everything about Artificial intelligence (AI).

This new series is about big, important, cutting-edge areas of technology that remain mysterious (if not just plain confusing) to people who don't have an engineering or computer science degree.

While artificial intelligence is increasingly all around us, helping people do more, save time and work smarter – let's be honest – it's tricky to wrap your head around how it works and where it's headed.

For a simple-to-understand guide to the world of AI, check out the first episode above and stay tuned for more animated adventures in technology coming soon from Story Labs.