Implementing & Configuring Cubes
SQL Server 2014
| Intermediate
- 18 videos | 1h 25m 18s
- Earns a Badge
A SQL Server Analysis Services (SSAS) cube contains the information required to perform analysis on the data. Learn how to create cubes, measures, measure groups, and other elements including perspectives, hierarchies, and relationships.
WHAT YOU WILL LEARN
-
Create a new cube using the cube wizard
Create an empty cube
Create a cube using a template
View and navigate the cube schema
Browse cube data and metadata to examine the structure of the cube
Check data, calculations, formatting, and security of the database objects
Create an action on a selected cube
View and change cube dimension properties
View and change cube hierarchy properties -
View and change cube attribute properties
Add dimensions to cubes through cube designer
Add measures to cubes through cube designer
Add measures groups through cube designer
Define translations in a cube
Create perspectives for a cube
Implement many-to-many relationships in a cube
Implement fact relationships in a cube
Implement role-playing relationships in a cube
IN THIS COURSE
-
5m 42sDuring this video, you will learn how to create a new cube using the Cube Wizard. FREE ACCESS
-
3m 28sLearn how to create an empty cube. FREE ACCESS
-
3. Creating a Cube using a Template3m 48sIn this video, you will learn how to create a cube using a template. FREE ACCESS
-
4. Viewing the Cube Schema in Cube Designer4m 55sFind out how to view and navigate the cube schema. FREE ACCESS
-
5. Viewing Cube Data and Metadata in Cube Designer4m 24sLearn how to browse cube data and metadata to examine the structure of the cube. FREE ACCESS
-
6. Checking Cube Data through the Browser4m 42sDuring this video, you will learn how to check data, calculations, formatting, and security of database objects. FREE ACCESS
-
7. Creating Actions on a Cube5m 40sLearn how to create an action on a selected cube. FREE ACCESS
-
8. Defining Cube Dimension Properties4m 38sIn this video, you will learn how to view and change cube dimension properties. FREE ACCESS
-
9. Defining Cube Hierarchy Properties5m 2sLearn how to view and change cube hierarchy properties. FREE ACCESS
-
10. Defining Cube Attribute Properties4m 19sIn this video, you will learn how to view and change cube attribute properties. FREE ACCESS
-
11. Adding Dimensions to Cubes5m 46sIn this video, you will add dimensions to cubes through the Cube Designer. FREE ACCESS
-
12. Adding Measures to Cubes5m 5sDuring this video, you will learn how to add measures to cubes using Cube Designer. FREE ACCESS
-
13. Adding Measure Groups to Cubes3m 20sLearn how to add measure groups through the Cube Designer. FREE ACCESS
-
14. Defining Translations in a Cube4m 36sIn this video, you will learn how to define translations in a cube. FREE ACCESS
-
15. Creating Perspectives for a Cube4m 21sIn this video, you will create perspective drawings for a cube. FREE ACCESS
-
16. Implementing Many-to-Many Relationships5m 4sIn this video, you will learn how to implement many-to-many relationships in a cube. FREE ACCESS
-
17. Implementing Fact Relationships6m 45sFind out how to implement fact relationships in a data cube. FREE ACCESS
-
18. Implementing Role-Playing Relationships3m 46sIn this video, you will learn how to role-play relationships in a cube. 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.
