Designing BI Data Models
SQL Server 2014
| Expert
- 13 videos | 1h 22m 39s
- Includes Assessment
- Earns a Badge
Data models use performance indicators and aggregation to add extra value to the data being presented. Discover how to design and create multidimensional and tabular data models to achieve this goal.
WHAT YOU WILL LEARN
-
Describe how to plan for a multidimensional cube
Design data sources for analytical models, including the types of data source and the considerations
Create data sources and data source views, including relationships, for analytical models
Use the cube wizard to create a cube for a multidimensional model
Configure measures, including identifying the aggregation method
Define measure groups
Design and configure dimensions in a multidimensional model -
Design and configure relationships between tables
Design and create aggregations to improve cube performance
Design and configure cubes for drill-through
Design indexes, index views, and order by statement for ssas processing
Import tables and configure relationships and measures for a tabular model
Design and configure attributes and dimensions for a tabular model
IN THIS COURSE
-
6m 47sUpon completion of this video, you will be able to describe how to plan for a cube with multiple dimensions. FREE ACCESS
-
5m 50sLearn how to design data sources for analytical models, including the types of data sources and the considerations. FREE ACCESS
-
3. Creating a Data Source for Analytical Models5m 7sDuring this video, you will learn how to create data sources and data source views, including relationships, for analytical models. FREE ACCESS
-
4. Creating a Cube for a Multidimensional Model5m 6sLearn how to use the cube wizard to create a cube for a multidimensional model. FREE ACCESS
-
5. Defining Measures4m 22sFind out how to configure measures, including identifying the aggregation method. FREE ACCESS
-
6. Defining Measure Groups6m 16sIn this video, you will learn how to define measure groups. FREE ACCESS
-
7. Designing and Configuration Dimensions7m 35sIn this video, learn how to design and configure dimensions in a multidimensional model. FREE ACCESS
-
8. Configuring Relationships between Tables7m 44sFind out how to design and configure relationships between tables. FREE ACCESS
-
9. Designing and Creating Aggregations8m 44sFind out how to design and create aggregations to improve the performance of your cube. FREE ACCESS
-
10. Designing Cubes for Drill-through6m 59sIn this video, you will learn how to design and configure cubes for drill-through. FREE ACCESS
-
11. Designing Indexes and Index Views for Processing5m 44sIn this video, find out how to design indexes, index views, and order by statements for SSAS processing. FREE ACCESS
-
12. Creating Tables in a Tabular Model (Part 1)6m 54sIn this video, you will import tables, configure relationships, and measure for a tabular model. FREE ACCESS
-
13. Creating Tables in a Tabular Model (Part 2)5m 31sIn this video, you will learn how to design and configure attributes and dimensions for a tabular 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.
