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)
- 60% in COMP 1630
Credits
1.5
Cost
$369.21 - $399.54 See individual course offerings below for actual costs.
Course offerings
Winter 2023
Below are two offerings of COMP 3841 for the Winter 2023 term.
CRN 89512
Duration
Mon Jan 09 - Mon Feb 13 (6 weeks)
- 6 weeks
- CRN 89512
- $399.54
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
Jan 09 - Feb 13 | Mon | 18:30 - 21:30 | Burnaby |
Instructor
TBD
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Cost
$399.54
Important information
- Departmental approval needed
-
Please email cstpts@bcit.ca for Departmental approval. Include your Student number (A0#) and COMP__ and preferred CRN __ and Program Declaration____. Course is 18 hours on campus. Late registration is not permitted.
Status
Cancelled
This course offering has been cancelled. Please check back next term, subscribe to receive email updates or contact us with your comments or questions.
CRN 89513
Duration
Mon Feb 27 - Mon Apr 03 (6 weeks)
- 6 weeks
- CRN 89513
- $369.21
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
Feb 27 - Apr 03 | Mon | 18:00 - 21:00 | Online |
Instructor
Ife Agboola
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Cost
$369.21
Important information
- Internet delivery format.
- Departmental approval needed
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
-
Please email cstpts@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
Full
This course offering is full. Please check back next term, subscribe to receive email updates or contact us with your comments or questions.
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:
School of Computing and Academic Studies
- Applied Data Analytics
Certificate Part-time
- Computer Systems
Diploma Part-time
Contact Us
If you have a question or comment about this course, please complete and submit the form below.
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.
Programs and courses are subject to change without notice.