Creating Tabular Data Models
SQL Server 2014
| Expert
- 14 videos | 1h 18m 45s
- Earns a Badge
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 49sIn 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 30sIn this video, you will learn how to import data into a tabular model using the Table Import Wizard. FREE ACCESS
-
3. Defining Relationships Between Tables5mLearn how to define relationships between tables using the model designer. FREE ACCESS
-
4. Creating Hierarchies4m 3sIn this video, you will learn how to create hierarchies to define relationships between columns in a table. FREE ACCESS
-
5. Managing the Visibility of Columns5m 20sLearn how to hide and freeze columns to manage their visibility. FREE ACCESS
-
6. Sorting and Filtering Columns5m 3sDuring this video, you will learn how to sort and filter data in columns. FREE ACCESS
-
7. Creating Perspectives4m 19sIn this video, you will learn how to create perspectives to define viewable subsets of a model. FREE ACCESS
-
8. Configuring Server and SSAS Database Roles5m 59sFind out how to configure server roles and SSAS database roles to implement security. FREE ACCESS
-
9. Configuring Roles in a Tabular Model Database5m 14sIn this video, you will learn how to configure roles to grant permissions to a tabular model database. FREE ACCESS
-
10. Implementing Dynamic Security9m 7sIn this video, you will learn how to implement dynamic security for custom security approaches. FREE ACCESS
-
11. Implementing Row-Level Permissions6m 59sIn this video, find out how to implement permissions at the row level. FREE ACCESS
-
12. Backing Up and Restoring a Tabular Database5m 9sFind out how to back up a tabular database. FREE ACCESS
-
13. Restoring and Importing PowerPivot6m 35sLearn how to restore and import a PowerPivot model into an SSAS instance. FREE ACCESS
-
14. Using a MDX Script to Import a Partial PowerPivot Model4m 38sDuring 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.
