Microsoft Office Excel and Microsoft SQL Server Analysis Services: An In-Depth Look at Integration
Play Microsoft Office Excel and Microsoft SQL Server Analysis Services: An In-Depth Look at Integration
Microsoft Office Excel 2007 has improved Excel BI capabilities dramatically. Better connection management, better pivot tables and better support of Microsoft Analysis Services 2005 features. New to Excel 2007 is a family of functions known as the cube functions which can bring Online Analytical Processing (OLAP) data to individual cells. Using a combination of pivot tables and cube functions, Excel power users can create analysis platforms that are both dynamic and richly formatted. Such solutions can combine data from multiple OLAP cubes, OLAP and non OLAP data, and Excel calculations. In this session we spend an hour building such a solution from scratch. The last part of the session is about publishing the solution to Excel Services, part of Microsoft Office Sharepoint Server 2007.