British Columbia Institute of Technologywww.bcit.ca/study/courses/comp3838

Important Notice: COVID-19 Institute response

BCIT

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

Spring/Summer 2021

Below are two offerings of this course for the Spring/Summer 2021 term.

CRN 62416

Sun Apr 18 - Sun May 02 2 Weeks

Class Meeting Times

Dates Days Times Locations
Apr 18 - May 02 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

  1. Departmental approval needed
  2. Please email cstpts@bcit.ca for Departmental approval. Include your Student number (A0#) and COMP__ and preferred CRN __ and Program Declaration____. Course is 12 hours synchronous remote classes. This course is delivered in four lessons over two full days. Missing any lessons may result in course failure or forced withdrawal. Please sign in to the Learning Hub (learn.bcit.ca) on the course start date and time (not before) for details on how the course will be delivered online. Late registration is not permitted. No class on April 25.

A portion of seats are temporarily held for domestic students. International students: this may impact your ability to register. Learn why.

}

9 seats available as of Feb 25, 2021 11:48 pm (PST). Of these 9, 3 are currently reserved for domestic students only. Availability may change at any time.

CRN 63403

Sun Jun 13 - Sun Jun 27 2 Weeks

Class Meeting Times

Dates Days Times Locations
Jun 13 - Jun 27 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

  1. Departmental approval needed
  2. Please email cstpts@bcit.ca for Departmental approval. Include your Student number (A0#) and COMP__ and preferred CRN __ and Program Declaration____. Course is 12 hours synchronous remote classes. This course is delivered in four lessons over two full days. Missing any lessons may result in course failure or forced withdrawal. Please sign in to the Learning Hub (learn.bcit.ca) on the course start date and time (not before) for details on how the course will be delivered online. Late registration is not permitted. No class on June 20.

A portion of seats are temporarily held for domestic students. International students: this may impact your ability to register. Learn why.

}

17 seats available as of Feb 25, 2021 11:48 pm (PST). Of these 17, 11 are currently reserved for domestic students only. Availability may change at any time.

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

  1. Applied Data Analytics
    Part-time   Certificate
  2. Applied Database Administration and Design
    Part-time   Associate Certificate
  3. 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.

Spring/Summer 2021

No information on books is currently available for Spring/Summer 2021 offerings of this course.

Contact Us

If you have a comment or question about this course, please complete and submit the form below.

Contact Information

The personal information on this form is collected under the authority of the College and Institute Act (RSBC 1996, Ch.52). BCIT will use this information to communicate with you regarding relevant BCIT programs, courses and services. This information is only used by authorized BCIT staff. Email communication sent to and from BCIT is routed through the United States of America. If you have any questions about BCIT's collection and use of this information, please contact BCIT’s manager of Information Access and Privacy.

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.

Privacy Notice: The information you provide will be used to respond your request related to BCIT course information and is collected under Section 26(c) of the Freedom of Information and Protection of Privacy Act (FIPPA). For more information about BCIT’s privacy practices contact: Associate Director, Privacy, Information Access & Policy Management, British Columbia Institute of Technology, 3700 Willingdon Ave. Burnaby, BC V5A 3H2, email: privacy@bcit.ca.

Programs and courses are subject to change without notice.

Find Courses

English Language Proficiency

BCIT's Part-time Studies English Language Proficiency Standard is English 12 (or equivalency). Students who do not meet this requirement should upgrade their English skills prior to any future registration.

Payment Changes At BCIT

We've changed the way we accept payments.

Find out more

Course Navigation, Related Links & Tools

Registration News

Registration is now open for the Spring/Summer 2021 term.

Classroom Locations

Classroom locations are subject to last minute changes. Please check the Part-time Studies Classroom Locations listing at www.bcit.ca/rooms on the first day of any course you are registered for.

Part-time Studies Financial Aid

Will you be studying at BCIT part-time? Do you need assistance funding your studies? Find out if you qualify for Part-time Studies financial aid.

© BCIT