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 in Visual Studio 2012. The type...

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...

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...

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...