Reporting Services Integration in SharePoint 2 of 6

Yesterday we looked at accessing data directly from within SharePoint using the very powerful tool Reporting Services. At the top of the pyramid of data we had senior leaders (and indeed all members of staff) being able to quickly pull up Headline data shown in the table below.

The next stage for senior or middle leaders when results are in is to look at department level data to see how each department has performed. In the table above the top right corner contains the word GCSE. By clicking on this link a stage down in the pyramid appears- the department level analysis.

All subject analysis- click to enlarge

All subject analysis- click to enlarge

From here senior and middle leaders can look at the overall performance of departments across the A*-U range as well as the key indicators A*-A and A*-C. They can also see residuals which are then nationally adjusted on the far right to give a true reflection of relative performance. From here you can drill directly into individual classes to look at performance across a single department. This is something I will cover tomorrow.

If you enjoyed this post, make sure you subscribe to my RSS feed!
  • Share/Bookmark

Related posts:

  1. Reporting Services Integration in SharePoint 3 of 6 So far in this series we have being looking at...
  2. Reporting Services integration in SharePoint 1 of 6 One of the tools I have most wanted to talk...
  3. Reporting Services Integration in SharePoint 6 of 6 To wrap up this session on integrating Reporting Services in...
  4. Reporting Services Integration in SharePoint 4 of 6 Moving into Middle Leader and Class teacher analysis, yesterday we...
  5. Reporting Services Integration in SharePoint 5 of 6 Having reached the class level of our data analysis tool...

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!


Spam Protection by WP-SpamFree