Course Overview
Insight without relevance is meaningless in Business Analytics. Relevance comes from a deep understanding of the data and the methods used to store and access it. This course enables students to perform complex tasks associated with data in the business environment, from storage to access. Using current Business Analytics database technologies, students will explore the different storage systems and constructs, the use of analytics structures to define data models, and the tools used to perform ETL (Extract, Transform, Load) operations on existing datasets to support Business Analytics. An integral part of the course will be a project in which students will build and demonstrate a fully integrated analytical model—from entering data into an existing Relational Database Management System (RDBMS) and using ETL tools to get relevant data into the analytical model, to running analytical queries on the data to provide meaningful insight for business stakeholders.
Prerequisite(s)
Credits
3.0
- Not offered this term
- This course is not offered this term. Notify me to receive email notifications when the course opens for registration next term.
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Explain how analytical models are designed.
- Create and populate an analytics model using ETL tools to move data between systems.
- Design different data models to store analytical data.
- Use one or more analytics tools to query data.
- Select and guide the development of databases and data sources to meet different business needs within the framework of data governance and ethical business standards.
- Generate key metrics and indicators based on an analysis of available data.
- Generate key metrics and indicators based on an analysis of available data.
Effective as of Fall 2026
Related Programs
Utilizing Data Structures for Business Analytics (BABI 9020) is offered as a part of the following programs:
- Indicates programs accepting international students.
School of Business + Media
- Business Analytics
Graduate Certificate Full-time
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.