Open Courseware - Virtual University of Pakistan

Home > Courses > Computer Science/Information Technology > CS614

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