Accessing SQL Server 2008 R2 Analysis Services Data This unit wraps up our coverage of SQL Server 2008 R2 Analysis Services by describing how to access cube data from familiar tools like Reporting Services, Excel 2010 and SharePoint 2010 Excel Services. Hands-On Labs Hands On Lab: Building Your First Multidimensional Report with SQL Server 2008 R2 Reporting Services This Hands On Lab will show you how to expose Analysis Services data in your application using the Visual Studio 2010 ReportViewer control. Videos Presentation: Developing SQL Server 2008 R2 Reporting Services Reports for Analysis Services This presentation introduces the SQL Server 2008 R2 Reporting Services query designer for Analysis Services which is used to graphically design MDX queries used in a report data source. Presenter: Peter Myers, Mentor, Solid Quality Mentors. Demo: Developing a Simple SQL Server 2008 R2 Reporting Services Report with an Analysis Services Cube This demo shows how to develop a simple SQL Server 2008 R2 Reporting Services report using Analysis Services cube. The demo will show how to develop an MDX query with the graphical designer, and how to incorporate formatting properties from the cube in a report. Presenter: Peter Myers, Mentor, Solid Quality Mentors. Presentation: Using Excel 2010 as an Analysis Services Client This presentation covers the use of Excel 2010 as an Analysis Services client. Presenter: Peter Myers, Mentor, Solid Quality Mentors. Demo: Creating an Excel 2010 PivotTable Using a SQL Server 2008 R2 Analysis Services Cube This demo shows how to create an Excel 2010 PivotTable using an SQL Server 2008 R2 Analysis Services cube. The PivotTable will support interactive filtering with a slicer and incorporate calculations from the cube. Presenter: Peter Myers, Mentor, Solid Quality Mentors. Presentation: Using SharePoint 2010 Excel Services with Analysis Services Data This presentation covers the use of SharePoint 2010 Excel Services to provide users access to Analysis Services data. Presenter: Peter Myers, Mentor, Solid Quality Mentors. Demo: Publishing and Sharing SQL Server 2008 R2 Analysis Services Cube Data with SharePoint 2010 Excel Services This demo shows how to deliver browser-based access to SQL Server 2008 R2 Analysis Services cube data using SharePoint 2010 Excel Services. Presenter: Peter Myers, Mentor, Solid Quality Mentors.