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 template
Create a new project in ssdt using an existing database
Identify the folders, file types, and templates used in a project
Describe a dimension and how it is used in a multidimensional model
Describe what measures and measure groups are in a multidimensional model
Describe measures and aggregation behavior
Describe many-to-many relationships in analysis services -
Describe fact relationships in analysis services
Describe referenced relationships in analysis services
Design patterns for representing business facts and dimensions
Design dimensions to support multiple related measure groups
Identify the attributes for dimensions
Describe what user-defined hierarchies are
Define granularity of dimension relationships
IN THIS COURSE
-
9m 9sDuring this video, you will learn how to create a new project in SSDT using a template. FREE ACCESS
-
4m 17sLearn how to create a new project in SSDT using an existing database. FREE ACCESS
-
3. Exploring Project Folders, File Types, and Templates7m 52sIn this video, you will identify folders, file types, and templates used in a project. FREE ACCESS
-
4. Understanding Dimensions in a Multidimensional Model7m 46sUpon completion of this video, you will be able to describe a dimension and how it is used in a multidimensional model. FREE ACCESS
-
5. Understanding Measures in a Multidimensional Model2m 53sAfter completing this video, you will be able to describe what measures and measure groups are in a multidimensional model. FREE ACCESS
-
6. Identifying Measures and Aggregation Behavior3m 35sUpon completion of this video, you will be able to describe measures and how they behave when aggregated. FREE ACCESS
-
7. Understanding Many-to-Many Relationships5m 36sAfter completing this video, you will be able to describe many-to-many relationships in Microsoft SQL Server Analysis Services. FREE ACCESS
-
8. Understanding Fact Relationships3m 22sAfter completing this video, you will be able to describe fact relationships in Microsoft SQL Server Analysis Services. FREE ACCESS
-
9. Understanding Referenced Relationships3m 22sUpon completion of this video, you will be able to describe relationships that are referenced in Analysis Services. FREE ACCESS
-
10. Designing Patterns for Business Facts and Dimensions5m 9sIn this video, you will learn how to design patterns for representing business facts and dimensions. FREE ACCESS
-
11. Designing Dimensions to Support Related Measure Groups4m 37sTo design dimensions to support multiple related measure groups: FREE ACCESS
-
12. Identifying Attributes for Dimensions4m 52sIn this video, you will learn how to identify the attributes for dimensions. FREE ACCESS
-
13. Building Hierarchies4m 33sAfter completing this video, you will be able to describe what user-defined hierarchies are, and how to create them. FREE ACCESS
-
14. Defining Granularity of Dimension Relationships5m 45sFind out how to define the granularity of dimension relationships. 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.
