Creating Tabular Data Models

SQL Server 2014    |    Expert
  • 14 videos | 1h 18m 45s
  • Earns a Badge
Rating 4.0 of 7 users Rating 4.0 of 7 users (7)
Tabular modeling in SQL Server Analysis Services (SSAS) provides fast performance for users. Discover how to implement tabular models in SSAS, including how to create and manage the tables, and how to manage security and backups.

WHAT YOU WILL LEARN

  • Use a project template to create a new tabular model and describe the tabular model designer interface
    Import data into a tabular model using the table import wizard
    Define relationships between tables using the model designer
    Create hierarchies to define relationships between columns in a table
    Hide and freeze columns to manage their visibility
    Sort and filter columns
    Create perspectives to define viewable subsets of a model
  • Configure server roles and ssas database roles to implement security
    Configure roles to grant permissions to a tabular model database
    Implement dynamic security for custom security approaches
    Implement row-level permissions
    Backup a tabular database
    Restore and import a powerpivot model into an ssas instance
    Define a mdx script to import a partial powerpivot model

IN THIS COURSE

  • 5m 49s
    In this video, you will learn how to use a project template to create a new tabular model and describe the Tabular Model Designer Interface. FREE ACCESS
  • 5m 30s
    In this video, you will learn how to import data into a tabular model using the Table Import Wizard. FREE ACCESS
  • Locked
    3.  Defining Relationships Between Tables
    5m
    Learn how to define relationships between tables using the model designer. FREE ACCESS
  • Locked
    4.  Creating Hierarchies
    4m 3s
    In this video, you will learn how to create hierarchies to define relationships between columns in a table. FREE ACCESS
  • Locked
    5.  Managing the Visibility of Columns
    5m 20s
    Learn how to hide and freeze columns to manage their visibility. FREE ACCESS
  • Locked
    6.  Sorting and Filtering Columns
    5m 3s
    During this video, you will learn how to sort and filter data in columns. FREE ACCESS
  • Locked
    7.  Creating Perspectives
    4m 19s
    In this video, you will learn how to create perspectives to define viewable subsets of a model. FREE ACCESS
  • Locked
    8.  Configuring Server and SSAS Database Roles
    5m 59s
    Find out how to configure server roles and SSAS database roles to implement security. FREE ACCESS
  • Locked
    9.  Configuring Roles in a Tabular Model Database
    5m 14s
    In this video, you will learn how to configure roles to grant permissions to a tabular model database. FREE ACCESS
  • Locked
    10.  Implementing Dynamic Security
    9m 7s
    In this video, you will learn how to implement dynamic security for custom security approaches. FREE ACCESS
  • Locked
    11.  Implementing Row-Level Permissions
    6m 59s
    In this video, find out how to implement permissions at the row level. FREE ACCESS
  • Locked
    12.  Backing Up and Restoring a Tabular Database
    5m 9s
    Find out how to back up a tabular database. FREE ACCESS
  • Locked
    13.  Restoring and Importing PowerPivot
    6m 35s
    Learn how to restore and import a PowerPivot model into an SSAS instance. FREE ACCESS
  • Locked
    14.  Using a MDX Script to Import a Partial PowerPivot Model
    4m 38s
    During this video, you will learn how to define an MDX script to import a partial PowerPivot model. 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

Book Visual Data Insights Using SAS ODS Graphics: A Guide to Communication-Effective Data Visualization
Course Database Fundamentals: Database Administration Basics
Rating 4.5 of 141 users Rating 4.5 of 141 users (141)
Journey Analyze Data with SQL
Rating 4.8 of 12 users Rating 4.8 of 12 users (12)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Working with tables in Excel 365 (2023)
Rating 4.0 of 5 users Rating 4.0 of 5 users (5)
Course Report Formatting
Rating 4.3 of 7 users Rating 4.3 of 7 users (7)
Course Managing Tabular Data Models
Rating 4.6 of 5 users Rating 4.6 of 5 users (5)