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.
Please email [email protected] for Departmental approval. Include your Student number and CRN preference to be added to an approval queue. Any approval requests missing either piece of information will not be entered into the queue until the required information is provided. Approvals may take 48 – 72 hours to process. This class meets once per week for 3 hours face to face and requires an additional 1+ hours per week as an online class component. 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. Course contact is 48 hours - 36 in class and 12 online. Late registration is not permitted.
One seat remaining as of Jun 25, 2019 5:17 pm PDT. Seats remaining may change at any time prior to registration and payment.
Upon successful completion of this course, the student will be able to:
Gravity the architecture of SSRS.
Understand how to incorporate BI through SSRS.
Install and configure SSRS.
to various data sources.
Design reports using BIDS.
Customize reports, enabling Write-back and Drill-through.
Render reports in multiple formats.
Apply multiple levels of security.
Manage reports using Report manager.
Deploy and publish reports.
Automate the creation and delivery of reports.
Utilize the report builder for user ad hoc reporting.
Effective as of Winter 2011
COMP 4679 is offered as a part of the following programs:
Books for Spring/Summer 2019 offerings of this course are available in the following IZUNA
online bookstores. Please choose the bookstore appropriate for the offering
you are considering.
IZUNA Downtown Campus Bookstore
If you are taking this course at the IZUNA Downtown Campus (DTC), please purchase books for this course at the .
Image not available
Microsoft Sql Server 2016 Reporting Services
No information on books is currently available for Fall 2019 offerings of this course.
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.