Skip to main content

Introduction to Data Warehouses with Big Data COMP 3841

Computer Systems Course

International Fees

International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.

Course details

​Continuing on from COMP 1630, this hands-on course is a primer for data warehouse and data analytics with Big Data. Students must already understand industry standards in data modelling, relational database design and creating reports with SQL. Participants must provide their own current model Windows capable PC, i5 or higher equivalent processor, 8 GB of RAM minimum, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. Labs and assignments use a web browser to access course content. Exercises focus on data ingestion, data extraction, data transformation, accessing/querying data, and data visualization. Students will use a variety of technologies and will learn about different big data systems including AWS Academy Data Analytics. Students conduct a big data analysis with practical, real-world examples and focus on how to analyze vast data sets using a case-study approach. Topics include an overview of different data stores, querying data with visualizations, and a deep-dive of Extract, Transform and Load (ETL) process in the data warehouse. BCIT Computing is an AWS Academy partner; A discount voucher for the AWS Certified Data Analytics–Specialty exam will be provided to those who pass this course. Upon completion, successful students will be able to leverage, and maintain a large-scale data warehouse for Business Intelligence.

Prerequisite(s)

Credits

1.5

Domestic fees

$389.41 - $397.39 See individual course offerings below for actual costs.

Course offerings

Spring/Summer 2024

Below is one offering of COMP 3841 for the Spring/Summer 2024 term.

CRN 68024

Duration

Wed May 22 - Wed Jun 26 (6 weeks)

  • 6 weeks
  • CRN 68024
  • Domestic fees $389.41
    International fees are typically 3.12 times the domestic tuition.
Class meeting times
Dates Days Times Locations
May 22 - Jun 26 Wed 18:00 - 21:00 Online
Instructor

Justine Fox

Course outline

View

Domestic fees

$389.41

Important information
  1. Internet delivery format.
  2. Departmental approval needed
  3. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
  4. International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
  5. 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 synchronous online classes. Late registration is not permitted.
Status

Seats Available

2 seats remaining as of Sun May 19, 2024 at 6:35 am (PDT). Availability may change at any time.

Fall 2024

Below is one offering of COMP 3841 for the Fall 2024 term.

CRN 48565

Duration

Wed Sep 11 - Wed Oct 16 (6 weeks)

  • 6 weeks
  • CRN 48565
  • Domestic fees $397.39
    International fees are typically 3.12 times the domestic tuition.
Class meeting times
Dates Days Times Locations
Sep 11 - Oct 16 Wed 18:00 - 21:00 Online
Instructor

Justine Fox

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Domestic fees

$397.39

Important information
  1. Internet delivery format.
  2. Departmental approval needed
  3. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
  4. International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
  5. 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 synchronous online classes. BCIT Computing is primarily a Microsoft Windows environment. Students must provide their own current model Windows-compatible PC. 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.
Status

Sneak Preview

This section is only available for registration starting Wed May 22, 2024 at 9:00 am (PDT)

Learning Outcomes

Upon successful completion of this course, the student will be able to:

  • Describe big data analytical concepts.
  • Ingest, store, and secure data.
  • Query data stores with manual and automatic schema detection.
  • Automate loading data into a data warehouse.
  • Load and query data in a data warehouse.
  • Visualize structured and unstructured data.

Effective as of Fall 2021

Related Programs

Introduction to Data Warehouses with Big Data (COMP 3841) is offered as a part of the following programs:

  • Indicates programs accepting international students.
  • Indicates programs with a co-op option.

School of Computing and Academic Studies

  1. Applied Data Analytics
    Certificate Part-time
  2. Computer Systems
    Diploma Part-time

Contact Us

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

  • Privacy Notice: The information you provide will be used to respond to your request for BCIT program 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 V5G 3H2, email: privacy@bcit.ca.
  • This field is for validation purposes and should be left unchanged.

Subscribe

Interested in being notified about future offerings of Introduction to Data Warehouses with Big Data (COMP 3841)? 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 for 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.