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
(1100)
Level
Beginner
Updated
Aug 22, 2011
Duration
6h 32m
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
(1100)
Level
Beginner
Updated
Aug 22, 2011
Duration
6h 32m
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
Building Your First Power BI Report
Beginner
1h 37m
Jun 3, 2019
Modeling Data in Power BI
Beginner
4h 57m
Mar 29, 2019
More courses by Stacia Misner Varga