ggeer
BIRLA INSTITUTE OF TECHNOLOGY AND SCIENCE, Pilani
Pilani Campus
Instruction Division
SECOND SEMESTER 2012-2013
COURSE HANDOUT (PART II)
Date: 10/01/2013
In addition to Part-I (general handout for all courses appended to this time table) this portion gives further details pertaining to the course.
Course No.: SS G515
Course Title: Data Warehousing
Instructor-in-charge: YASHVARDHAN SHARMA (yash@pilani.bits-pilani.ac.in)
Instructor : Vikas Singh (vikas@pilani.bits-pilani.ac.in)
1) Objective and Scope
Corporate decision makers require access to all the organization’s data, wherever it is located. To provide comprehensive analysis of the organization, its business, its requirements and any trends, require access to not only the current data in the database but also to historical data. To facilitate this type of analysis, data warehouses have been created to contain data drawn from several sources, maintained by different departments of the organization. This course will involve an in-depth study of various concepts needed to design, develop, and maintain a data warehouse. It also provides an introduction to end user access tools like OLAP and reporting.
2) Text Books:
T1. Ponniah P, “Data Warehousing Fundamentals”, John Wiley, 2003.
T2. Kimball R, “The Data Warehouse Toolkit”, 2e, John Wiley, 2002.
3) Reference Books
R1. Anahory S, & Dennis M, “Data Warehousing in the Real World”, Addison-Wesley, 2000.
R2. Kimball R, Reeves L, Ross M, & Thornthwaite, W, “The Data Warehouse Lifecycle Toolkit”, John
Wiley, 1998.
R3. Adamson C, & Venerable M, “Data Warehouse Design Solutions”, John Wiley, 1998.
R4. Inmon, WH, “Building the Data Warehouse”, John Wiley, 2002.
4) Course Plan
Lecture No.
Learning Objective
Topic(s)
Chapter
Reference
1-2
To understand the need, definition, & applications of a Data Warehouse
Introduction to Data Warehousing
T1: 1
To understand the components, & processes of a Data Warehouse
Data
Pilani Campus
Instruction Division
SECOND SEMESTER 2012-2013
COURSE HANDOUT (PART II)
Date: 10/01/2013
In addition to Part-I (general handout for all courses appended to this time table) this portion gives further details pertaining to the course.
Course No.: SS G515
Course Title: Data Warehousing
Instructor-in-charge: YASHVARDHAN SHARMA (yash@pilani.bits-pilani.ac.in)
Instructor : Vikas Singh (vikas@pilani.bits-pilani.ac.in)
1) Objective and Scope
Corporate decision makers require access to all the organization’s data, wherever it is located. To provide comprehensive analysis of the organization, its business, its requirements and any trends, require access to not only the current data in the database but also to historical data. To facilitate this type of analysis, data warehouses have been created to contain data drawn from several sources, maintained by different departments of the organization. This course will involve an in-depth study of various concepts needed to design, develop, and maintain a data warehouse. It also provides an introduction to end user access tools like OLAP and reporting.
2) Text Books:
T1. Ponniah P, “Data Warehousing Fundamentals”, John Wiley, 2003.
T2. Kimball R, “The Data Warehouse Toolkit”, 2e, John Wiley, 2002.
3) Reference Books
R1. Anahory S, & Dennis M, “Data Warehousing in the Real World”, Addison-Wesley, 2000.
R2. Kimball R, Reeves L, Ross M, & Thornthwaite, W, “The Data Warehouse Lifecycle Toolkit”, John
Wiley, 1998.
R3. Adamson C, & Venerable M, “Data Warehouse Design Solutions”, John Wiley, 1998.
R4. Inmon, WH, “Building the Data Warehouse”, John Wiley, 2002.
4) Course Plan
Lecture No.
Learning Objective
Topic(s)
Chapter
Reference
1-2
To understand the need, definition, & applications of a Data Warehouse
Introduction to Data Warehousing
T1: 1
To understand the components, & processes of a Data Warehouse
Data