Data Visualizer for #Visio Pro for Office 365 – Part 2

I walked though the steps to create a Cross-Functional flowchart automatically from an Excel table in my last article ( Data Visualizer for #Visio Pro for Office 365 – Part 1 ), but I often prefer to use a relational data source, such as Access or SQL Server, to store and organise my data. Therefore, I describe how Excel‘s Get Data (nee PowerQuery) can be used to merge together the data in a relational data source as a single table suitable for Data Visualizer in Visio Pro for Office 365.

This slideshow requires JavaScript.

Read the rest of this entry »

Data Visualizer for #Visio Pro for Office 365 – Part 1

Microsoft have just released Data Visualizer for Viso Pro for Office 365! This great new feature provides you with the ability to create diagrams from an Excel table automatically. It currently comes with two new templates for creating Basic or Cross-Functional flowcharts, but the feature can be used for many other different types of diagrams.

This slideshow requires JavaScript.

Read the rest of this entry »

Visio @ASPC Update

My stint at the Artic SharePoint Challenge is nearly over …. I will be leaving the mountains near Oslo for the UK in a couple of hours, but the teams will continue with their SharePoint and CRM coding for another day. Such dedication! Still, I can always go out side to cool down, and contemplate:

wp_20170202_14_39_10_pro

In the meantime, I have enjoyed spreading the knowledge of data-linked Visio diagrams in SharePoint Online to a bunch of geeks who know so much more than me about SharePoint!

I hope they now know more about the capabilities of Visio….

Anyhow, here are some Theta360 shots from the hackathon:

ASPC Presentation #theta360uk

Artic SharePoint Challenge Judges #theta360uk

Artic SharePoint Challengers #theta360uk

Contemplating the Artic SharePoint Challenge… #theta360uk

I set a challenge to create a data linked Visio diagram in SharePoint for people popping red or blue pills ….

2017-02-03_15-39-12

Each of the pills are an instance of a single Master, and are linked to two recordsets using Excel Services that provide the personnel data (and hyperlinks) and the pill colour they chose. The position and rotation of each pill is from a random ratio in the Excel worksheet. All of these details, position and rotation are automatically refreshed in the Visio diagram if the Excel workbooks are updated.

Next week, I will talk more about the content 🙂

 

 

Reverse Engineering SQL Server DBs with Visio Pro DBRE

The news is out: due to popular demand DBRE (Database Reverse Engineering) is [almost] back in Visio. It is currently out in preview, as announced in MS Power User , for Visio Pro for Office365 users at least. It is, however, only providing support for MS SQL Server and Oracle Server, although there is an ODBC Generic Driver too.

My test machine is a Surface Pro 1, which does not have SQL Server installed, so my instinct was to test DBRE with a SQL Azure database that I created for my eXplore Visio app  ( see Windows Store ).

This slideshow requires JavaScript.

Read the rest of this entry »

Visio is coming to the web and iOS – Dec. 2016

Microsoft blogged the launch of Visio for iPad and Visio Online Preview yesterday ( see blogs.office.com ). This should be welcome news to every Visio user who wants to increase the consumption of their carefully crafted diagrams. These two new ways of viewing Visio documents (for free) have different capabilities, so I have put some slides together that describe the current differences. Coincidently, Microsoft also announced the upcoming Windows 10 on ARM processors ( see Windows Central ), so the ability to create Visio diagrams is going to be possible on mobile devices too!

This slideshow requires JavaScript.

Read the rest of this entry »

#MSIgnite Sessions to Watch in #Visio

Well, MS Ignite is over for another year. I planned to visit loads of sessions, but the reality was that I spent many hours on the Visio booth. Fortunately, many of them were recorded, including ours, but I don’t have time to watch over 700 videos! So, I looked through them all and picked out 50-odd, and used Get & Transform in Excel again to create suitable queries to link to Visio.

Sessions2Watch.gif

Read the rest of this entry »

Linking an Access Web Database to Visio

There is a great video on Channel 9 about Access Web Apps, and how to link to them on the desktop ( see https://channel9.msdn.com/events/MVP-Virtual-Conference/MVP-Virtual-Conference-Americas-2015/CONS2-Using-Access-and-SharePoint-for-Travel-Expenses-and-Pulling-up-Maps). However, they never mentioned linking to Visio, so I thought I would correct that omission. I had previously tried to use Link Data to Shapes with an Access Web database, but failed, however watching this video encouraged me to try again!

Read the rest of this entry »

davecra.wordpress.com/

Microsoft Office Development, and more...

PowerShell.Amsterdam

Automate, Accelerate, Accurate

johnvisiomvp

Life with Visio and other Microsoft Toys!

Title (Required)

Windows Server Essentials Tips & Tricks

Nilsandrey's Weblog

Just another WordPress.com weblog

Things that Should be Easy

Every so often (too often in the IT industry) I encounter things that should have been very easy to do but turned out to be far too complicated. My favorite topics include SharePoint, .Net development, and software architecture, especially distributed systems.

Visio Guy

Shapes, Stencils, Drawings Templates, Tutorials, Tips & Developer Info for Microsoft Visio

Hannes's Virtual Earth

Tips & Tricks around Mapping and Cloud Computing

Pluralsight blog

be smart, be clear, be visual ...