I am working on a project where I thought the US State flags might be useful, so I quickly created a new master shape from the images in Wikipedia. The shape simply provides a selection of one of the states from the Shape Data window (plus one extra for the reverse of Oregon’s flag!).
The flag shape has a couple of Shape Data rows:
On November 2, 2016 at 15.00 to 15.45 (GMT+2) , I will be presenting a 45 minute webinar about using Visio to create customer journeys for multiple channels, and then how to overlay with metrics to visualize the efficiency of each touch point.
Webinar Registration Page
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.
The more I use PowerQuery, the more I like it. I was able to extract the unique values in the Personas, Tags, and Products columns which each contained comma separated lists. I data-linked these values to large circles on different pages, and data-linked the Sessions to Watch to hexagonal shapes. I then wrote a little VBA code to link the circles to the hexagons with data-linked connectors. Data Graphics was applied to all shapes, including the connectors, and a legend added. Each of the Session hexagons have an automatically created hyperlink to the On-Demand Video. I used a standard radial page layout so that I had minimal manual movement shapes.
The end result is a visual dashboard by Persona, Tag and Product to open the videos for the sessions I want to watch.
Yesterday was the first proper day at MS Ignite Conference, and we had an extremely busy day on the Visio booth. There was a lot of interest in the Visio Online Preview and Visio on iPad that we had on show, and of course, the cool data linking features in Visio.
You may still be able to sign up for the Visio on iPad Insider Program using this link. It requires a short survey, and you must be part of an organization. Also, there is more information about the Visio Online Preview using this link .
Packt have kindly provided two discount codes for my book during the conference. Use ‘MVPeBK15’ for 15% off the RRP off the printed version, or ‘MVPeBK50’ for 50% off the RRP of the eBook at bit.ly/1SeVfwW
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!
I presented a Visio-based visualizer of personal schedule session locations in my last post ( Visio Sessions at MS Ignite Conference 2016 ), and in this one I present a visualization of the location of all of the sessions. Again, a Visio document download is provided that contains some macros to set the time slicer. The Visio user can set the day and time to view, and all of the sessions in each zone, that are on at that time, will be made visible. Sessions that are just finished will fade from view, and the next sessions will fade into view. All other sessions will be invisible. The Section view shows how many sessions are running in each zone at the selected time.
