Data Warehousing Concepts

Test Outline

Big Data and Data Warehouse Appliance
Hadoop
In-Memory Database
MPP Architecture
NoSQL
Un-Structured Data
Business Considerations
Business Intelligence
Metadata
Requirements
Users
Data Transformation
Cleansing and reformatting data
Extraction
Importing/Loading data
Techniques
Data Warehousing and Data Marts
Data Warehouse
Role of Data Marts
Schema
Design
Architecture
Capacity Growth
Storage Requirements
System Requirements
Dimensional Data Model
Dimensions
Facts
Indexing
Schemas
Storing Changing Data
On Line Analytical Processing (OLAP)
Hybrid OLAP (HOLAP)
Multidimensional OLAP (MOLAP)
Relational OLAP (ROLAP)
Querying and Reporting/Data Extraction
Mobile Dashboards
Multidimensional Analysis
Query Languages

 

Go Back