Skip Navigation
search: People Opens New Window | Departments Opens New Window | Penn State Opens New Window | Web Opens New Window
Penn State mark
Penn State mark
University Bulletin
Undergraduate Degree Programs

These course descriptions are not being updated as of August 1, 2016. Current course descriptions are maintained in LionPATH.

Mangt Info Systems (MIS)

MIS 447 Data Warehousing (3) This course focuses on fundamental principles and applications of data warehousing. Topics covered include data warehouse planning, design, and implementation.

MIS 447 Data Warehousing (3)

This course focuses on fundamental principles and applications of data warehousing. Issues related to data warehouse planning, design, and implementation are also covered in this course. Through case studies in various business domains, course exercises and projects, students will learn practical dimensional modeling techniques, extract/transformation/load (ETL) logic, ETL design considerations, and report generation. Essentially, students will learn how to align multiple sources of data through data warehousing architectures for deriving valuable business insights through subsequent business intelligence operations.

The course begins by reviewing basic database modeling principles, and then introduces dimensional modeling in the context of the various data warehousing architectures (e.g., Kimball, Corporate Information Factory, hybrid architectures). Key concepts related to data warehousing including dimensional table characteristics, fact table characteristics and granularity, types of dimensions, types of fact tables, dimension attribute hierarchies, consolidated fact tables, slowly changing dimension techniques, and multivalued dimensions and weighting factors are covered in the course. Also, key advanced database management techniques such as views, procedures, and triggers will be introduced. Building on these core concepts, the course also covers related concepts including the role of online analytical processing (OLAP) and packaged analytic solutions, enterprise data warehouse business architecture and matrix, data warehousing lifecycle, ETL subsystems and tasks, ETL system planning, ETL design and development process and tasks, and data modeling best practices for big data.

Case studies from various business domains and processes are included throughout the course. Examples of these domains include retail sales, order management, procurement, accounting, healthcare, insurance, transportation, and telecommunication. The case studies are used to illustrate the concepts as well as provide a context for hands-on exercises. Through course assignments and group projects, students have an opportunity to gain hands-on experience with data warehouse design, development, and prototype implementation.

General Education: None
Diversity: None
Bachelor of Arts: None
Effective: Summer 2015
Prerequisite: MIS 336 or equivalent approved course

Note : Class size, frequency of offering, and evaluation methods will vary by location and instructor. For these details check the specific course syllabus.


Look up course abbreviations

Course descriptions are stored in LionPATH, the University-wide student information system. Please visit the LionPATH Course Catalog to access current course descriptions. At that point, you will be leaving the University Bulletin website.

Skip Popular Searches
  1. Bachelor of Arts Degree Requirements
  2. General Education: United States Cultures and International Cultures
  3. Course Index
  4. Graduate Degree Programs Bulletin
  5. General Education: Arts
  6. General Education: Humanities
  7. General Education: Health and Physical Activity
  8. General Education: Natural Sciences
  9. General Education: Social and Behavioral Sciences
  10. General Education: Writing/Speaking