Lectures

=MIS343 - Data Warehousing=
 * Fall'2010, Faculty of Computer Science, IBA - Karachi**

Kimball - Chapter 1 || Kimball - Chapter 1 || Kimball - Chapter 2 || OLAP ||  || Ponniah, Chapter 15 ||
 * **Lecture #** || **Date** || **Topic** || **Lecture** || **Reading Material** ||
 * 1 || Sep'15 || Data warehousing - Introduction || [[file:Lecture 01 - Datawarehousing Introduction and Architecture.pdf]] || Ponniah, Chapter 1 ||
 * 2 || Sep'18 || Data warehousing - Definition || [[file:Lecture 02 - Definition_DWandDatamart.pdf]] || Ponniah, Chapter 2 ||
 * 3 || Sep' 22 || Building blocks of Data warehouse environment || [[file:Lecture 03 - DW Environment.pdf]] || Ponniah, Chapter 2 ||
 * 4 || Sep' 25 || Dimension Modeling - Dimensions, Facts, Measures || [[file:Dimension Modeling - I.pdf]] || Ponniah, Chapter 10
 * 5 || Sep' 29 || Dimension Modeling - Characteristics of Dimension tables, Hierarchies, Roll up/Drill-Down, Surrogates || [[file:Lectures - Dimension Modeling.pdf]] || Ponniah, Chapter 10
 * 6 || Oct' 02 || Dimension Modeling - Additive/Semi additive measures, Degenerate Dimensions, Snowflaking ||  || Ponniah, Chapter 10
 * || Oct' 06 || Canceled due to Turkey conference ||  ||   ||
 * || Oct' 09 || Canceled due to Turkey conference ||  ||   ||
 * 7 || Oct' 13 || Type of fact tables - Transactional, Periodic snapshots, Value chain, Factless fact table ||  || Ponniah, Chapter 11 ||
 * 8 || Oct' 13 || Slowly changing dimensions - Type 1,2, and 3 changes ||  || Ponniah, Chapter 11, Kimball - Chapter 6 (Minidimension & Hierarchies) ||
 * 9 || Oct' 16 || Minidimensions, Ragged hierarchies ||  ||   ||
 * ||  || **TERM EXAM - 1** ||   ||   ||
 * 10 || Oct' 30 ||  ||   ||   ||
 * 11 || Nov' 03 || ETL - Extraction ( Immediate data extraction) || [[file:Lectures - Extract-Transform-Load(ETL).pdf]] || Ponniah, Chapter 12 ||
 * 12 || Nov' 10 || ETL (Data Extraction - Immediate and Deferred data extraction) ||  || Ponniah, Chapter 12 ||
 * 13 || Nov' 10 || ETL - Data Transformation ||  || Ponniah, Chapter 12 ||
 * 14 || Nov' 13 || ETL Quiz || [[file:LabQuiz01.rar]] ||  ||
 * 15 || Nov' 14 || Data Quality ||  || Ponniah, Chapter 13 ||
 * 16 || Nov' 20 || Data Quality ||  || Ponniah, Chapter 13 ||
 * 17 || Nov' 24 || Revision - Dimension modeling with an example of flight reservation ||  ||   ||
 * 18 || Nov' 27 || Quiz
 * 19 || Dec' 01 || OLAP || [[file:OLAP.pdf]] || Ponniah, Chapter 15 ||
 * 20 || Dec' 01 || OLAP, Revision, Quiz Discussion ||  ||   ||
 * ||  || **TERM EXAM - II** ||   ||   ||
 * 21 || Dec' 11 || OLAP Operations ||  ||   ||
 * || Dec' 15 || Canceled due to Muharram ||  ||   ||
 * 22 || Dec' 18 || OLAP - Cube Materialization ||  ||   ||
 * 23 || Dec' 22 || Cube in SSAS, KPI, Dashboard || [[file:KPI.docx]]

Dynamic dashboard using Excel: [] ||  ||
 * 24 || Dec' 29 || MDX || [[file:MDX_Updated.pdf]] ||  ||
 * 25 || Jan' 01 || MDX || [[file:MDX Sample Queries_new.mdx]] ||  ||
 * 26 || Jan' 01 || MDX ||  ||   ||
 * 27 || Jan' 05 || Datamining || [[file:Data Mining Unit 1.pdf]] ||  ||
 * 28 || Jan' 05 || Datamining ||  ||   ||
 * 29 || Jan' 08 || Project Queries ||  ||   ||
 * 30 || Jan' 12 ||  ||   ||   ||