Excel Services offers a number of Business Intelligence features such as:
- Workbooks can be connected to enterprise data sources
- The logic contained in workbooks can be reused in server based code, i.e. don’t have to rewrite code specifically for the server
- Provides real time analysis of data
- Full features UI experience, there is no loss of fidelity when moving to the server.
- Sorting, Filtering and drill down all work the same, no loss of functionality.
It’s worth your time investigating the features offered by Excel Calculation Services