BI Integration with SharePoint Server 2007

Excel, Excel Services, SharePoint Report Center, and the Business Data Catalog (BDC) are the default, or core, BI features within the Office suite of products. SQL Server 2005 Reporting Services, Analysis Services, and PerformancePoint Server 2007 extend the core BI functionality by offering enhanced reporting capabilities, data warehousing, in-depth data analysis, and real-time monitoring. Figure 18-3 shows the overall relationship between the various BI applications. Note how pivotal SharePoint Server 2007 is as the negotiation point for data between server and client applications.

SharePoint Server 2007 in the grand scheme of BI applications

Figure 18-3. SharePoint ...

Get Microsoft® Office SharePoint® Server 2007 Best Practices now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.