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.
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:
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.