My SQL and SharePoint Saturday additional content

I am presenting my view of using Visio to Visualize data with SQL Server and SharePoint today. The slideshow is available for viewing at but, whilst I wait for my turn to talk, I have created a smart prism shape to demonstrate many of the smartness of shapes and the data linking features of Visio. The file can be downloaded from .



Read the rest of this entry »

Visualising SharePoint and SQL Data with Visio Professional

I will be venturing to the dark side of the moon on Saturday 12th September 2015 at SQL Saturday in Cambridge, UK ( see ).

Read the rest of this entry »

SQL Saturday Business Intelligence Special in Edinburgh

We had a fantastic weekend in Edinburgh where I presented Visio as a BI solution for SQL professionals at SQL Saturday. I volunteered because, quite frankly, I do not think that Microsoft promote Visio for BI enough, even though they have put in the BI domain for Microsoft partner competencies. This was a community event, so many thanks to all of the sponsors for enabling it, the many volunteers for running around, and especially to Jen Stirrup for organising it ( see ).

Read the rest of this entry »

Making unused data-linked SharePoint columns in Visio invisible automatically

I described how and why I sometimes link a SharePoint document library to Visio documents in a previous article ( see I mentioned that I always switch off the visibility of some columns because they are rarely needed in my Visio shapes as shape data rows. In this article, I present a VBA macro that can switch them off for you, therefore ensuring consistency.

The Link Data to Shapes feature in Visio does not allow for filtering of columns or rows when SharePoint lists are used as a data source. One answer is to create a view of the list in SharePoint to restrict the rows and some columns, but other columns still get pulled through to the External Data recordsets in Visio by default:


Read the rest of this entry »

Displaying SharePoint Document Library Column Values on Visio Services Diagrams

It is often useful to be able to link text or graphics to the values in the SharePoint document library that a Visio diagram is stored in. A SharePoint Document library is just a list with columns and Visio 2013 documents can be linked to the data in SharePoint lists … and it will be automatically refreshable. This means that Approval Status changes, for example, can be displayed as text or icons. This article goes through the methodology of linking data from the SharePoint document library to the Visio document.

Read the rest of this entry »

Using SharePoint Choice Columns with Visio Services

Back in March 2014, I wrote about mapping SharePoint Column Types to Visio Shape Data Types ( see ), and I skipped over the remaining SharePoint column types that could not be directly mapped. I described Rich Text previously ( see ), and in this article I describe some of the possibilities of using the SharePoint Choice column type.

There are three different options for Choice columns in SharePoint 2013, but only the third, Checkboxes, allows for multiple selections.


Read the rest of this entry »

Social learning about Visio made easy

I wrote my Visio MVP Sessions Universal app ( see ) to provide access to the educational content that we did for Visio 2010. I was concerned because the links had disappeared from the Microsoft web site in favour of Visio 2013 content, but they are all together now in the social learning portal that Microsoft partners can provide now using the TidWiT portal … plus there is a lot more great content.


Simply click on to explore …



O365 and SharePoint

Simplify Tasks

Want to learn the simple way?

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

John Goldsmith's visLog

be smart, be clear, be visual ...

Mo's blog

Personal views on Dynamics 365 for Operations and Technical Architecture.

Chris Webb's BI Blog

Microsoft Power BI, Analysis Services, MDX, DAX, M, Power Pivot and Power Query

Azure Solutions for Office 365, and more...

Rob Fahrni



Life with Visio and other Microsoft Toys!

Nilsandrey's Weblog

Just another 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

Smart graphics for visual people