Shark Week Special: Mapping Shark Attacks (Drillable Maps and Hyperlinks)

This has turned out to be an epic weekend.  The Summer Games are wrapping up, NFL preseason football has started, and what did I happen catch this evening after coming inside from the 85 degree heat wave here in Seattle?  That’s right, Shark Week has kicked off over on the Discovery Channel.  If there is…

3

Visualizing the Olympics with Power View in Excel 2013 Day 4: Office 365

  Welcome to Day 4 of this series on Visualizing the Olympics with Power View in Excel 2013. In yesterday’s post we looked at how you can add embedded images to the PowerPivot model that is present in Excel whenever you are using Power View content.  Worth noting on its own, The PowerPivot in-memory engine…

3

Visualizing the Olympics with Power View in Excel 2013 Day 3: Adding Images with Power Pivot

Welcome to Day 3 of our effort to visualize the Olympics using Power View in Excel.  In yesterday’s post, we looked at Tiles, pie charts in maps, and dabbled a bit in the filter pane.  Today, we are going to introduce the PowerPivot add-in and one of the features of the modeling experience in PowerPivot…

5

Visualizing the Olympics with Power View in Excel 2013: Day 2

Welcome to Day 2 of our effort to visualize the Olympics using Power View in Excel 2013.  In yesterday’s post we started with a simple table of data in Excel and turned it into a map displaying the number of participants in the Olympics by country.  While the accompanying video is about two minutes long,…

0

Visualizing the Olympics with Power View in Excel 2013: Day 1

With the Olympics kicking off over the weekend, I thought it would be fun to run a series of blog posts on how you can visualize data from the Olympics using the Excel 2013 Consumer Preview and Power View.   The approach of this project is simple.  Each day, for as long as the Olympics are…

1

Project “Crescent” Demo: Introduction to Highlighting

With the release of SQL Server “Denali” CTP3, we are introducing Project “Crescent”.  Project Crescent is Reporting Services’ new reporting tool targeted at data consumers to visually explore their data and answer ad-hoc questions with ease.  There is lots to cover with Project Crescent and over the next months you are going to see a…

2

Map Gallery on Codeplex for your SSRS 2008 R2 Reports

If you are using maps in SSRS 2008 R2, you might be aware that the Map Wizard only provides U.S. based maps.  However, it is totally possible to add more maps to the gallery.  Head on over to http://mapgallery.codeplex.com/ where a community project has started up to provide maps for other locations.  The site also includes links…

3

Maps: You’re Missing the Point(s)!

While the map in SSRS 2008 R2 supports different data sources for spatial data (ESRI shape files, SQL Server spatial, and included maps in the Map Gallery), sometimes that may not be enough for your needs.  Another way you can get spatial data into the map is to add it to the map directly in…

4

SSRS 2008 R2 Data Visualization Examples

Today, the Reporting Services team gave a series of presentations at an all day “airlift” event.  Here are the reports and database backup for the demo I gave.  In future posts, I will  walk through building this report.  Thank you for attending the event today!

2