Overview
This course is tailor-made for business intelligence developers and database professionals who are tasked with preparing data for multidimensional analysis, and it assumes no prior experience with Analysis Services.
In this comprehensive course, you will learn how to develop Analysis Services databases, starting with the dimensional modeling process and progressing through the development of both dimensions and cubes. Additionally, the course covers the integration of complex business logic into the cube by incorporating calculations, named sets, and key performance indicators (KPIs).
You will also gain expertise in deploying and processing Analysis Services databases, as well as implementing robust security measures for both users and administrators.
The features and demonstrations are centered around the SQL Server 2008 R2 release, but the key concepts and techniques are also applicable to earlier versions of Analysis Services.
University: Pluralsight
Provider: Pluralsight
Categories: Business Intelligence Courses
Syllabus
Taught by
Tags