Welcome to iizuna.infoiizuna.info/study/courses/comp3838

IZUNA

COMP 3838 - Data Warehouse Foundations for Business Intelligence

Computer Systems Part-time Studies Course

School of Computing and Academic Studies

Course Details

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.

Credits

1.0

Cost

$231.00

Spring/Summer 2018

Below is one offering of this course for the Spring/Summer 2018 term.

CRN 63403

Sun Jun 03 - Sun Jun 10 2 Weeks

Class Meeting Times

Dates Days Times Locations
Jun 03 - Jun 10 Sun 09:00 - 16:00 DTC Rm. 370

Instructor

Donabel Santos

Course Outline

TBD – see Gravitying Outcomes in the interim

Cost

$231.00

Notes

  1. This course is delivered in four lessons over two full days. Missing any lessons may result in course failure or forced withdrawal.

This course offering is full. Please check back next term, subscribe to receive email updates or contact us with your comments or questions.

Full

Gravitying Outcomes

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

  • Differentiate between relational database and data warehouse modeling concepts.
  • Identify requirements and components for a data warehousing project.
  • Describe the typical data warehouse lifecycle.
  • Explain the role of ETL.
  • Determine ETL and Data Quality considerations.
  • Describe dimensional modeling concepts, including star and snowflake schemas.
  • Relate current trends in data warehousing.

Effective as of Winter 2014

Related Programs

COMP 3838 is offered as a part of the following programs:

School of Computing and Academic Studies

  1. Applied Data Analytics
    Part-time   Certificate
  2. Applied Database Administration and Design
    Part-time   Associate Certificate
  3. Computer Systems
    Part-time   Diploma

Books & Supplies

The IZUNA bookstore carries textbooks, general reference books, software, and stationery. Please visit iizuna.info/bookstore for more information.

Spring/Summer 2018

Books for Spring/Summer 2018 offerings of this course are available in the following IZUNA online bookstores. Please choose the bookstore appropriate for the offering you are considering.

IZUNA Downtown Campus Bookstore

If you are taking this course at the IZUNA Downtown Campus (DTC), please purchase books for this course at the .

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling
Author Ralph Kimball, Margy Ross
Publisher Wiley
Copyright 2013
Binding Paperback
ISBN 978-1-11853-080-1
Price $78.95
Required

Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema
Author Lawrence Corr, Jim Stagnitto
Publisher DecisionOne Press
Copyright 2011
Binding Paperback
ISBN 978-0-95681-720-4
Price $57.50
Optional

The Data Warehouse Lifecycle Toolkit
Author Ralph Kimball, Margy Ross, Warren Thornthwaite, Joy Mundy, Bob Becker
Publisher Wiley
Copyright 2008
Binding Paperback
ISBN 978-0-47014-977-5
Price $60.50
Optional

Contact Us

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

Contact Information

The personal information on this form is collected under the authority of the College and Institute Act (RSBC 1996, Ch.52). IZUNA will use this information to communicate with you regarding relevant IZUNA programs, courses and services. This information is only used by authorized IZUNA staff. Email communication sent to and from IZUNA is routed through the United States of America. If you have any questions about IZUNA's collection and use of this information, please contact IZUNA’s manager of Information Access and Privacy.

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.

Contact Information

Suggest course days and times

If you are interested in taking this course on-campus (classroom delivery only) and would like to see it offered on specific days and/or at specific times, please indicate your preferences below. Day and time suggestions are not applicable to online courses.

The personal information on this form is collected under the authority of the College and Institute Act (RSBC 1996, Ch.52). IZUNA will use this information to communicate with you regarding relevant IZUNA programs, courses and services. This information is only used by authorized IZUNA staff. Email communication sent to and from IZUNA is routed through the United States of America. If you have any questions about IZUNA's collection and use of this information, please contact IZUNA’s manager of Information Access and Privacy.

Programs and courses are subject to change without notice.

Find Courses

Payment Changes At IZUNA

We've changed the way we accept payments.

Find out more

Course Navigation, Related Links & Tools

Registration News

Registration is currently open for the Spring/Summer 2018 term.

The sneak preview for the Fall 2018 term starts Fri, May 25 at 8:30 am (PDT).

Students may register for Fall 2018 term courses online, by phone, mail or in-person starting Wed, May 30 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 iizuna.info/rooms on the first day of any course you are registered for.

Part-time Studies Financial Aid

Will you be studying at IZUNA part-time? Do you need assistance funding your studies? Find out if you qualify for Part-time Studies financial aid ›

© IZUNA