Note: This course code has changed from CIT 327 to ITM 327. You may occasionally see references to the old course code or title.

Course Description

This course defines the theory and practice of how database warehouse systems are designed and managed. Students will learn how to distinguish between Kimball and Inmon methods, data marts and warehouses, and Extract, Transform, and Load (ETL) processes from relational column, document store, and XML databases and physical files.

Course Outcomes

• Understand Kimball and Inmon data mart and warehousing design methods.
• Understand the solution space of relational database, NoSQL (Not only SQL) database, XML database, and file management systems.
• Understand the nature and use of the Kimball method, including how to write star queries and use basic SQL statistical functions.
• Understand how to set the granularity of a Kimball star or snowflake schema from disparate sources using interpolation and extrapolation of data through the Extract, Transform, and Load (ETL) process.
• Understand how to translate Online Transactional Processing (OLAP) repositories using Extract, Transform, and Load (ETL) methodologies that implement the Kimball method.
• Understand the telemetry and technical debt of IT solutions.

Prerequisites

Complete ONE of the following:

• CIT 225 - Database Design and Development 

Course Details

Overview

How does this course relate to other courses?

This course fits between the CIT 111 (Introduction to Databases) or CIT 225 (Database Design and Development) and CIT 381 (Business Intel and Analytics). It builds on the design concepts of Entity Relation Diagrams (ERDs) for Online Transaction Processing by introducing data marts and data warehouses.

What will I be prepared to do after this course?

The student will be prepared to assume a role working with data marts or data warehouses as a data analyst or business intelligence analyst intern. The student will also be prepared to take CIT 381 (Business Intel and Analytics).

Grading

• Preparation (30%): Weekly preparation quizzes consisting of a study materials quiz and a textbook chapter reading quiz.
• Teach One Another (30%): Weekly group presentations which prepare students prepare to complete their weekly papers.
• Ponder and Prove (40%): Weekly papers critiquing articles, presentations, and posts that are instrumental in exposing the student to data warehousing and a semester paper that requires each student to summarize their individual learning in a capstone case study.

Groups

Students will be expected to work together in groups regularly in this course. The course is set up to have one set of groups week 3-6, a separate group week 7-10, and a separate group week 11-12. Students will sign up in groups of two or three for each assignment.  The assignments are designed to give you an opportunity to collaborate with others and formulate the most important points from the study materials each week.

Technology and Textbooks

• Designing Data-Intensive Applications by Martin Kleppmann,
  O'Reilly Media, Inc., 1st edition. 2017
  Print ISBN: 9781449373320
• Linux Virtualization, Excel, Web Browser
• Articles summarizing weekly materials
• Articles and essays on the Internet

Semester Outline

University Policies

Students with Disabilities

Brigham Young University-Idaho is committed to providing a working and learning atmosphere that accommodates qualified persons with disabilities. If you have a disability and require accommodations, please contact the Disability Services Office at (208) 496-9210 or visit their website and follow the Steps for Receiving Accommodations. Reasonable academic accommodations are reviewed for all students who have qualified documented disabilities. Services are coordinated with students and instructors by the Disability Services Office.

This course may require synchronous meetings. If you are currently registered with the Disability Services Office and need an interpreter or transcriber for these meetings, please contact the deaf and hard of hearing coordinator at (208) 496-9219.

Other University Policies

Student Honor and Other Policies

Please read through the document called University Policies. It gives important information about the following topics:

• Student Honor
  • Academic Honesty
  • Student Conduct
    • Sexual Harassment
• Student with Disabilities
• Complaints and Grievances
• Copyright Notice

Go to the Student Resources module to review further resources and information.