Creating Tabular Data Models

SQL Server 2014
  • 14 Videos | 1h 23m 15s
  • Earns a Badge
Likes 13 Likes 13
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

  • Playable
    1. 
    Creating a Tabular Model Using SSDT
    5m 49s
    UP NEXT
  • Playable
    2. 
    Importing Data into a Tabular Model
    5m 30s
  • Locked
    3. 
    Defining Relationships Between Tables
    5m
  • Locked
    4. 
    Creating Hierarchies
    4m 3s
  • Locked
    5. 
    Managing the Visibility of Columns
    5m 20s
  • Locked
    6. 
    Sorting and Filtering Columns
    5m 3s
  • Locked
    7. 
    Creating Perspectives
    4m 19s
  • Locked
    8. 
    Configuring Server and SSAS Database Roles
    5m 59s
  • Locked
    9. 
    Configuring Roles in a Tabular Model Database
    5m 14s
  • Locked
    10. 
    Implementing Dynamic Security
    9m 7s
  • Locked
    11. 
    Implementing Row-Level Permissions
    6m 59s
  • Locked
    12. 
    Backing Up and Restoring a Tabular Database
    5m 9s
  • Locked
    13. 
    Restoring and Importing PowerPivot
    6m 35s
  • Locked
    14. 
    Using a MDX Script to Import a Partial PowerPivot Model
    4m 38s

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 8 Likes 8  
Likes 37 Likes 37  
Likes 8 Likes 8  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SOLID & GRASP
Likes 3218 Likes 3218  
COURSE SQL Developer
Likes 152 Likes 152  
Likes 57 Likes 57