Course Overview
This hands-on course follows on from COMP 1630 and COMP 2156 or COMP 2456. Participants must already understand relational database design, data modeling, SQL programming, and the basics of MS PowerBI. COMP 3679 begins with an overview of Business Intelligence (BI) tools and MS Azure data analytics concepts and may be taken concurrently with COMP 2453 Introduction to Microsoft Fabric. Students are introduced to cloud computing using Microsoft Azure Cloud Services and explore business intelligence platforms. They review best practices to author, deploy and manage reports using Power BI on Azure. Labs and exercises show how to use Azure tools to extract the data from its multiple data pipelines. MS SQL Server Analysis Services (SSAS) is used to provide additional BI concepts. COMP 3679 topics include BI platforms, the Data Warehouse (DW) Lifecycle and data modelling concepts. Star, Snowflake schemas and using Azure Data on the cloud are discussed. There will be a focus on best practices to implement data pipelines and data loading using Azure Data Factory (ADF) and Azure SQL. Various reporting options will be discussed, students will author, deploy, and manage significant BI reports. They will extract data from multiple sources, integrated with MS PowerBI. COMP 3679 is an elective in the Applied Database Administration and Design (ADAD) Associate Certificate; the Applied Data Analytics Certificate (ADAC) and the Computer Systems Technology (CST FLEX) Diploma. Upon successful completion, students will be able to use components of the Azure ecosystem to design and optimize Azure data solutions for data analysts and developers.
Prerequisite(s)
Credits
4.0
Registration requirements
Departmental approval is required to register for this course. You must have approval from the department to register. Students accepted into a program can register directly.
Domestic fees
$606.84
International fees are typically 3.4 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Discuss Business Intelligence (BI) platforms including Microsoft Fabric and Lakehouse.
- Describe the typical and modern data warehouse lifecycle.
- Design Dimensions and Measures for data warehouse.
- Review relational database and data warehouse modeling concepts, including Star and Snowflake schemas.
- Describe Azure cloud computing basics and MS Azure data.
- Define Azure data analytics concepts including Fabric, OneLake, Lakehouse and Managed self-service BI.
- Explain the MS Azure ecosystem including SQL Azure Reporting.
- Design, implement and manage data pipelines with Azure Data Factory (ADF) and Azure SQL.
- Integrate PowerBI with MS Azure Services and Fabric data sources
- Design effective, and scalable data models in MS PowerBI.
- Extract data from multiple sources, integrated with MS PowerBI
- Implement MS Power BI integration with MS Azure.
- Design and optimize MS Azure data solutions.
Effective as of Fall 2026
Related Programs
MS Azure and SQL Analytics Tools (COMP 3679) is offered as a part of the following programs:
- Indicates programs accepting international students.
- Indicates programs eligible for students to apply for Post-graduation Work Permit (PGWP).
School of Computing and Academic Studies
- Applied Data Analytics
Certificate Part-time
- Applied Database Administration and Design
Associate Certificate Part-time
- Computer Systems
Diploma Part-time
Course Offerings
Fall 2026
Below is one offering of COMP 3679 for the Fall 2026 term.
CRN 51086
Dates
Sep 12 - Nov 28 Loading
- CRN 51086
- $606.84 Domestic fees
Class meeting times
Duration
12 weeks
Instructor
Saber Talazadeh
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Important information
- 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 cstflex@bcit.ca for Departmental approval. Include your Student number (A0#) and COMP__ and preferred CRN __ and Program Declaration____. Course is 48 hours - 36 hours synchronous online classes and 12 hours asynchronous activities/labs. This class meets once per week for 3 hours online and requires an additional 1 hour per week asynchronously. Please Note: Attendance, participation in class and the BCIT Learning Hub are mandatory. You should prepare to spend 2-3 hours on homework for every 1 hour of class time. Depending on the student, this course may require an average total time commitment of 13-16+ hours per week; 3 hours of synchronous class, 1-hour asynchronous time plus 9-12+ hours per week for homework. Late registration is not permitted. BCIT Computing is primarily a Microsoft Windows environment. Students must provide their own current model Windows-compatible PC with microphone and video camera. i5 or higher equivalent processor, with 8 GB of RAM minimum, and 256 GB minimum storage. Highspeed internet access is needed for online sections and for homework. Mac users must have the ability to manage and support their iOS computer. They may need to create a virtual Windows environment using Parallels or VMWare Fusion. COMP instructors may not be able to assist Mac users with software compatibility issues. BCIT does not provide access to Parallels or support for students to use a Mac to run Windows. Students will be provided with a limited amount of server and data access outside of class each week for the course duration. Class in session October 10 (Thanksgiving).
Confirmation
Required
To proceed with registration and add this course to the cart, please confirm:
No approval yet? Request approval You must have approval from the department to register. Students accepted into a program can register directly.
Status
If you have any questions about this course, please contact us.
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.