Description: In SQL Server Analysis Services or SSAS, multidimensional model partitions are used to provide the physical storage for the fact data that is in a measure group. Custom logic can also be implemented into a model to provide for more granular aggregation on the data and better results for the user. This course will demonstrate how to create partitions, including local and remote partitions, and how to implement custom logic into a multidimensional model using calculated members, time intelligence, and named sets. This course is one in a series of Skillsoft courses to help learners prepare for the 70-466 Implementing Data Models and Reports with Microsoft SQL Server certification exam.

Target Audience: Business intelligence developers who create reporting and analysis solutions and individuals interested in taking the Implementing Data Models and Reports with Microsoft SQL Server certification exam

Duration: 02:26