Today, we’re excited to announce Data Visualizer, a new Visio feature that automatically converts process map data in Excel into data-driven Visio diagrams. 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.
Automatically create process diagrams from Excel data
Diagrams don’t always start in Visio. They often begin as hand-drawn sketches or—in today’s data-driven age—in Excel. Using Data Visualizer, business analysts can represent process steps and associated metadata in a structured Excel table and quickly convert that information into a visualized Visio diagram. You can do this by either using a premade Excel template or an existing spreadsheet of your own design. The premade templates—there’s one for basic and one for cross-functional flowcharts—provide 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. You can also customize the table with your own columns to meet specific business requirements.
Once the table is populated, Visio’s wizard helps you complete the remaining steps to transform your Excel data into a Visio process diagram. If you customize the premade template or create one of your own, the wizard helps you map certain flowchart parts, like swim lanes and connectors. The resulting diagram is linked 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, analysts can save their Visio diagrams and the underlying Excel mapping table as a single package using the “Export as a Template Package” feature. These packages can be shared and reused by others, eliminating the need to recreate the same diagram from scratch while encouraging process consistency across the organization.
No matter your preference—whether creating diagrams from a template or your own spreadsheet—the underlying Excel data travels with the related Visio Pro for Office 365 file, helping ensure your team always has the latest diagram version.
For More Information on Microsoft and other Cloud Solutions, Contact Us at 800-208-4037
[/vc_column_text][/vc_column][/vc_row]
[vc_row][vc_column][vc_column_text]
Mitchells & Butlers boosts service with managed mobile platform
Mitchells & Butlers wanted to deploy iOS, Android and Windows devices that run service-enhancing apps to its staff at 1,600 establishments. Before doing so, it needed a mobile device management framework to remotely manage 15,000 devices. The company subscribed to Windows Intune, integrating this with Microsoft System Center 2012 R2. Using the devices and apps, it expects to improve customer service, increase site managers’ efficiency, and reduce costs.
Network Assessment & Technology Roadmap
To Learn More about Professional Services, contact us at 800-208-3617
Mixed Reality in Your Workplace.... Will it Boost Profits?
Augmented Reality has Hit the SoCal Business Market and it's Worth Checking Out
Try it Out On Us!
Managed Solution, your full-service Southern California technology partner, is offering a limited amount of augmented reality productivity engagements, in YOUR office*, for companies with 50 users or more.
This cutting-edge experience is funded through a partnership with Microsoft & Managed Solution and is aimed at bringing together key stakeholders from different departments in one place to experience a new reality for your business; a reality where productivity accelerates, driving profits, teamwork and culture to new places.
REQUEST AN INVITE HERE
WHAT YOU'LL LEARN:
Cutting-Edge Cross Departmental Communication Tactics with Microsoft Office365 Teams
Co-Authoring Documents and File Version Management in Office365
DIY Internal Process Automation through SharePoint & Microsoft's new FREE "Flow" Product
New & Hidden Outlook Tips and Tricks your Team Never Knew Existed
An Augmented Reality Experience with Microsoft’s HoloLens to See How Traditional Office Products and Cutting Edge Holograms Fit Into Today’s Business World
*All "in YOUR office" experiences funded by Microsoft include breakfast or lunch for your team and an insider bonus for existing or future Microsoft Licensing Purchases, Outsourced IT Engineering Services, Outsourced IT Monitoring/Help Desk Services or Backup & Disaster Recovery Plans.
[/vc_column][/vc_row]
Contact us Today!
Chat with an expert about your business’s technology needs.
