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.
Books for Spring/Summer 2019 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
Agile Data Warehouse Design
Author
Corr
Copyright
2011
Binding
Paperback
ISBN
978-0-95681-720-4
Price
$57.50
Optional
Data Warehouse Lifecycle Toolkit
Author
Kimball
Publisher
Wiley
Copyright
2008
Binding
Paperback
ISBN
978-0-47014-977-5
Price
$65.95
Optional
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.
Registration is currently open for the Spring/Summer 2019 term.
The sneak preview for the Fall 2019 term starts Fri, May 24 at 8:30 am (PDT).
Students may register for Fall 2019 term courses online, by phone, mail or
in-person starting Wed, May 29 at 9:00 am (PDT).
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.
