Managing Tabular Data Models
SQL Server 2014
| Expert
- 10 Videos | 1h 4m 40s
- Earns a Badge
Tabular modeling in SQL Server Analysis Services (SSAS) lets users access data using DAX queries. Learn how to create calculations and DAX queries, and how to create and manage partitions in a tabular model.
WHAT YOU WILL LEARN
-
create calculated columns to aggregate data, including using DAX expressionscreate measures using a table's measure grid, including using DAX to create the formulacreate Key Performance Indicators, KPIscreate DAX expressions to implement tabular objects into a tabular modelimplement time intelligence using different functions to support BI analysis, including specifying a Mark Table
-
implement context modificationcreate partitions using Partitions Managermanage partitions using Partitions Managerprocess partitions using different modesconfigure the mode for data access for a tabular model
IN THIS COURSE
-
1.Creating Calculated Columns5m 23sUP NEXT
-
2.Implementing Measures in a Tabular Model7m 40s
-
3.Implementing KPIs in a Tabular Model5m 44s
-
4.Creating DAX Expressions for Tabular Objects6m 7s
-
5.Implementing Time Intelligence9m 2s
-
6.Implementing Context Modification6m 59s
-
7.Creating Partitions in a Tabular Model5m 45s
-
8.Managing Partitions in a Tabular Model5m 37s
-
9.Processing a Partition in a Tabular Model6m 30s
-
10.Configuring In-Memory or DirectQuery Access5m 52s
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.