Skip to main content

SQL Server Reporting Services, SSRS for Business Intelligence COMP 4679

Computer Systems Part-time Studies Course

Course details

​This hands-on course follows on from COMP 1630. Students who already understand relational database design, SQL programming are introduced to SQL Server Reporting Services SSRS. Students must provide their own current model Windows capable PC, i5 or higher equivalent processor, 8 GB of RAM minimum, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. Please note: BCIT does not provide technical support for student's hardware or operating systems. COMP 4679 topics include how to install, configure and manage SSRS; author reports using SQL Server Data Tools (SSDT), and apply multiple levels of report security. Students receive a brief overview of Microsoft SQL Server Analysis Services which provides additional BI concepts. Labs and exercises show how to use SSRS to extract the data from its multiple collections of applications and data sources, how to deliver and manage reports, to integrate SSRS reports. Participants explore business intelligence platforms and apply best practices to author, deploy and manage reports with SSRS. COMP 4679 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/PTS Diploma. 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. Students should also plan for 9+ hours reading and homework each week. Upon successful completion of COMP 4679 students will be able to use SSRS to deploy a Reporting Services database, they will be able to extract data from multiple data sources and integrate traditional and interactive SSRS reports. Please note: COMP 4679 will be offered in the Spring (April) and Fall (September) terms.

Prerequisite(s)

Credits

4.0

Cost

$707.62

Course offerings

Fall 2022

Below is one offering of COMP 4679 for the Fall 2022 term.

CRN 35618

Duration

Tue Sep 13 - Tue Nov 29 (12 weeks)

  • 12 weeks
  • CRN 35618
  • $707.62
Class meeting times
Dates Days Times Locations
Sep 13 - Nov 29 Tue 18:00 - 21:00 Online
Sep 13 - Nov 29 N/A N/A Online
Instructor

Marin Kostadinovic

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$707.62

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. Please email cstpts@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. Reading, homework and assignments may require 6+ hours per week outside of class. The typical total commitment for this course is 10 + hours each week. Late registration is not permitted.
Status

Learning Outcomes

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

  • Explore Business Intelligence Platforms.
  • Install and configure SSRS.
  • Describe the architecture of SSRS.
  • Incorporate Business Intelligence through SSRS.
  • Connect to various data sources.
  • Describe the typical data warehouse lifecycle.
  • Differentiate between relational database and data warehouse modeling concepts, including star and snowflake schemas.
  • Determine ETL and Data Quality role and considerations.
  • Connect to various data sources.
  • Design reports using SQL Server Data Tools, SSDT.
  • Customize reports, enabling Write-back and Drill-through.
  • Utilize the report builder for user ad hoc reporting.
  • Render, manage, publish, automate and deploy reports in multiple formats, with multiple levels of security.

Effective as of Spring/Summer 2021

Related Programs

SQL Server Reporting Services, SSRS for Business Intelligence (COMP 4679) 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 SQL Server Reporting Services, SSRS for Business Intelligence (COMP 4679)? 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.