Microsoft has changed things around a little for Excel Services in SharePoint 2010. If you don't setup an Unattended Service Account then all of your data connections in Excel will need the credentials within the connection or will need to revert to the current user.
After having implemented a new installation of MOSS 2007, I cannot figure out how to get Excel Services working. I have added the Excel Web Access web part, and linked to a MS Excel 2007 worksheet, but all I get is an error message that says "You do not have permissions to open this file on Excel Services". I also don't know how to display a specific part of the spreadsheet.
Creating information dashboards is always a challenge for end users, especially when we need to pull data from various sources. The PerformancePoint Service (PPS) is a Microsoft BI technology for displaying information dashboards within a SharePoint platform. PPS was not part of MOSS 2007. But with SharePoint 2010, Microsoft has added PPS as a service within the Enterprise version of SharePoint 2010. The Dashboard Designer provides a rich authoring environment for creating and managing dashboard content.
Microsoft SQL Server Business Intelligence (BI) Professionals are generally well versed with either of these technologies: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS). But with Sharepoint Server continuously growing as a collaboration platform with it's increasing set of Business Intelligence features, MS BI Technology Stack considerably relies on Sharepoint for hosting and/or consuming SQL Server based BI deliverables.
I find many SQL Server BI Professionals confused with the question of what are the Sharepoint based BI features one needs to have in vision to architect an end-to-end BI solution. In this article, we would look at an overview of Sharepoint BI feature
Excel workbooks published on SharePoint use the Excel Web Access web part, but the workbook is read-only. In this tip we cover how to make these Excel workbooks interactive instead of static worksheets.