Following on from COMP 1630 and COMP 3838, this course is for students who already understand relational database design, data modelling, SQL programming and data warehouse foundations for business intelligence. Participants are provided with an in-depth understanding of authoring, managing and delivering traditional and interactive reports using Microsoft SQL Server 2016 Reporting Services (SSRS). 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 an overview of Microsoft SQL Server 2016 Analysis and Integration Services, which provides additional business intelligence architecture concepts and some preparation towards the Microsoft certification exams. Successful participants will learn to extract the data from its multiple collections of applications and data sources, how to deliver and manage reports, to integrate SSRS reports and apply best practices for reports authoring, deployment and management. Please note: COMP 4679 will be offered in the Spring (April) and Fall (September) terms.
Below is one offering of this course for the Fall 2020 term.
Tue Sep 15 - Tue Dec 01 12 Weeks
|Sep 15 - Dec 01||Tue||18:00 - 21:00||DTC Online Delivery|
|Sep 15 - Dec 01||Online Online Delivery|
Upon successful completion of this course, the student will be able to:
Effective as of Winter 2011
COMP 4679 is offered as a part of the following programs:
The BCIT bookstore carries textbooks, general reference books, software, and stationery. Please visit bcit.ca/bookstore for more information.
Books for Fall 2020 offerings of this course are available in the following BCIT online bookstores. Please choose the bookstore appropriate for the offering you are considering.
If you are taking this course at the BCIT Downtown Campus (DTC), please purchase books for this course at the BCIT Downtown Campus Bookstore.
|Microsoft Sql Server 2016 Reporting Services|
If you have a comment or question about this course, please complete and submit the form below.
Interested in being notified about future offerings of COMP 4679 - Business Intelligence with SSRS, SQL Server Reporting Services? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.