Course Overview
Continuing from COMP 1630, this hands-on course introduces cloud data warehousing and big data analytics. Students are expected to understand industry standards in data modelling, relational database design, SQL, and report creation. COMP 3841 uses practical, real-world case studies to show how data warehouses support business intelligence through big data analysis. Participants explore big data systems and learn how large-scale data sets are populated, queried, analyzed, and visualized. Topics include data stores, visualization-based querying, Extract, Transform, Load (ETL) processes, for modern data warehousing practices. Data lake architectures, and dimensional modelling concepts such as star and snowflake schemas are also discussed. Exercises focus on data ingestion, extraction, transformation, querying, and visualization using contemporary cloud analytics tools. COMP 3841 may be taken in the same term or concurrently with COMP 3839 - Data Quality Improvement. Both courses are required in the Applied Data Analytics Certificate (ADAC) and may be taken as electives in the CST FLEX Diploma. Upon completion, successful students will be able to maintain large-scale data warehouses for business intelligence and use AI tools to query and visualize data.
Prerequisite(s)
- 60% in COMP 1630
Credits
1.5
Domestic fees
$433.92 - $448.89 See individual course offerings below for actual costs.
International fees are typically 3.4 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Describe big data and unstructured data concepts.
- Ingest, store, and secure data in a cloud-based data platform.
- Compare dimensional modeling concepts, including star and snowflake schemas.
- Describe and compare the Extract, Transform, Load (ETL) and Extract, Load, Transform (ELT) processes used in modern data warehousing and data lakehouse architectures.
- Automate loading data in a data warehouse.
- Use AI tools for querying and visualizing the data.
Effective as of Winter 2027
Related Programs
Introduction to Cloud Data Warehousing (COMP 3841) is offered as a part of the following programs:
- Indicates programs accepting international students.
- Indicates programs eligible for students to apply for Post-graduation Work Permit (PGWP).
School of Computing and Academic Studies
- Applied Data Analytics
Certificate Part-time
- Computer Systems
Diploma Part-time
Course Offerings
Fall 2026
Below is one offering of COMP 3841 for the Fall 2026 term.
CRN 48566
Dates
Sep 12 - Oct 24 Loading
- CRN 48566
- $448.89 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Sep 12 - Oct 24 | Sat | 13:00 - 16:00 | Burnaby SE12 Rm. 320 |
Duration
6 weeks
Instructor
Mike Mulder
Course outline
Registration requirements
Departmental approval is required to register for this course offering. You must have approval from the department to register. Students accepted into a program can register directly.
Important information
- Please email cstflex@bcit.ca for Departmental approval. Include your Student number (A0#) and COMP__ and preferred CRN __ and Program Declaration____. Course is 18 hours on campus. BCIT Computing is primarily a Microsoft Windows environment. Students must provide their own current model Windows-compatible PC with microphone and video camera. i5 or higher equivalent processor, with 8 GB of RAM minimum, and 256 GB minimum storage. Highspeed internet access is needed for online sections and for homework. Mac users must have the ability to manage and support their iOS computer. They may need to create a virtual Windows environment using Parallels or VMWare Fusion. COMP instructors may not be able to assist Mac users with software compatibility issues. BCIT does not provide access to Parallels or support for students to use a Mac to run Windows. Late registration is not permitted. No class October 10 (Thanksgiving).
Confirmation
Required
To proceed with registration and add this course to the cart, please confirm:
No approval yet? Request approval You must have approval from the department to register. Students accepted into a program can register directly.
Status
If you have any questions about this course, please contact us.
Winter 2027
Below is one offering of COMP 3841 for the Winter 2027 term.
CRN 89512
Dates
Jan 09 - Feb 20 Loading
- CRN 89512
- $433.92 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Jan 09 - Feb 20 | Sat | 13:00 - 16:00 | Downtown DTC Rm. 371 |
Duration
6 weeks
Instructor
Mike Mulder
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Registration requirements
Departmental approval is required to register for this course offering. You must have approval from the department to register. Students accepted into a program can register directly.
Important information
- Course is 18 hours on campus. BCIT Computing is primarily a Microsoft Windows environment. Students must provide their own current model Windows-compatible PC with microphone and video camera. i5 or higher equivalent processor, with 8 GB of RAM minimum, and 256 GB minimum storage. Highspeed internet access is needed for online sections and for homework. Mac users must have the ability to manage and support their iOS computer. They may need to create a virtual Windows environment using Parallels or VMWare Fusion. COMP instructors may not be able to assist Mac users with software compatibility issues. BCIT does not provide access to Parallels or support for students to use a Mac to run Windows. Late registration is not permitted. No class February 13 (Family Day).
Confirmation
Required
To proceed with registration and add this course to the cart, please confirm:
No approval yet? Request approval You must have approval from the department to register. Students accepted into a program can register directly.
Status
If you have any questions about this course, please contact us.
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.