SSRS is a very nice reporting platform that comes along with MS SQL.
Using the free Report Builder client you can make some very nice reports and publish or schedule them to run on your intranet.
But what if you want to reuse valuable information in the reports ?
Well we can you use MS PowerPivot to access the data over the internet on you client.
Open PP and choose the in the menu From Report.
Next point to the URL on you Reporting Intranet or SharePoint if you are running in mixed mode.
When you click next it will grab the TABLIX data grid in your report.
As easy as that.
This is how the bits and pieces fall together in your MS BI environment.