This hands-on course follows on from COMP 1630 and COMP 3838. Students who already understand relational database design, SQL programming and data warehouse foundations are introduced to SSIS. COMP 4681 is a blended BYOD course, participants must provide their own Windows 10 dual core laptop with a minimum of 8GB RAM to participate in this course. Please note: BCIT does not provide technical support for student's hardware or operating systems. Topics include: how to install, configure and manage SSAS; designing multidimensional Business Intelligence Semantic Model (BISM), accessing different data sources, creating multidimensional databases, data mining, interacting with cube data using Multidimensional Expressions (MDX) queries from MS Excel. Labs and exercises show how to use SSAS to design, create and manage multidimensional structures containing data from other sources. Participants are shown how to create and maintain an Analysis Services database. MS Excel and MS SQL Reporting Services are used to present data from SSAS. COMP 4681 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. Please note: COMP 4681 will be offered in the winter (January) and fall (September) terms. Upon successful completion of COMP 4681 students will be able to use SSAS to deploy an Analysis Services database with multiple levels of security for data mining, they will be able to extract data from collections of multiple data sources and applications.
Below is one offering of this course for the Fall 2020 term.
Wed Sep 16 - Wed Dec 02 12 Weeks
|Sep 16 - Dec 02||Wed||18:00 - 21:00||DTC Online Delivery|
|Sep 16 - Dec 02||Online Online Delivery|
Below is one offering of this course for the Winter 2021 term.
Wed Jan 13 - Wed Mar 31 12 Weeks
|Jan 13 - Mar 31||Wed||18:00 - 21:00||
See Notes below
|Jan 13 - Mar 31||
See Notes below
TBD – see Learning Outcomes in the interim
Upon successful completion of this course, the student will be able to:
Effective as of Winter 2021
COMP 4681 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 4681 - SQL Server Analysis Services, SSAS for Business Intelligence? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.