Data warehousing course outline

What is the course description of data warehousing?
This course gives an introduction to methods and theory for development of data warehouses and data analysis using data mining.
Data quality and methods and techniques for preprocessing of data.
Modeling and design of data warehouses..
What is the overview of data warehousing?
A data warehouse is a centralized storage system that allows for the storing, analyzing, and interpreting of data in order to facilitate better decision-making.
Transactional systems, relational databases, and other sources provide data into data warehouses on a regular basis..
Steps in Data Warehousing
Extraction of data – A large amount of data is gathered from various sources.Cleaning of data – Once the data is compiled, it goes through a cleaning process. Conversion of data – After being cleaned, the format is changed from the database to a warehouse format.

Data Warehousing Course Outline (Fall 2019) Scope: This course focuses on Data Warehousing (DWH), which is a different way of storing RDBMS data.

What is a data warehouse course?

This course is part of multiple programs

Explore the architecture, features, and benefits of data warehouses, data marts, and data lakes and identify popular data warehouse system vendors

Design and populate a data warehouse, and model and query data using CUBE, ROLLUP, and materialized views