F19-5337 Syl - Summary DATA WAREHOUSING AND BUSINESS INTELLIGENCE PDF

Preview

Summary

Syllabus...

Description

INSY 5337 – 001 Data Warehousing and BI Fall 2019 Instructor: Radha K. Mahapatra Office: Business 521 Class Time: R 7:00 – 9:50 p.m. Office Hours: R 6 – 7 pm or by appointment

Phone: (817) 272-3590 E-mail: [email protected] Business 152

Teaching Assistant: Mohammad Murad TA Office: TA Hours: TBA Textbook: Data Warehousing Fundamentals 2e, by Paulraj Ponniah, John Wiley, 2010. Prerequisites: INSY 5335 or equivalent You must have a good understanding of data modeling, database design and SQL. These concepts are covered in INSY 5335 or any first level database management course covering OLTP database systems. If you lack this knowledgebase then I suggest that you take INSY 5337 after taking INSY 5335. Course Objective: Students will learn concepts, tools, and technologies associated with modeling, design, implementation, and management of data warehouses. Course Description: This course will help the student understand the process by which a data warehouse system is designed and developed. The student will get acquainted with OLAP models and their differences with standard OLTP models. Efforts will be made to give the students a thorough understanding of the underlying concepts and software systems. Advances in data management, including data lakes and Hadoop distributed file systems will be introduced. Learning Outcomes: 1. The student will be able to describe various concepts related to data warehousing and the components of a data warehouse. 2. The student will have a thorough understanding of modeling techniques to model the requirements for a data warehouse. 3. The student will learn about various architectural configurations for implementing a data warehouse, and be able to evaluate alternative configurations. 4. The student will understand various methods and tools for extraction, transformation, and loading of data. 5. The student will learn how to access data in a data warehouse using OLAP tools. 6. Students will learn about data lakes and the Hadoop distributed file system to store and manage large sets of unstructured data Course Requirements: Course requirements include two tests, a research paper, and several assignments on DW & BI using SAP BW. You need to form groups of about 5 students for the research paper assignment. You will work in groups of 2 students on the SAP BW assignment. Details about the assignments will be separately announced. The distribution of the total grade among the different components is as follows: Assignments/Projects 20% Research Paper 20% Mid Term Exam 30% Final Exam 30% Letter Grade Assignment: Percent score >=90 A, >=80 B, >=70 C, >=60 D,...