COMP 3838 - Data Warehouse Foundations for Business Intelligence
Computer Systems Part-time Studies Course
School of Computing and Academic Studies
To support you and your education, BCIT is adapting applied learning in formats appropriate to the unfolding global situation. All PTS classes are being delivered in an online format unless you are notified otherwise.
Course Details
Continuing on from COMP 1630 this workshop is a primer on business intelligence, data warehouse and data analytics for those moving on to higher level courses. Students must already understand industry standards in data modeling, relational database design and creating reports with SQL. This weekend workshop provides an overview of data warehouse planning and design for those moving on to the specific Business Intelligence Analytic tools covered in: COMP 4679, COMP 4680 and COMP 4681. Topics include: an overview of business intelligence the role of Extract, Transform and Load (ETL) in the data warehouse, the typical data warehouse lifecycle, plus an introduction to dimensional modeling for data warehousing. Labs focus on ETL, data quality considerations, and dimensional modeling concepts including the star and snowflake schemas. Successful participants will have an understanding of Business Intelligence concepts and industry standards in data design for data structures for information systems.
Prerequisite(s)
COMP 1630 or equivalent knowledge of data modeling and SQL.
Credits
1.0
Cost
$245.59
Fall 2020
Below are two offerings of this course for the Fall 2020 term.
CRN 41060
Duration
Sun Nov 15 - Sun Nov 29 2 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Nov 15 - Nov 29 | Sun | 09:00 - 16:00 | DTC Online Delivery |
Instructor
Donabel Santos
Course Outline
TBD – see Learning Outcomes in the interim
Cost
$245.59
Notes
- Departmental approval needed
- Please email cstpts@bcit.ca for Departmental approval. Include your Student number (A0#) and COMP__ and preferred CRN __ and Program declaration___. Late registration is not permitted. No class on November 22.
Status
CRN 46279
Duration
Sun Oct 18 - Sun Nov 01 2 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Oct 18 - Nov 01 | Sun | 09:00 - 16:00 | DTC Online Delivery |
Instructor
TBD
Course Outline
TBD – see Learning Outcomes in the interim
Cost
$245.59
Notes
- Departmental approval needed
- Please email cstpts@bcit.ca for Departmental approval. Include your Student number (A0#) and COMP__ and preferred CRN __ and Program declaration___. Late registration is not permitted. No class on October 25.
Status
This course offering has been cancelled. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.
Cancelled
Winter 2021
Below are two offerings of this course for the Winter 2021 term.
CRN 84216
Duration
Sun Jan 10 - Sun Jan 24 2 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Jan 10 - Jan 24 | Sun | 09:00 - 16:00 |
Online Delivery See Notes below |
Instructor
Donabel Santos
Course Outline
TBD – see Learning Outcomes in the interim
Cost
$245.59
Notes
- Departmental approval needed
- Please email cstpts@bcit.ca for Departmental approval. Include your Student number (A0#) and COMP__ and preferred CRN __ and Program Declaration____. Late registration is not permitted. Please sign in to the Learning Hub on the course start date for details on how the course will be delivered online. No class on January 17.
Status
A portion of seats are temporarily held for domestic students. International students: this may impact your ability to register. Learn why.
}Status
This section is only available for registration starting Wed, Oct 28 at 9:00 am (PDT)
Sneak Preview
CRN 81032
Duration
Sun Feb 07 - Sun Feb 21 2 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Feb 07 - Feb 21 | Sun | 09:00 - 16:00 |
Online Delivery See Notes below |
Instructor
Donabel Santos
Course Outline
TBD – see Learning Outcomes in the interim
Cost
$245.59
Notes
- Departmental approval needed
- Please email cstpts@bcit.ca for Departmental approval. Include your Student number (A0#) and COMP__ and preferred CRN __ and Program Declaration____. Late registration is not permitted. Please sign in to the Learning Hub on the course start date for details on how the course will be delivered online. No class on February 14 (Family Day).
Status
A portion of seats are temporarily held for domestic students. International students: this may impact your ability to register. Learn why.
}Status
This section is only available for registration starting Wed, Oct 28 at 9:00 am (PDT)
Sneak Preview
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Differentiate between relational database and data warehouse modeling concepts.
- Identify requirements and components for a data warehousing project.
- Describe the typical data warehouse lifecycle.
- Explain the role of ETL.
- Determine ETL and Data Quality considerations.
- Describe dimensional modeling concepts, including star and snowflake schemas.
- Relate current trends in data warehousing.
Effective as of Winter 2014
Related Programs
COMP 3838 is offered as a part of the following programs:
School of Computing and Academic Studies
- Applied Data Analytics
Part-time Certificate - Applied Database Administration and Design
Part-time Associate Certificate - Computer Systems
Part-time Diploma
Books & Supplies
The BCIT bookstore carries textbooks, general reference books, software, and stationery. Please visit bcit.ca/bookstore for more information.
Fall 2020
Books for Fall 2020 offerings of this course are available in the following BCIT online bookstores. Please choose the bookstore appropriate for the offering you are considering.
BCIT Downtown Campus Bookstore
If you are taking this course at the BCIT Downtown Campus (DTC), please purchase books for this course at the BCIT Downtown Campus Bookstore.
| Data Warehouse Toolkit | |
|---|---|
| Author | Kimball |
| Publisher | Wiley |
| Copyright | 2013 |
| Binding | Paperback |
| ISBN | 978-1-11853-080-1 |
| Price | $78.95 |
| Required | |
Winter 2021
No information on books is currently available for Winter 2021 offerings of this course.
Contact Us
If you have a comment or question about this course, please complete and submit the form below.
Subscribe
Interested in being notified about future offerings of COMP 3838 - Data Warehouse Foundations for Business Intelligence? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.