Preparing for BI Data Models
SQL Server 2014
| Expert
- 5 videos | 32m 33s
- Includes Assessment
- Earns a Badge
SQL Server Analysis Services uses data models for the storage and analysis of data. Explore the Business Intelligence Semantic Model (BISM) framework, and how to choose and design the appropriate model.
WHAT YOU WILL LEARN
-
Describe the two types of bism data models and how they can be used to create a unified analysis services platform
Describe the considerations for choosing an analytical data model for an ssas solution
Choose between a star and snowflake schema for a multidimensional data model -
Identify how to design a relational model for a data mart
Determine the appropriate proactive caching method within ssas for different scenarios
IN THIS COURSE
-
5m 59sAfter completing this video, you will be able to describe the two types of BISM data models and how they can be used to create a unified Analysis Services platform. FREE ACCESS
-
6mAfter completing this video, you will be able to describe the considerations for choosing an analytical data model for an SSAS solution. FREE ACCESS
-
3. Choosing the Appropriate Schema for a Data Model6m 38sTo choose between a star schema and a snowflake schema for a multidimensional data model, consult a database administrator or other IT professional. FREE ACCESS
-
4. Designing a Relational Model for a Data Mart6m 50sIn this video, you will learn how to design a relational model for a Data Mart. FREE ACCESS
-
5. Designing Proactive Caching within SSAS7m 7sFind out how to determine the appropriate Proactive Caching method within SSAS for different scenarios. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
