Designing Multidimensional Data Sources

SQL Server 2014
  • 14 Videos | 1h 13m 28s
  • Includes Assessment
  • Earns a Badge
Likes 9
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

  • Playable
    1. 
    Creating a New Project Using a Template in SSDT
    9m 12s
    UP NEXT
  • Playable
    2. 
    Using an Existing Database to Create a New Project
    4m 20s
  • Locked
    3. 
    Exploring Project Folders, File Types, and Templates
    7m 55s
    FREE ACCESS
  • Locked
    4. 
    Understanding Dimensions in a Multidimensional Model
    7m 48s
    FREE ACCESS
  • Locked
    5. 
    Understanding Measures in a Multidimensional Model
    2m 56s
    FREE ACCESS
  • Locked
    6. 
    Identifying Measures and Aggregation Behavior
    3m 38s
    FREE ACCESS
  • Locked
    7. 
    Understanding Many-to-Many Relationships
    5m 39s
    FREE ACCESS
  • Locked
    8. 
    Understanding Fact Relationships
    3m 25s
    FREE ACCESS
  • Locked
    9. 
    Understanding Referenced Relationships
    3m 25s
    FREE ACCESS
  • Locked
    10. 
    Designing Patterns for Business Facts and Dimensions
    5m 12s
    FREE ACCESS
  • Locked
    11. 
    Designing Dimensions to Support Related Measure Groups
    4m 40s
    FREE ACCESS
  • Locked
    12. 
    Identifying Attributes for Dimensions
    4m 55s
    FREE ACCESS
  • Locked
    13. 
    Building Hierarchies
    4m 36s
    FREE ACCESS
  • Locked
    14. 
    Defining Granularity of  Dimension Relationships
    5m 48s
    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 Design & Install Analysis Services
Likes  11
COURSE Managing & Maintaining SSAS
Likes  10
COURSE Designing a Fact Table
Likes  12

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Data Warehousing & Business Intelligence Deployment
Likes  52
COURSE Data Warehouse Essential: Concepts
Likes  85
COURSE SQL Concepts & Queries
Likes  267