Architecting a Reporting Services project
Posted on 2015-01-07
I have built reports in SSRS before but I have not taken on a full Enterprise Reporting system before. I was thinking about building a Data Warehouse and data marts for departments and build reports off of that. I was thinking in Report manager to have folders for each department(with roles within their departments) and have a folder for Static reports that users can just run and download the data, etc....Second have reports folder/section where users can build their own reports off of a Report Model maybe? The idea would be for them to be able to build their own report(s), etc. I could have their departmental cubes as their data sources and so on...
I was also thinking to have dashboards for Upper management users so they can logon and have it set up their own way with what they want to see. I have never done a dashboard before? Would that be buil tin BI? Where would I be able to set them up with their own dashboards?
Am I on the right track here?