Preparing for BI Data Models

SQL Server 2014
  • 5 Videos | 35m 3s
  • Includes Assessment
  • Earns a Badge
Likes 38 Likes 38
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

  • Playable
    1. 
    Business Intelligence Semantic Models
    5m 59s
    UP NEXT
  • Playable
    2. 
    Choosing the Appropriate BISM
    6m
  • Locked
    3. 
    Choosing the Appropriate Schema for a Data Model
    6m 38s
  • Locked
    4. 
    Designing a Relational Model for a Data Mart
    6m 50s
  • Locked
    5. 
    Designing Proactive Caching within SSAS
    7m 7s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 0 Likes 0  
Likes 10 Likes 10  
Likes 35 Likes 35  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SOLID & GRASP
Likes 3218 Likes 3218  
Likes 26 Likes 26