This course explains how to develop Analysis Services databases, beginning with the dimensional modeling process and continuing with the development of dimensions and cubes. It also covers the integration of business logic into the cube by adding calculations, named sets, and key performance indicators. This course explains how to deploy and process Analysis Services databases and how to implement security for both users and administrators. The features and demonstrations in this course focus on the SQL Server 2008 R2 release, although most topics also apply to earlier versions of Analysis Services.
Author Name: Stacia Misner Varga
Author Description:
Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.

Table of Contents

• Introduction to Analysis Services
  16mins
• Dimensional Model Development
  54mins
• Dimension Development I
  45mins
• Dimension Development 2
  45mins
• Cube Development I
  44mins
• Cube Development 2
  24mins
• Calculations 1
  43mins
• Calculations 2
  26mins
• Database Processing
  48mins
• Security
  40mins