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?
There are several ways to create dashboards. The easiest one is to build them just using SSRS. You've already got the technology so it's just a matter of using other controls than you're used to for regular table-design reports. You'd be using the Sparkline and Data Bar, the Indicator, some Charts. Basically a dashboard is just a regular report with a different design. To get an idea have a look at what Jason Thomas has produced here: A Sample SSRS Dashboard and some Tips & Tricks
If you've got SharePoint then you could consider using PerformancePoint Dashboards but I'm not a big fan of those. I'd prefer to build exactly the same just by using SSRS.
Other technology to consider if you've got SharePoint is called Power View. This allows you to create nice interactive dashboards.