Aliasing Data Columns for #Visio Organization Chart Wizard

One of the most frequently used components of Visio is the Organization Chart Wizard (OrgChWiz), but it is also one of the most frustrating because of its apparent inflexibility. I was recently asked how to use different table column names with the wizard because the originating ODBC source could not be touched. Well, I have previously used Access to modify and enhance tables in this situation, but the OrgChWiz is quite old, and does not like using the newer Access queries as a data source unfortunately. If the basic table column names do not match the default column names in the organization chart shapes, then there may be superfluous Shape Data rows created on each shape and the ability to change the shape style is compromised, and the Shape Data rows get quite confused!

This slideshow requires JavaScript.

Read the rest of this entry »

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 »

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 »

Data Import and Export Features in Visio 2016 (and 2013)

One of my most viewed articles is about the data import and export features in Visio 2010 (see https://blog.bvisual.net/2011/05/24/data-import-export-features-in-visio-2010/ ), so I thought that I should do something similar for Visio 2016. In fact, there is very little change since Visio 2013 …. The download file contains VBA code that I used to connect the shapes together from the data recordsets.

 

image

 

 

Read the rest of this entry »

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 https://doc.co/Q43c2m 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 http://1drv.ms/1FDAZgI .

image

 

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 http://www.sqlsaturday.com/411/EventHome.aspx ).

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 http://jenstirrup.com/2015/06/15/jens-pass-diary-sqlsaturday-edinburgh-my-heartfelt-thanks-go-to/ ).

Read the rest of this entry »

Mo's blog

Personal views on Dynamics 365 for Operations and Technical Architecture.

Chris Webb's BI Blog

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

davecra.wordpress.com/

Microsoft Office 365 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 ...