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
Course info
Rating
(1101)
Level
Beginner
Updated
Aug 22, 2011
Duration
6h 31m
Table of contents
Introduction to Analysis Services
Dimensional Model Development
Dimension Development I
Dimension Development 2
Cube Development I
Cube Development 2
Calculations 1
Calculations 2
Database Processing
Security
Description
Course info
Rating
(1101)
Level
Beginner
Updated
Aug 22, 2011
Duration
6h 31m
Description

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.

About the author
About the author

Stacia Misner Varga is a consultant, instructor, author, mentor, BI Partner for SQLSkills, and principal of Data Inspirations specializing in Microsoft business intelligence technologies for over 10 years. She is a frequent speaker at the PASS Summit, IT/Dev Connections conferences, and various SQL Saturday and Microsoft-related events worldwide.

More from the author
Securing SSAS Models
Advanced
1h 40m
Apr 10, 2020
Tuning SSAS Models
Advanced
3h 3m
Mar 10, 2020
Building Multidimensional Models in SSAS
Beginner
3h 51m
Dec 26, 2019
More courses by Stacia Misner Varga