Implementing & Configuring Cubes

SQL Server 2014    |    Intermediate
  • 18 videos | 1h 25m 18s
  • Earns a Badge
Rating 4.2 of 5 users Rating 4.2 of 5 users (5)
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

  • 5m 42s
    During this video, you will learn how to create a new cube using the Cube Wizard. FREE ACCESS
  • 3m 28s
    Learn how to create an empty cube. FREE ACCESS
  • Locked
    3.  Creating a Cube using a Template
    3m 48s
    In this video, you will learn how to create a cube using a template. FREE ACCESS
  • Locked
    4.  Viewing the Cube Schema in Cube Designer
    4m 55s
    Find out how to view and navigate the cube schema. FREE ACCESS
  • Locked
    5.  Viewing Cube Data and Metadata in Cube Designer
    4m 24s
    Learn how to browse cube data and metadata to examine the structure of the cube. FREE ACCESS
  • Locked
    6.  Checking Cube Data through the Browser
    4m 42s
    During this video, you will learn how to check data, calculations, formatting, and security of database objects. FREE ACCESS
  • Locked
    7.  Creating Actions on a Cube
    5m 40s
    Learn how to create an action on a selected cube. FREE ACCESS
  • Locked
    8.  Defining Cube Dimension Properties
    4m 38s
    In this video, you will learn how to view and change cube dimension properties. FREE ACCESS
  • Locked
    9.  Defining Cube Hierarchy Properties
    5m 2s
    Learn how to view and change cube hierarchy properties. FREE ACCESS
  • Locked
    10.  Defining Cube Attribute Properties
    4m 19s
    In this video, you will learn how to view and change cube attribute properties. FREE ACCESS
  • Locked
    11.  Adding Dimensions to Cubes
    5m 46s
    In this video, you will add dimensions to cubes through the Cube Designer. FREE ACCESS
  • Locked
    12.  Adding Measures to Cubes
    5m 5s
    During this video, you will learn how to add measures to cubes using Cube Designer. FREE ACCESS
  • Locked
    13.  Adding Measure Groups to Cubes
    3m 20s
    Learn how to add measure groups through the Cube Designer. FREE ACCESS
  • Locked
    14.  Defining Translations in a Cube
    4m 36s
    In this video, you will learn how to define translations in a cube. FREE ACCESS
  • Locked
    15.  Creating Perspectives for a Cube
    4m 21s
    In this video, you will create perspective drawings for a cube. FREE ACCESS
  • Locked
    16.  Implementing Many-to-Many Relationships
    5m 4s
    In this video, you will learn how to implement many-to-many relationships in a cube. FREE ACCESS
  • Locked
    17.  Implementing Fact Relationships
    6m 45s
    Find out how to implement fact relationships in a data cube. FREE ACCESS
  • Locked
    18.  Implementing Role-Playing Relationships
    3m 46s
    In this video, you will learn how to role-play relationships in a cube. 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

Course AWS Solutions Architect Associate 2022: Data Storage Services
Rating 4.6 of 391 users Rating 4.6 of 391 users (391)
Book Be Data Analytical: How to Use Analytics to Turn Data into Value
Course AWS Solutions Architect Professional 2022: Databases & Caching
Rating 4.5 of 19 users Rating 4.5 of 19 users (19)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Continuous Data: Ingesting Continuous Data in Snowflake
Rating 4.8 of 33 users Rating 4.8 of 33 users (33)
Course Data Warehousing & Business Intelligence Deployment
Rating 4.4 of 22 users Rating 4.4 of 22 users (22)
Course Creating Tabular Data Models
Rating 4.0 of 7 users Rating 4.0 of 7 users (7)