Microsoft has updated it’s roadmap for Business Intelligence products. The new roadmap consolidates into SharePoint Server, leaving SharePoint, Excel, and SQL Server the primary components of a BI solution. I have summarized the important notes and implications of this announcement: Starting today, Businesses that operate under SharePoint Enterprise CAL SA licensing, can use Performance Point Server at no additional cost. Performance Point Server’s features will be incorporated into future versions...
Update: I have added some links to tools that should help you overcome this limitation. We were told that Excel Services has support for displaying data from external locations, such as SQL server, and that's great! Until you try it out and fail.. Try creating a simple excel document with a Table that displays data from a SQL server table . Now try to view it in Excel Web Access. You will fail with the following error: The thing is, Excel services supports displaying data from external data sources...