Implementing & Configuring Cubes

SQL Server 2014
  • 18 Videos | 1h 31m 18s
  • Earns a Badge
Likes 7 Likes 7
A SQL Server Analysis Services (SSAS) cube contains the information required to perform analysis on the data. Learn how to create cubes, measures, measure groups, and other elements including perspectives, hierarchies, and relationships.

WHAT YOU WILL LEARN

  • create a new cube using the Cube Wizard
    create an empty cube
    create a cube using a template
    view and navigate the cube schema
    browse cube data and metadata to examine the structure of the cube
    check data, calculations, formatting, and security of the database objects
    create an action on a selected cube
    view and change cube dimension properties
    view and change cube hierarchy properties
  • view and change cube attribute properties
    add dimensions to cubes through Cube Designer
    add measures to cubes through Cube Designer
    add measures groups through Cube Designer
    define translations in a cube
    create perspectives for a cube
    implement many-to-many relationships in a cube
    implement fact relationships in a cube
    implement role-playing relationships in a cube

IN THIS COURSE

  • Playable
    1. 
    Creating a Cube Using Existing Tables
    5m 42s
    UP NEXT
  • Playable
    2. 
    Creating an Empty Cube
    3m 28s
  • Locked
    3. 
    Creating a Cube using a Template
    3m 48s
  • Locked
    4. 
    Viewing the Cube Schema in Cube Designer
    4m 55s
  • Locked
    5. 
    Viewing Cube Data and Metadata in Cube Designer
    4m 24s
  • Locked
    6. 
    Checking Cube Data through the Browser
    4m 42s
  • Locked
    7. 
    Creating Actions on a Cube
    5m 40s
  • Locked
    8. 
    Defining Cube Dimension Properties
    4m 38s
  • Locked
    9. 
    Defining Cube Hierarchy Properties
    5m 2s
  • Locked
    10. 
    Defining Cube Attribute Properties
    4m 19s
  • Locked
    11. 
    Adding Dimensions to Cubes
    5m 46s
  • Locked
    12. 
    Adding Measures to Cubes
    5m 5s
  • Locked
    13. 
    Adding Measure Groups to Cubes
    3m 20s
  • Locked
    14. 
    Defining Translations in a Cube
    4m 36s
  • Locked
    15. 
    Creating Perspectives for a Cube
    4m 21s
  • Locked
    16. 
    Implementing Many-to-Many Relationships
    5m 4s
  • Locked
    17. 
    Implementing Fact Relationships
    6m 45s
  • Locked
    18. 
    Implementing Role-Playing Relationships
    3m 46s

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

Likes 5 Likes 5  
Likes 15 Likes 15