Geocaching Analytics – Part 4: GCInsight Visualizations with Power Map
Previously, we used various tools to download a copy of our Geocache data from geocaching.com and use a one-time SSIS package via the data import wizard to import that data into a SQL Server database.
Now the fun begins and we can play with some visualizations! First up, we’ll play with Microsoft’s brand new Power Map functionality for Microsoft Excel.
Power Map is part of the suite of tools which Microsoft has named the Power BI suite. The Power BI tools, such as Power Map are available in two flavors — on premise and cloud-based as part of Office 365, both of which utilize Excel 2013 Professional Plus.
One interesting note is that Microsoft is attempting to drive traffic to the Office 365 subscription flavor of Power Map over the standalone version. As such, the standalone version is technically called “Power Map Preview for Excel 2013” but the functionality is the same between both. The standalone version was originally to be time limited and stop functioning after 5/30/2014, but that limitation has since been removed.
First thing’s first — ensure that you have Power Map (or Power Map Preview) downloaded and installed. After installing, we’ll need to go into the Excel addins and enable it (as well as PowerPivot which is another tool we’ll use for managing our data)
SQL Saturday Roundup: #285 – Atlanta, GA
It’s that time of year again! This past Saturday, I had the pleasure of attending the annual SQL Saturday event here in Atlanta (well, Alpharetta, really) and, as always, it was a great time.
SQL Saturday Atlanta is always a pleasure since being local means no travel necessary (hooray) and it’s always a top-notch production. This year was no exception as the event had a great line-up of pre-cons and speakers and was very well executed.
I started off my SQL Saturday weekend by attending Teo Lachev’s (B | T) pre-con session, Deep Dive into the Microsoft BI Semantic Model (BISM). Check-in for the pre-con was a very smooth process and we were each given a giant packet of all of the printed slides for the session. Additionally, the pre-con sessions had what I’d call the best breakfast I’ve seen at a SQL Saturday event, which included a buffet of hot food items such as eggs, etc.
|Teo Lachev presenting his BISM deep dive pre-con session at SQL Saturday Atlanta
The pre-con session itself had a great turnout and Teo did an excellent job presenting a very large amount of material in the given time. All in all, it was a great day and time well spent!
Slacking on the Blog
Phew, it’s been a busy couple of months! I’ve been slacking on the blog a bit lately (as tends to be the way with these things), but I plan to get the ball rolling again pretty soon. There has been a lot going on lately — new GCInsight analytics, SQL Saturday Atlanta, and much more! Stay tuned as I get back into the routine!