Learn SQL Server 2008 R2 Analysis Services Development

Developers worldwide use SQL Server 2008 R2 Analysis Services to build comprehensive, enterprise-scale analytic solutions that reach users through familiar applications. If you have never developed a cube and you want to understand why you should, this new unit in the SQL Server 2008 R2 Business Intelligence Training Course (a.k.a. SQLInsights) on MSDN is a great place to start.  It will introduce you to the fundamentals of online analytical processing (OLAP), and the architecture of analytic solutions developed with Analysis Services. You will also learn how to programmatically extend Analysis Services.

Here’s an overview of the new unit:

6. Introduction to SQL Server 2008 R2 Analysis Services Presentation: Analysis Fundamentals with SQL Server 2008 R2 Analysis Services
Presentation: Understanding the Components of a SQL Server 2008 R2 Analysis Services Database
Demo: Developing a SQL Server 2008 R2 Analysis Services Database
Presentation: Introduction to SQL Server 2008 R2 Analysis Services Programming
Demo: Developing a Time Dimension with SQL Server 2008 R2 Analysis Services
Demo: Enhancing the End User Experience of a SQL Server 2008 R2 Analysis Services Cube
Hands On Lab: Building Your First Cube with SQL Server 2008 R2 Analysis Services

You can find SQLInsights on the MSDN Training and Certification Resources page at the following URL:

https://go.microsoft.com/?linkid=9761002

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 seventh SQLInsights unit, Introduction to SQL Server 2008 R2 Analysis Services Query Syntax. We hope SQLInsights will help you get started developing your first Microsoft BI solution. Thanks again for your interest in SQL Server 2008 R2!