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
(1110)
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
(1110)
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 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.

More from the author
Getting Started with Power BI
Beginner
4h 56m
Sep 3, 2021
Modeling Data in Power BI
Beginner
4h 56m
May 12, 2021
Building Your First Power BI Report
Beginner
1h 31m
Mar 1, 2021
More courses by Stacia Misner Varga