Designing Multidimensional Models

SQL Server 2014    |    Intermediate
  • 6 videos | 30m 36s
  • Earns a Badge
Likes 11 Likes 11
SQL Server Analysis Services (SSAS) uses multidimensional models to analyze large amounts of data. Let's examine the logical and cube architectures of multidimensional models, and how to create data sources.

WHAT YOU WILL LEARN

  • describe the logical architecture
    describe the architecture of the cube, including what it contains
    identify the different types of schemas that are used for a cube
  • describe the different types of data sources
    create a data source
    create a data source view

IN THIS COURSE

  • 7m
    After completing this video, you will be able to describe the logical architecture. FREE ACCESS
  • 6m 48s
    Upon completion of this video, you will be able to describe the architecture of the cube, including what it contains. FREE ACCESS
  • Locked
    3.  Designing a Schema for a Cube Architecture
    3m 46s
    In this video, you will learn how to identify the different types of schemas that are used for a cube. FREE ACCESS
  • Locked
    4.  Understanding the Different Data Sources
    3m 35s
    Upon completion of this video, you will be able to describe the different types of data sources. FREE ACCESS
  • Locked
    5.  Creating a Data Source
    5m 10s
    In this video, you will learn how to create a data source. FREE ACCESS
  • Locked
    6.  Creating a Data Source View
    4m 18s
    In this video, you will learn how to create a data source view. 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

Channel Big Data Core Concepts
Likes 195 Likes 195  
Course Getting Started with Snowflake: Queries, Dashboards, & Tables
Course Predictive Analytics: Using SMOTE, Model Explanations, & Hyperparameter Tuning

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Traditional Data Architectures: Data Warehousing and ETL Systems
Likes 97 Likes 97  
Course Data Warehouse Essential: Concepts
Likes 144 Likes 144  
Course Performing Subqueries & Correlated Subqueries
Likes 16 Likes 16