CRN 41060
Duration
Sun Nov 18 - Sun Nov 25 2 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Nov 18 - Nov 25 | Sun | 09:00 - 16:00 | DTC Rm. 370 |
Instructor
Donabel Santos
Course Outline
TBD – see Learning Outcomes in the interim
Cost
$236.00
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.
COMP 1630 or equivalent knowledge of data modeling and SQL.
1.0
$236.00
Below are two offerings of this course for the Fall 2018 term.
Sun Nov 18 - Sun Nov 25 2 Weeks
| Dates | Days | Times | Locations |
| Nov 18 - Nov 25 | Sun | 09:00 - 16:00 | DTC Rm. 370 |
Donabel Santos
TBD – see Learning Outcomes in the interim
$236.00
Sun Sep 23 - Sun Sep 30 2 Weeks
| Dates | Days | Times | Locations |
| Sep 23 - Sep 30 | Sun | 09:00 - 16:00 | DTC Rm. 370 |
Donabel Santos
TBD – see Learning Outcomes in the interim
$236.00
This course offering is full. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.
Full
Upon successful completion of this course, the student will be able to:
Effective as of Winter 2014
COMP 3838 is offered as a part of the following programs:
The BCIT bookstore carries textbooks, general reference books, software, and stationery. Please visit bcit.ca/bookstore for more information.
Books for Fall 2018 offerings of this course are available in the following BCIT online bookstores. Please choose the bookstore appropriate for the offering you are considering.
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 | $60.50 |
| Optional | |
If you have a comment or question about this course, please complete and submit the form below.
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.