Read about Business Intelligence in Microsoft SQL Server 2012, Power View, PowerPivot 2, and BISM (BI Semantic Model).
Spatial reports can be created using Report Builder, which comes with SQL Server. They execute in SQL Server Reporting Services (SSRS) and they can be hosted in SharePoint Server. This video shows the steps you need to take to create a simple bubble report that displays customer numbers, taken from a cube, on a map of the United States. You will also see how to share that report with co-workers using SharePoint.
Power View, part of SQL Server 2012 Reporting Services, and the BI Semantic Model (BISM) are introduced in this video. The demo also shows how to create the animated bubble chart (scatter plot) from your data.