Designing Multidimensional Data Sources
SQL Server 2014
| Intermediate
- 14 Videos | 1h 12m 46s
- Includes Assessment
- Earns a Badge
SQL Server Analysis Services (SSAS) multidimensional models contain objects called cubes, dimensions, and measures. Discover how to design these objects, and create new projects.
WHAT YOU WILL LEARN
-
create a new project in SSDT using a templatecreate a new project in SSDT using an existing databaseidentify the folders, file types, and templates used in a projectdescribe a dimension and how it is used in a multidimensional modeldescribe what measures and measure groups are in a multidimensional modeldescribe measures and aggregation behaviordescribe many-to-many relationships in Analysis Services
-
describe fact relationships in Analysis Servicesdescribe referenced relationships in Analysis Servicesdesign patterns for representing business facts and dimensionsdesign dimensions to support multiple related measure groupsidentify the attributes for dimensionsdescribe what user-defined hierarchies aredefine granularity of dimension relationships
IN THIS COURSE
-
1.Creating a New Project Using a Template in SSDT9m 9sUP NEXT
-
2.Using an Existing Database to Create a New Project4m 17s
-
3.Exploring Project Folders, File Types, and Templates7m 52s
-
4.Understanding Dimensions in a Multidimensional Model7m 46s
-
5.Understanding Measures in a Multidimensional Model2m 53s
-
6.Identifying Measures and Aggregation Behavior3m 35s
-
7.Understanding Many-to-Many Relationships5m 36s
-
8.Understanding Fact Relationships3m 22s
-
9.Understanding Referenced Relationships3m 22s
-
10.Designing Patterns for Business Facts and Dimensions5m 9s
-
11.Designing Dimensions to Support Related Measure Groups4m 37s
-
12.Identifying Attributes for Dimensions4m 52s
-
13.Building Hierarchies4m 33s
-
14.Defining Granularity of Dimension Relationships5m 45s
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.