Access and Visio Services and Spatial Data in SharePoint 2010

June 27, 2012

I have recently finished MOC 50429 SharePoint 2010 Business Intelligence with Lior Cohen Amikam which I found very enlightening. I thought I’d share with you some of the excerpts from my summaries throughout the course. It’s a mix of ideas of what to do with SharePoint BI abilities and a short description of what they are. This is the fifth post in a series of posts that I am making from the material of the course:

Access Services

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.


Visio Services

Enables us to create a KPI for each and every level in the hierarchy.
A hierarchy could be for instance an organizational hierarchy, a product line tree etc. etc.
Let’s assume this is a diagram in Visio of an organizational hierarchy
Each circle stands for a unit in the organization
We can give each of the circles a color, making it a KPI
We can also decide that the thickness of the line
connecting the circles will have a meaning according to
how much that unit contributed to its parent unit .
We can give a thicker line with a percentage next to it.
We can also see to it that clicking on each circle will land us
in a detail report of that unit’s sales



Spatial Data

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.

Add comment
facebook linkedin twitter email

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>