Using the Bing API to geocode data in SSIS

During my talk at SQLRally Nordic Bringing maps to SQL Server I showed how to geocode data in SSIS. The way I did this was to create a custom component in SSIS. In this post I will show how this was done.   The first thing that I did was to create a new project…

4

Working with map data in Power View in Excel 2013 Preview

  One of the new options that you have in Excel 2013 and Power View is to show data on maps. This is a feature that is awaited for, most data in the BI world contains some sort of geographical information.   This could be sales territories, customer locations or production plants, etc. When I first…

8

BI data on maps in SQL Server 2012 part 2

In my previous post http://blogs.msdn.com/b/querysimon/archive/2012/06/17/bi-data-on-maps-in-sql-server-2012.aspx I described how to create a Reporting Services report that contains custom map data. One of the drawbacks with the mapping component in SSRS is that you cannot zoom interactively in your reports. One way to solve this shortcoming is to use linked reports that uses parameters to drill down…

8

BI data on maps in SQL Server 2012 part 1

I often get questions around how to show business intelligence data on maps in the Microsoft BI stack. Some people thinks that we do not support this for the entire world but only for US. I think that this misunderstanding comes from the fact that the map gallery in Reporting Services only shows data from…

2