Designing Multidimensional Models

SQL Server 2014    |    Intermediate
  • 6 videos | 30m 36s
  • Earns a Badge
Rating 4.7 of 13 users Rating 4.7 of 13 users (13)
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

Course Software Design and Development: Methodologies
Rating 4.6 of 3447 users Rating 4.6 of 3447 users (3447)
Course Visualizing Data for Impact: Visual Design Theory
Rating 4.4 of 68 users Rating 4.4 of 68 users (68)
Course Developing an AI/ML Data Strategy: The Data Analytics Maturity Model
Rating 4.6 of 260 users Rating 4.6 of 260 users (260)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Using BigML: Unsupervised Learning
Rating 4.8 of 6 users Rating 4.8 of 6 users (6)
Course Report Interactivity
Rating 4.7 of 3 users Rating 4.7 of 3 users (3)
Course Creating Tabular Data Models
Rating 4.0 of 7 users Rating 4.0 of 7 users (7)