Designing Multidimensional Data Sources

SQL Server 2014    |    Intermediate
  • 14 videos | 1h 12m 46s
  • Includes Assessment
  • Earns a Badge
Rating 4.8 of 4 users Rating 4.8 of 4 users (4)
SQL Server Analysis Services (SSAS) multidimensional models contain objects called cubes, dimensions, and measures. Discover how to design these objects, and create new projects.

WHAT YOU WILL LEARN

  • Create a new project in ssdt using a template
    Create a new project in ssdt using an existing database
    Identify the folders, file types, and templates used in a project
    Describe a dimension and how it is used in a multidimensional model
    Describe what measures and measure groups  are in a multidimensional model
    Describe measures and aggregation behavior
    Describe many-to-many relationships in analysis services
  • Describe fact relationships in analysis services
    Describe referenced relationships in analysis services
    Design patterns for representing business facts and dimensions
    Design dimensions to support multiple related measure groups
    Identify the attributes for dimensions
    Describe what user-defined hierarchies are
    Define granularity of dimension relationships

IN THIS COURSE

  • 9m 9s
    During this video, you will learn how to create a new project in SSDT using a template. FREE ACCESS
  • 4m 17s
    Learn how to create a new project in SSDT using an existing database. FREE ACCESS
  • Locked
    3.  Exploring Project Folders, File Types, and Templates
    7m 52s
    In this video, you will identify folders, file types, and templates used in a project. FREE ACCESS
  • Locked
    4.  Understanding Dimensions in a Multidimensional Model
    7m 46s
    Upon completion of this video, you will be able to describe a dimension and how it is used in a multidimensional model. FREE ACCESS
  • Locked
    5.  Understanding Measures in a Multidimensional Model
    2m 53s
    After completing this video, you will be able to describe what measures and measure groups are in a multidimensional model. FREE ACCESS
  • Locked
    6.  Identifying Measures and Aggregation Behavior
    3m 35s
    Upon completion of this video, you will be able to describe measures and how they behave when aggregated. FREE ACCESS
  • Locked
    7.  Understanding Many-to-Many Relationships
    5m 36s
    After completing this video, you will be able to describe many-to-many relationships in Microsoft SQL Server Analysis Services. FREE ACCESS
  • Locked
    8.  Understanding Fact Relationships
    3m 22s
    After completing this video, you will be able to describe fact relationships in Microsoft SQL Server Analysis Services. FREE ACCESS
  • Locked
    9.  Understanding Referenced Relationships
    3m 22s
    Upon completion of this video, you will be able to describe relationships that are referenced in Analysis Services. FREE ACCESS
  • Locked
    10.  Designing Patterns for Business Facts and Dimensions
    5m 9s
    In this video, you will learn how to design patterns for representing business facts and dimensions. FREE ACCESS
  • Locked
    11.  Designing Dimensions to Support Related Measure Groups
    4m 37s
    To design dimensions to support multiple related measure groups: FREE ACCESS
  • Locked
    12.  Identifying Attributes for Dimensions
    4m 52s
    In this video, you will learn how to identify the attributes for dimensions. FREE ACCESS
  • Locked
    13.  Building Hierarchies
    4m 33s
    After completing this video, you will be able to describe what user-defined hierarchies are, and how to create them. FREE ACCESS
  • Locked
    14.  Defining Granularity of  Dimension Relationships
    5m 45s
    Find out how to define the granularity of dimension relationships. 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

Journey Learn Visual Design
Book Data & Analytics for Instructional Designers
Channel Big Data
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Tables, Fields & Entries in Access 2019 for Windows
Rating 4.4 of 77 users Rating 4.4 of 77 users (77)
Course Creating Tabular Data Models
Rating 4.0 of 7 users Rating 4.0 of 7 users (7)
Course Azure Data Scientist Associate: Azure Data Factory
Rating 4.8 of 53 users Rating 4.8 of 53 users (53)