O'Reilly logo

Microsoft® Office SharePoint® Server 2007 Best Practices by Bill English, Ben Curry

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required