Microsoft today announced a new feature in Visio called Data Visualizer that will automatically convert process map data in Excel into data-driven Visio diagrams. Business Analysts can now visualize process steps and associated metadata in a structured Excel table as Visio diagram.
They can do this by using a premade Excel template or an existing spreadsheet of their own design. There is a basic template and then there is another template for cross-functional flowcharts providing a sample mapping table to populate with diagram metadata. The table includes predefined columns for process step number, description, dependencies, owner, function, phase and more. Users can also customize the table with their own columns to meet specific business requirements.
This new feature is available to Visio Pro for Office 365 users.
Learn more about it here.