Now that you understand how to design and query Analysis Services cubes, this eighth unit in the SQL Server 2008 R2 Business Intelligence Training Course (a.k.a. SQLInsights) on MSDN describes how to access cube data from familiar tools like Reporting Services, Excel 2010 and SharePoint 2010 Excel Services.
Here’s an overview of the new unit:
8. Accessing SQL Server 2008 R2 Analysis Services Data
Presentation: Developing SQL Server 2008 R2 Reporting Services Reports for Analysis Services
Demo: Developing a Simple SQL Server 2008 R2 Reporting Services Report with an Analysis Services Cube
Presentation: Using Excel 2010 as an Analysis Services Client
Demo: Creating an Excel 2010 PivotTable Using a SQL Server 2008 R2 Analysis Services Cube
Presentation: Using SharePoint 2010 Excel Services with Analysis Services Data
Demo: Publishing and Sharing SQL Server 2008 R2 Analysis Services Cube Data with SharePoint 2010 Excel Services
Hands On Lab: Building Your First Multidimensional Report with SQL Server 2008 R2 Reporting Services
You can find SQLInsights on the MSDN Training and Certification Resources page at the following URL:
Watch the videos and review the hands-on labs. If you want to run the demos or hands-on labs on your own computer, download and install the offline training kit. You’ll find all the SQLInsights content in the Getting Started > BI Developers page.
Next week, we’ll publish our ninth SQLInsights unit, Introduction to SharePoint 2010 PerformancePoint Services. We hope SQLInsights will help you get started developing your first Microsoft BI solution. Thanks again for your interest in SQL Server 2008 R2!