Labs

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

dataset for project ||  ||
 * No. || Date || Lab Objective || Lab handout ||
 * 1 || Sep' 15 || Data warehousing Tools - Overview ||  ||
 * 2 || Sep' 18 || Recap of SQL Server - Database Engine ||  ||
 * 3 || Sep' 22 || Overview of BCP to import data || [[file:Lab 2 (BCP).pdf]] ||
 * 4 || Sep' 25 || Implementation of BCP to import data || [[file:Lab 2.csv]][[file:Lab 2.sql]] ||
 * || Sep' 29 || Cancelled due to improper setup of SSIS in Lab 16. (to be resheduled later) ||  ||
 * 5 || Oct' 02 || SSIS - Simple data flow and Aggregation. Read Student and faculty data from Lab2.csv, perform necessary transformation and load it in respective tables in SQL Server. ||  ||
 * || Oct' 06 || Canceled due to Turkey conference ||  ||
 * || Oct' 09 || Canceled due to Turkey conference ||  ||
 * || Oct' 13 || Theory class conducted instead of lab ||  ||
 * 7 || Oct' 16 || SSIS - exercise to load registration data ||  ||
 * 8 || Oct' 30 || SSIS - exercise to load registration data ||  ||
 * 9 || Nov' 03 || SSIS - MaxMin Case study || [[file:Maximum Miniatures.doc]] ||
 * 10 || Nov' 10 || SSIS - MaxMin Case study - Loading Batch, Machine, Material and Plant dimensions || [[file:MaxMinLabsDM_DBScript.sql]] ||
 * 11 || Nov' 13 || ETL Lab Quiz ||  ||
 * 12 || Nov' 20 || SSIS - MaxMin Case study - Loading Batch, Machine, Material and Plant dimensions ||  ||
 * 13 || Nov' 24 || SSIS - MaxMin Case Study - Loading fact table ||  ||
 * 14 || Nov' 27 || SSIS - Loading fact table
 * ||  || TERM EXAM - II ||   ||
 * 15 || Dec' 11 || SSIS - Exception Handling ||  ||
 * 16 || Dec' 18 || SSIS - Handling Slowly changing dimensions ||  ||
 * 17 || Dec' 22 || Project dimension model review ||  ||
 * 18 || Jan' 01 || SSAS - Creating and processing cubes ||  ||
 * 19 || Jan' 05 || Excel PivotTable/PivotChart for analysis ||  ||
 * 20 || Jan' 12 || Lab Assessment || [[file:DW Lab Exam.rar]] ||
 * 21 || Jan' 12 || Lab Assessment ||  ||
 * 22 || Jan' 12 || Project Demo ||  ||