Preparing for BI Data Models

SQL Server 2014    |    Expert
  • 5 videos | 32m 33s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 33 users Rating 4.6 of 33 users (33)
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 59s
    After 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
  • 6m
    After completing this video, you will be able to describe the considerations for choosing an analytical data model for an SSAS solution. FREE ACCESS
  • Locked
    3.  Choosing the Appropriate Schema for a Data Model
    6m 38s
    To choose between a star schema and a snowflake schema for a multidimensional data model, consult a database administrator or other IT professional. FREE ACCESS
  • Locked
    4.  Designing a Relational Model for a Data Mart
    6m 50s
    In this video, you will learn how to design a relational model for a Data Mart. FREE ACCESS
  • Locked
    5.  Designing Proactive Caching within SSAS
    7m 7s
    Find 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.

YOU MIGHT ALSO LIKE

Course Microsoft Azure Infrastructure Solutions: Data Solutions
Rating 4.6 of 34 users Rating 4.6 of 34 users (34)
Course Training Machine Learning Models in Power BI
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Book Microsoft Power BI Data Analyst Certification Companion: Preparation for Exam PL-300

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Microsoft Azure DevOps Solutions: Modern Source Control Strategies
Rating 4.5 of 31 users Rating 4.5 of 31 users (31)
Course BI Reporting & Analysis
Rating 4.5 of 37 users Rating 4.5 of 37 users (37)
Course Customer Service: Strengthening Your Service Skills
Rating 4.6 of 2057 users Rating 4.6 of 2057 users (2057)