/
Browse
/
Courses
/
Designing Data Models and Transforming Data in SAP Analytics Cloud
/
Designing and Creating Dimensions
Explaining the Basics of Data Structures in SAP Analytics Cloud
Explaining Where the Data Comes From
9 min
Identifying the Differences Between Model Types
14 min
Creating Datasets
11 min
Quiz
Designing and Creating Dimensions
Defining Dimensions
8 min
Identifying Dimension Types
10 min
Describing Properties
8 min
Designing and Creating Hierarchies
22 min
Importing and Preparing Master Data for a Dimension
20 min
Quiz
Creating Import Models
Creating an Import Model
28 min
Importing Data Into a Model.
21 min
Preparing and Transforming Transaction Data
34 min
Scheduling Data Imports
3 min
Introducing Formulas and Calculations
15 min
Creating Formulas and Calculations
16 min
Converting Currency
35 min
Designing and Creating Time Hierarchies
25 min
Quiz
Working With Live Models
Using Data Analyzer to Preview Your Live Data Structure
12 min
Creating Live Models
31 min
Working With SAP Datasphere
25 min
Quiz
Working With Geographic Data
Configuring Geographic Data in a Model
20 min
Quiz
Defining Data Security
Defining Data Access
23 min
Quiz
Explaining the Basics of Data Structures in SAP Analytics Cloud
Explaining Where the Data Comes From
9 min
Identifying the Differences Between Model Types
14 min
Creating Datasets
11 min
Quiz
Designing and Creating Dimensions
Defining Dimensions
8 min
Identifying Dimension Types
10 min
Describing Properties
8 min
Designing and Creating Hierarchies
22 min
Importing and Preparing Master Data for a Dimension
20 min
Quiz
Creating Import Models
Creating an Import Model
28 min
Importing Data Into a Model.
21 min
Preparing and Transforming Transaction Data
34 min
Scheduling Data Imports
3 min
Introducing Formulas and Calculations
15 min
Creating Formulas and Calculations
16 min
Converting Currency
35 min
Designing and Creating Time Hierarchies
25 min
Quiz
Working With Live Models
Using Data Analyzer to Preview Your Live Data Structure
12 min
Creating Live Models
31 min
Working With SAP Datasphere
25 min
Quiz
Working With Geographic Data
Configuring Geographic Data in a Model
20 min
Quiz
Defining Data Security
Defining Data Access
23 min
Quiz
Knowledge quiz
It's time to put what you've learned to the test, get 8 right to pass this unit.
1.
What is a type of hierarchy?
There are two correct answers.
Level-based
Branched tree
Parent-Child
Star schema
2.
A model can contain multiples of which dimension type?
There are two correct answers.
Account
Generic
Date
Version
Organization
3.
What dimension types can you add when you create a model in SAP Analytics Cloud?
There are three correct answers.
Account
Version
Generic
Organization
Time
4.
Measure values are stored in models.
Choose the correct answer.
True
False
5.
Data preparation involves manipulating the data to make it accurate and to match your business needs.
Choose the correct answer.
True
False
6.
What can you use to prepare master data?
There are two correct answers.
Calculation Editor
Custom Expression Editor
Smart Transformations
Formula Editor
7.
Which dimension cannot be shared among models?
Choose the correct answer.
Imported
Live
Public
Private
8.
You can add calculated columns when importing into a dimension.
Choose the correct answer.
True
False
9.
A Person Responsible property can be created in a Generic dimension.
Choose the correct answer.
True
False
10.
You can create public date dimensions.
Choose the correct answer.
True
False