Designing Multidimensional Models

SQL Server 2014    |    Intermediate
  • 6 Videos | 30m 36s
  • Earns a Badge
Likes 7 Likes 7
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

  • Playable
    1. 
    Understanding the Logical Architecture
    7m
    UP NEXT
  • Playable
    2. 
    Understanding the Cube Architecture
    6m 48s
  • Locked
    3. 
    Designing a Schema for a Cube Architecture
    3m 46s
    FREE ACCESS
  • Locked
    4. 
    Understanding the Different Data Sources
    3m 35s
    FREE ACCESS
  • Locked
    5. 
    Creating a Data Source
    5m 10s
    FREE ACCESS
  • Locked
    6. 
    Creating a Data Source View
    4m 18s
    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 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

COURSE PL-300: Using Time Intelligence in Power BI
COURSE Traditional Data Architectures: Relational Databases
COURSE Data Engineering on Microsoft Azure: The Serving Layer