I’ve just finished a couple of packed events on Self-Service BI with SQL and SharePoint… thank you all for attending in Jersey on Guernsey with Dan Hare and Mark Loane – thanks also to David Grady who was instrumental in the setup of our fancy new SQL 2012 demos with REAL data… no sight of Northwind, Bicycles, Picnics or Contoso.
We used a combination of our own billing system data (anonymised of course), publicly available market data from Yahoo, and some free data from the Azure Data Market. Whether that was wise or not you can be the judges…
A full house at the Pomme D’Or Hotel in St. Helier – great turn out and some good questions about combining versions of existing products with the shiny new technologies demonstrated. Apart from a minor mishap with a mouse breaking and a power cut nobody was hurt! Thanks to Cloudshare we recovered without anybody noticing… kind of…
Day 2: Guernsey
Little did we know when booking the Guernsey trip that the airport was shut for two days… Captain Mark to the rescue and a short boat trip across to St. Peter Port! Another full house at Old Government House and an excitable audience with absolutely tonnes of questions including SharePoint User Group in the Channel Islands (get involved here!). Too many others to mention.. thanks to Marc Laine for the massive build-up!
As promised you can view the slides here:
I also include screenshots from the fun demos below:
Scenario 1: Market Data using Reporting Services and SharePoint Foundation
Scenario 2: Visio Services 2010 and Performance Point Services 2010
Scenario 3: Power View – Market & Billing Data
Market Data rendered in Power View – interactive filter & X-Axis
SQL Server 2012 Enterprise or Business Intelligence, Integrated SharePoint Reporting Services
Power View Video
I also recorded a short video of the final Power View demo using Lync which has been uploaded to my SkyDrive:
If you made it this far, well done! Would be happy to chat about BI and SharePoint in general… I’ll be speaking at the International SharePoint Conference in London end of April so maybe see you there.