CS614 : Data Warehousing

I like this Course

Course Info

Course Category

Computer Science/Information Technology

Course Level

Undergraduate

Credit Hours

3

Pre-requisites

CS403

Instructor

Dr. Ahsan Abdullah
PhD Computer Science
UNIVERSITY OF STIRLING, Scotland, UK.

Course Contents

Introduction & Overview Normalization De-Normalization De-Normalization Techniques Issues of De-Normalization Online Analytical Processing (OLAP) Multidimensional OLAP (MOLAP) Relational OLAP (ROLAP) Dimensional Modeling (DM) Process of Dimensional Modeling Issues of Dimensional Modeling Extract Transform Load (ETL) Issues of ETL ETL Detail: Data Extraction & Transformation ETL Detail: Data Cleansing Data Duplication Elimination & BSN Method Introduction to Data Quality Management (DQM DQM: Quantifying Data Quality Total DQM Need for Speed: Parallelism Need for Speed: Hardware Techniques Conventional Indexing Techniques Need for Speed: Special Indexing Techniques Join Techniques A Brief Introduction to Data mining (DM) What Can Data Mining Do? Supervised Vs. Unsupervised Learning DWH Lifecycle: Methodologies DWH Implementation: Goal Driven Approach DWH Implementation: Goal Driven Approach DWH Life Cycle: Pitfalls, Mistakes, Tips Course Project Case Study: Agri-Data Warehouse Web Warehousing: An introduction Web Warehousing: Issues Data Transformation Services Lab Data Set Extracting Data Using Wizard Data Profiling Data Transformation and Standardization