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

Rating 4.5 of 445 users Rating 4.5 of 445 users (445)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 18 users Rating 4.5 of 18 users (18)
Rating 3.9 of 11 users Rating 3.9 of 11 users (11)
Rating 4.6 of 9 users Rating 4.6 of 9 users (9)