Tuesday, August 27, 2013

SQL Saturday Oklahoma City - Power Map Presentation

Thanks to everyone that attended my 3D Geospatial Visualization Using Power Map session at SQL Saturday Oklahoma City 2013. I actually ended up giving the session on Friday evening and on Saturday. The Power Pivot pre-con ended an hour early on Friday, so I did a full run-through of the session to a few people from the pre-con who weren't going to be able to attend my Saturday session for various reasons. I then gave the official presentation on Saturday.

One of my favorite demos involved analyzing visitor count data of the various D.C. Smithsonian museums. I had audience members announce their favorite Smithsonian museums, and then we analyzed 2010 - 2012 visitor data. On Friday, everyone said Air and Space Museum. On Saturday I heard, Hirshorn Museum then Museum of Natural History and then finally Air and Space. We then went on to create a Power Map tour that showed another museum overtaking Air and Space in 2012.

My slides are available here.

A video of how to do the U.S. Tourist Attraction demo is available here.

A video of the Power Map tour from the Smithsonian demo is available here.

Monday, August 19, 2013

Speaking on Power Map at SQL Saturday Oklahoma City

I'm excited to see #SQLFamily and learn a ton while at SQL Saturday Oklahoma City this Saturday, August 24th. I'm also quite looking forward to a full day of Power Pivot immersion on Friday from Bill Pearson's Practical Self-Service BI with PowerPivot for Excel pre-con. You can register for the pre-con here. You can register for SQL Saturday Oklahoma City here.

I'll also be giving an updated version of my 3D Geospatial Visualization Using Power Map presentation. This new version includes a quick overview of datums, plus a high level overview of geospatial reporting in SSRS and Power View. Then we'll deep dive into Power Map. I hope to see you guys there!