I was tidying up my office recently, and came across an old magazine cover that I was on back in 1992. In those days, I was a consultant for a company called Isicad, and I am working on a £30,000+ Unix workstation. I have a small monitor for the Unify database on the left, and a large CRT monitor the CAD system, and a tablet with a stylus for interaction with the drawing. I also had more hair than I do now, which probably started going when I turned up to do some demos in Milan on a workstation that was supplied by the German arm of the company … only they didn’t leave a built one … just loads of boxes with parts, and that also included the circuit boards! I had to build it afresh whilst being instructed over the phone, and with my foot firmly hooked around the radiator because I didn’t have an earthing strap! Well, that picture started me thinking about my current workstation, which is a £3,000 Microsoft Surface Book 2, and how I have to connect to video displays nowadays!
I have been through many Windows Servers, PCs and laptops since 1992, but I think I had my first real desire for a particular model when I was over in Redmond for a conference and tried the Surface Book 2. I wanted one, but I had to wait for it to become available in the UK months later, and then a further few months because I wanted the 15″ screen with a Performance Base. I convinced myself that I needed that particular specification because of my continuous use of graphics, particularly with Visio. I was probably correct about that, but I honestly don’t detach the screen very much at all. So, I have the Surface Pen for freehand work on the screen, which I do use now and then, and the Surface Dial, which I only use for scrolling web pages and the audio volume. Maybe one day I can use it Visio… I also have a Microsoft Designer Bluetooth Mouse, which I like because I am allergic to the rubber wheels on most mice, but this one has hard plastic.
The Surface Book 2 is supplied with a power adaptor that has another USB-A port to add to the two USB-A ports on the left, and one USB-C on the right of the base. Well, I couldn’t connect to any external monitor or to a wired ethernet cable, so I forked out for a Surface Dock, which is a monster with a power adaptor and a separate hub with 4 USB-3.0 ports, 2 Mini Display Ports, 1 audio out, and 1 Gigabit ethernet port. I have been stopped several times at the airport with this unit because it looks very suspicious to the border officers when it goes through the X-ray!
So, if I am traveling and want to connect directly to an external monitor, I have two choices. I can take the Surface Dock, a Mini DisplayPort to HDMI, and an HDMI cable, or I can take the Surface power adaptor and a USB-C to HDMI cable that I bought from Uni Accessories via Amazon! You can see the difference below, and I can feel it in my laptop bag too!
Microsoft
MSIgnite Sessions to Watch in Visio
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.