Analysis Services Fundamentals

This course is for business intelligence developers and database professionals responsible for preparing data for multidimensional analysis and assumes no prior experience with Analysis Services

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.

• 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