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 »

Formatting Shape Data in Visio

One of the best aspects of Visio is the ability of shapes to hold data, and the easiest way to do this is to define rows of Shape Data. Each row can be defined as holding one of eight different types, and most of these can have their values formatted for display. In this article I discuss the formatting of these values, using either ShapeSheet functions or automation methods. The driver for this is my on-going frustration with the Microsoft provided standard Shape Data window because of its shortcomings … for example, its lack of multi-line support even though it can hold 64k characters in each row, and its lack of a time control, even though it can store dates and time.

image

Read the rest of this entry »

Power Map is looking pretty powerful!

I watched a presentation today about some of the new features of Power Map. I was impressed, and the surprising thing is that the data does not have to be location data to get a 3D visualisation. All that is needed is to establish a co-ordinate system and any data can be transformed … and it can even have a time dimension!

 

image

https://www.facebook.com/MSPowerMap

It can do some visualisations that are just not possible with Visio, but I could see that Visio could be used to feed custom maps to Power Map with base layers and a co-ordinate system.

http://blogs.msdn.com/b/powerbi/archive/2014/10/07/5-minute-tutorial-for-creating-custom-maps-with-excel-and-power-map.aspx

https://powerbi.microsoft.com

Cool custom maps : https://blogs.office.com/2014/10/08/6-cool-ways-use-custom-maps/

I will play some more with this soon….

My first Office Mix … and it’s about visViewer

As I have been using PowerPoint a fair bit recently, I noticed a template for Microsoft Office Mix. It lead me to install a free PowerPoint add-in that enables me to add optional audio and video to the presentation before uploading to the Mix website ( see https://mix.office.com/ ).

image

At first, I didn’t realise that my voice was being recorded, so I did it again … but maybe I should keep my mouth shut!

You can see my initial efforts at : https://mix.office.com/watch/1xf8jyin4s364

Microsoft Visio 2013 Themes

Visio supports Microsoft Office themes with their variants, and I have been experimenting with their affect on data graphics, so I thought I would create a document with examples of each theme applied to some data graphics. I would hesitate before using some of these, but it is interesting to see the appearance of each.

image

 

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 »

Dropping and Connecting Linked Data Shapes in Visio

I like linking data to shapes in Visio. It saves time in filling in Shape Data and adding text, or any Data Graphic to them. Basically I am lazy, and I also like to create macros for repetitive tasks, so in this blog I provide two macros to save the drudgery of two tasks I do so often:

  1. Dropping and data linking a number of items from an External Data recordset filtered by values in a column or columns
  2. Connecting shapes together following a parent-child relationship between Shape Data values

 

Read the rest of this entry »

Follow

Get every new post delivered to your Inbox.

Join 298 other followers