Updates to #MSIgnite #Visio Session Documents

I will be leaving soon for Atlanta to the MS Ignite Conference, but first I checked the latest schedule and found some additions and some slight title changes, so I have updated the documents provided in my last two posts:

MS Ignite Conference 2016 Sessions in Visio

Visio Sessions at MS Ignite Conference 2016

Also, I have produced a short, silent video of the process to import your own Ignite Trip Report.docx from the MS Ignite website to Visio.

See you in Atlanta!

 

Visio Sessions at MS Ignite Conference 2016

I will be a co-presenter at the Microsoft Ignite Conference on 28th Sept. 2016 ( see Dive deep into advanced Data Visualization with Visio ) along with my fellow MVPs Scott Helmers and Ed Richard, and led by Sandeep Srivastava, from Microsoft. I am really looking forward to it because it will be a great opportunity to learn more about all of the exciting developments happening at Microsoft nowadays. Of course, I will also be showing off what we can do in Visio too, and to that end I have created a session location finder in Visio.

The MS Ignite Conference is an enormous 5 day event, with over 1300 sessions spread over three buildings and 5 floors. The conference website provides the opportunity to build your personal schedule, and to download a Word trip report. Unfortunately, this report does not include the rooms and the zone or building that they are in. Therefore, I used some of my facilities management experience and Visio to provide a multipage Visio document with building section and plans provide the location context for each session in my, or attendees, schedule.

Section TImer.gif

Read the rest of this entry »

Visio for FM Session Recordings

Today I demonstrated how Visio could be used for Facilities Management. I covered CAD integration, space chargeback, personnel and asset locations, and finished off with fire escape routes and equip.

You can register for see the recording, and get the pdf of the slide deck, at https://vts.inxpo.com/Launch/QReg.htm?ShowKey=27721 .

I have made some of the materials available from my OneDrive – Sample CAD file, Excel data and Visio Drawing : https://1drv.ms/f/s!AqkzN8kb1lAzlspZ6XOX4d-sI4royw

A screenshot of the Visio drawing

image

 

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 »

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 »

Distributing Data Points Automatically on Maps in Visio

In my last article, I described how to calibrate a map in Visio ( see https://blog.bvisual.net/2015/05/26/calibrating-a-map-in-visio/ ), and in this article I use a calibrated map to distribute data points from a linked data source automatically.

For this example, I drew a simple shape at the size that I want, but you could add this smartness to any shape. All you need is an external data recordset that contains the Latitude and Longitude values that need to be linked to each data point.

image

Read the rest of this entry »

Linking Data to Visio with SQL Server Stored Procedures

Visio Professional has the ability to link to various data sources, and one of the most popular is SQL Server. The DATA\Link Data to Shapes … function will present a UI to choose from a table or view, but does not provide any stored procedures. Therefore, this article present a VBA macro that demonstrates how a stored procedure can be added as a refreshable data recordset in Visio.

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 ...