Core BI Features in SharePoint and Office
This section discusses the core BI features built into SharePoint Server 2007 and Office:
Excel
Excel integrates well with SQL Server 2005 and SharePoint Server 2007 and plays a pivotal role in providing end-users with the tools for data analysis, data-mining construction, and the creation of PivotTables. Microsoft Office Excel 2007 enhances the end-user’s ability to access and analyze data from SSAS cubes using PivotTables and PivotCharts. Analysis Services data can also be accessed with Microsoft Office Excel 2003 via PivotTables, but involves additional configuration. Office Excel 2007 provides new features, such as the ability to view and work with ...
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.
