Making the data in access available to everybody – just like with the Excel files in Excel services.
This enables us to manage the data stored in Access through SharePoint 2010 and use the SharePoint UI to update tables and rows.
Enables us to create a KPI for each and every level in the hierarchy.
Spatial data can be used in Report Builder 3.0 and Reporting Services 2008 onwards. The maps are based on data of type geometry in the SQL Server DB. We can show colors on the map as a sort of KPI and then drill down on the map for a detailed report of what made up those numbers. The data for the map is in one dataset and the measure for that area is in another and we can connect them through a filed in both datasets.
We can also show events on the map occurring in that area.
We can use map layers with different partitioning of the same area.
We can embed the data for the map in the report if we know in advance about a certain area that will be in use. If that area can change (a new partitioning for areas in the city), we should avoid embedding it so that the shape will be updated every time the report is opened.
We can use xmlt to connect an external data source (such as a SharePoint list data) to the data in a map.