I work using Reporting Services 2008 and I'm constantly creating ad-hoc reports. We'd like to use PowerPivot on Sharepoint but we're stuck on Sharepoint 2007. Using easy reporting software like Tableau Server would be fantastic but we can't afford it SSRS Report Builder hasn't proved to be very helpful, unfortunately.

I've been trying to think of ways to leverage Excel / PowerPivot or any other (free or inexpensive) tool. We just need to be able to provide more data to users so they can analyze on their own. This is an area our IT team as a whole needs to improve.

We use SSRS 2008 and SQL Server 2008. We also don't have a data warehouse, it's in the works...

  • Short answer: provide excel exports.
    – mike30
    Feb 12, 2013 at 16:48
  • hey Gabe, I know this question is very old. I'm just curious how you went about this problem. what solution did you implemented?
    – chip
    Jan 30, 2018 at 16:31

2 Answers 2


We have deployed a simple BI system using Excel / PowerPivot as the front end allowing users to build there own reports.

We wrote a User Manual (including a data dictionary) and provided the users with training, we dedicated a few of the more technical users as power users that field questions from the user base , if a power user need help he\she comes to us.

It's really not that bad, it takes a while for it to Click, but when it does they do fine.

Just do it.


http://www.sqlpower.ca/page/wabit - is an open source on-the-fly reporting tool. Not sure whether you are looking for something similar, but please check the demo videos they have in the website.

More: The above tools enables to connect to multiple databases and write queries in a visual manner. The filters could be dragged and dropped and joins between tables could be visually edited. I think this will be a step in the direction of a solution in your above mentioned issue with too much ad-hoc reporting and more close to the dimensional model/ database level manipulations and querying ,than an excel alternative. Also more power to the end user at the expense of more technical exposure.

  • would you mind explaining about this in more detail - how and why does it answer the question asked? "Link-only answers" are not quite welcome at Stack Exchange
    – gnat
    Feb 12, 2013 at 11:56
  • 1
    sure, please find edits above.
    – dbza
    Feb 13, 2013 at 15:17
  • BTW that was not a 'link-only' answer, I thought the user can find more from my comment about the existing demos rather than spending time explaining.
    – dbza
    Feb 13, 2013 at 15:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.