/
Browse
/
Courses
/
SAP SQL Data Warehousing
/
Designing the Data Warehouse
Choosing SAP HANA to Build a Data Warehouse
Describing a Custom SQL Data Warehouse
12 min
Describing the Key Features of SAP HANA
10 min
Outlining the SAP HANA Development Environment
10 min
Getting Started with a Development Project
25 min
Quiz
Designing the Data Warehouse
Choosing a Reference Data Warehouse Architecture
13 min
Selecting a Modeling Approach
15 min
Quiz
Implementing the Data Warehouse
Implementing the Data Warehouse Architecture in SAP HANA
11 min
Loading Data from External Schemas
20 min
Defining Tables in the Data Warehouse
10 min
Working with Flowgraphs
10 min
Developing the Persistent Layers of the Data Warehouse
37 min
Developing the Virtual Layers of the Data Warehouse
36 min
Moving the Data Warehouse to Production
10 min
Quiz
Choosing SAP HANA to Build a Data Warehouse
Describing a Custom SQL Data Warehouse
12 min
Describing the Key Features of SAP HANA
10 min
Outlining the SAP HANA Development Environment
10 min
Getting Started with a Development Project
25 min
Quiz
Designing the Data Warehouse
Choosing a Reference Data Warehouse Architecture
13 min
Selecting a Modeling Approach
15 min
Quiz
Implementing the Data Warehouse
Implementing the Data Warehouse Architecture in SAP HANA
11 min
Loading Data from External Schemas
20 min
Defining Tables in the Data Warehouse
10 min
Working with Flowgraphs
10 min
Developing the Persistent Layers of the Data Warehouse
37 min
Developing the Virtual Layers of the Data Warehouse
36 min
Moving the Data Warehouse to Production
10 min
Quiz
Knowledge quiz
It's time to put what you've learned to the test, get 2 right to pass this unit.
1.
Why do we model a data warehouse using layers?
There are two correct answers.
To generate multiple shapes of data for consumption, from a consistent source layer
To provide separation of data for each line of business
To minimize disruption to existing data models when adding new data sources
2.
Which are types of data model?
There are three correct answers.
Data Vault
3NF
Data Mart
Dimensional / Star schema