Skip to main content

MS SQL Server Business Intelligence Tools COMP 3679

Computer Systems Course

International Fees

International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.

Course details

​This hands-on course has replaced COMP 4679 and​ follows on from COMP 1630 and COMP 2156. 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, then MS SQL Server Analysis Services (SSAS) is discussed to provide additional BI concepts. 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 MS Power BI on Azure. COMP 3679 topics include BI platforms, the Data Warehouse (DW) Lifecycle and data modelling concepts with Star, and Snowflake schemas and using Azure Data on the cloud. MS Azure data analytics concepts will be discussed. Labs and exercises show how to use Azure tools to extract the data from its multiple collections of data sources. Power BI Report Server (PBIRS) will also be discussed to show analysts and developers how to use various reporting options in a unified approach for on-premises installations. There will be a focus on best practices to implement data pipelines and data loading using Azure Data Factory (ADF) and Azure SQL. 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 extract data from multiple sources, apply best practices to author, deploy and manage significant Business Intellgience reports integrated with MS PowerBI. This course will be offered starting April 2024.​

Prerequisite(s)

Credits

4.0

Domestic fees

$582.30 - $609.41 See individual course offerings below for actual costs.

Course offerings

Winter 2024

Below is one offering of COMP 3679 for the Winter 2024 term.

CRN 91640

Duration

Tue Jan 09 - Tue Mar 26 (12 weeks)

  • 12 weeks
  • CRN 91640
  • Domestic fees $609.41
    International fees are typically three times the amount of domestic fees.
Class meeting times
Dates Days Times Locations
Jan 09 - Mar 26 Tue 18:00 - 21:00 Downtown DTC
Jan 09 - Mar 26 N/A N/A Online
Instructor

TBD

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Domestic fees

$609.41

Important information
  1. Departmental approval needed
  2. International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
  3. 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 on campus and 12 hours asynchronous activities/labs. The class meets once per week for 3 hours on campus and requires an additional 1 hour per week asynchronously. Participation online via the BCIT Learning Hub and attendance are mandatory during scheduled class hours plus online activities for a minimum of 4 hours per week. Most students should also plan for 9+ hours reading and homework each week, for a total commitment of 13 hours per week. With class time, this course is a total time commitment of 150 hours. Some students may need to spend more time on homework and assignments. Late registration is not permitted.
Status

Cancelled

This course offering has been cancelled. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.

Spring/Summer 2024

Below is one offering of COMP 3679 for the Spring/Summer 2024 term.

CRN 69293

Duration

Fri May 10 - Fri Jul 26 (12 weeks)

  • 12 weeks
  • CRN 69293
  • Domestic fees $582.30
    International fees are typically three times the amount of domestic fees.
Class meeting times
Dates Days Times Locations
May 10 - Jul 26 Fri 18:00 - 21:00 Online
May 10 - Jul 26 N/A N/A Online
Instructor

Saber Talazadeh

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Domestic fees

$582.30

Important information
  1. Internet delivery format.
  2. Departmental approval needed
  3. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
  4. International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
  5. 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. Participation online via the BCIT Learning Hub and attendance are mandatory during scheduled class hours plus online activities for a minimum of 4 hours per week. Most students should also plan for 9+ hours reading and homework each week, for a total commitment of 13 hours per week. With class time, this course is a total time commitment of 150 hours. Some students may need to spend more time on homework and assignments. Late registration is not permitted.
Status

Learning Outcomes

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

  • Describe Business Intelligence (BI) Platforms.
  • Describe the typical data warehouse lifecycle.
  • Design Dimensions and Measures for data warehouse.
  • Determine relational database and data warehouse modeling concepts, including Star and Snowflake schemas.
  • Describe Azure cloud computing basics and Azure data.
  • Define Azure data analytic concepts.
  • Describe Azure ecosystem including Azure SQL Reporting.
  • Design, implement and manage data pipelines using Azure Data Factory (ADF) and Azure SQL.
  • Install and configure Power BI Report Server (PBIRS).
  • Serve data from Azure data service to Power BI.
  • Design an effective and scalable data models in Power BI.
  • Implement Power BI integration with MS Azure.
  • Design Online Analytical Processing (OLAP) using Azure Analysis Services.
  • Maintain an Analysis Services database on MS Azure.​

Effective as of Fall 2023

Related Programs

MS SQL Server Business Intelligence Tools (COMP 3679) is offered as a part of the following programs:

School of Computing and Academic Studies

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

Contact Us

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

  • Privacy Notice: The information you provide will be used to respond to your request for BCIT program information and is collected under Section 26(c) of the Freedom of Information and Protection of Privacy Act (FIPPA). For more information about BCIT’s privacy practices contact: Associate Director, Privacy, Information Access & Policy Management, British Columbia Institute of Technology, 3700 Willingdon Ave. Burnaby, BC V5G 3H2, email: privacy@bcit.ca.
  • This field is for validation purposes and should be left unchanged.

Subscribe

Interested in being notified about future offerings of MS SQL Server Business Intelligence Tools (COMP 3679)? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.

  • Privacy Notice: The information you provide will be used to respond your request for BCIT course information and is collected under Section 26(c) of the Freedom of Information and Protection of Privacy Act (FIPPA). For more information about BCIT’s privacy practices contact: Associate Director, Privacy, Information Access & Policy Management, British Columbia Institute of Technology, 3700 Willingdon Ave. Burnaby, BC V5A 3H2, email: privacy@bcit.ca.