Business Intelligence System Infrastructure


Mobile DeviceBring Your Own Device (BYOD): As a student in this on-campus program, you will require a mobile computing device that meets the specifications outlined by your program at http://algonquincollege.com/byod
(Please note this was previously referred to as a Mobile Learning Program)

Ontario College Graduate Certificate
1 Year

Program Code: 1514X01FWO
Academic Year: 2014/2015


Our Program

This one-year Ontario College Graduate Certificate program prepares students for careers requiring specialized technical knowledge to support corporate use of Business Intelligence (BI). Students develop technical and team skills to work independently and collaboratively to collect, analyze, design, build, support, integrate and manage systems that assist business decision making through data analysis using IBM Cognos Enterprise software to access complex databases and data warehouses.

Students install, configure and troubleshoot BI platforms. Hands-on experience is provided in database design, database administration, operating systems fundamentals, networking essentials, and programming basics. Students research and evaluate current BI offerings and industry trends. In Level 01, labs focus on helping students understand and develop core competencies in the essential technologies utilized in delivering BI/BA solutions. The labs in Level 02 focus on assisting students to understand and develop hands-on experience using the designated IBM Cognos software. Examples of these lab activities include writing complex SQL aggregation queries, creating data warehouses, developing multidimensional models, creating metadata frameworks and provisioning a variety of reporting styles. Projects provide students with experiential learning opportunities where they are tasked to address real-world problem solving situations and delivering business responsive solutions within tight timelines utilizing an agile-inspired approach.

Students who maintain a College-prescribed academic standing and who possess the appropriate level of business communication skills may take part in a cooperative placement at the end of Level 02 for one 15-week paid work term.

Graduates may find employment in a broad spectrum of positions within private and public sector organizations, departments, branches or business units that recognize the value of timely analysis of enterprise-relevant data in driving operational effectiveness and efficiencies, influencing tactical direction and priorities and enabling strategic advantage or enhanced service delivery. These positions may include: BI requirement analysts, BI report authors, BI meta-data modellers, BI server administrators, data warehouse planners, and other related opportunities requiring a technical understanding of BI provisioning in order to deliver business reporting and planning solutions.

Bring Your Own Device (BYOD): Students are expected to have and use a laptop or mobile computing device when registered in this on-campus program. Hardware and software specifications required by your program are outlined at www.algonquincollege.com/byod. Mobile devices/laptops and supplies can be purchased directly from Algonquin's New Technology Store at educational rates. This requirement is crucial as students will use their mobile device to download, install, configure and use various enterprise-class software.

SUCCESS FACTORS
This program is well-suited for students who:

  • Are problem solvers and critical thinkers.
  • Are interested in working with integrated software to deliver and support business solutions.
  • Are able to effectively work independently with little supervision.
  • Are able to professionally collaborate and achieve team deliverables.
  • Are well-organized and effective time managers.
  • Are detail focused.
  • Are able to translate design models to implementation details.

Your Career

Graduates may find a variety of employment opportunities as BI specialists in IT technical support and customer service support. Training in database design and administration may also present job opportunities in those areas.

Employment may be found in organizations of all sizes in both the public and private sectors.

Depending on the previous education and experience of the students, graduates may be positioned to move into managerial or other positions of authority and/or responsibility overseeing or collaborating with technically aware professionals in a business solutions delivery environment.

Courses

Programs at Algonquin College are delivered using a variety of instruction modes. Courses may be offered in the classroom or lab, entirely online, or in a hybrid mode which combines classroom sessions with online learning activities. Upon registration, each full-time student is provided an Algonquin email account which is used to communicate important information about program or course events.
Level: 01 Hours
CST2100 In order to get the most out of business data, it is important to ask the right questions. Business principles and practices need to be placed in their operational context. Students examine legal, ethical and strategic uses of BI by businesses, to make sound decisions. Communications skills are refined to comprehend the client's requirements and provide guidance to appropriate solutions. In-class assignments and discussions along with case studies and group presentations explore how businesses use BI to gain competitive advantage in the marketplace. Predications of future applications are debated. Strategic Use of Business Intelligence In order to get the most out of business data, it is important to ask the right questions. Business principles and practices need to be placed in their operational context. Students examine legal, ethical and strategic uses of BI by businesses, to make sound decisions. Communications skills are refined to comprehend the client's requirements and provide guidance to appropriate solutions. In-class assignments and discussions along with case studies and group presentations explore how businesses use BI to gain competitive advantage in the marketplace. Predications of future applications are debated. 45.0
CST2101 Students learn to use problem-solving methodologies, critical thinking, and hands-on practice to support the design and development of correct computer programs to meet client requirements, using Java and Javascript. Basic programming constructs are implemented. Students also explore web-based applications. Business Intelligence Programming Students learn to use problem-solving methodologies, critical thinking, and hands-on practice to support the design and development of correct computer programs to meet client requirements, using Java and Javascript. Basic programming constructs are implemented. Students also explore web-based applications. 60.0
CST2102 Students develop knowledge of object-relational database management system software, relational database design including normalization, design implementation in an enterprise class dbms and writing SQL queries. This material positions the student to better understand software and models generated. Students install an enterprise version of a major dbms, such as Oracle, then create users, assign basic privileges, create tables, insert data, specify indexes and write basic to intermediate SQL queries. Students write queries involving inner and outer joins, aggregation, materialized views, Top-n results, subqueries, correlated subqueries, rollups, cubes, set operations, substitution variables and a variety of relevant functions (e.g., regression coefficients, string manipulation, output formatting, correct null value handling). Transaction control commands and triggers are introduced. Database Analytics Students develop knowledge of object-relational database management system software, relational database design including normalization, design implementation in an enterprise class dbms and writing SQL queries. This material positions the student to better understand software and models generated. Students install an enterprise version of a major dbms, such as Oracle, then create users, assign basic privileges, create tables, insert data, specify indexes and write basic to intermediate SQL queries. Students write queries involving inner and outer joins, aggregation, materialized views, Top-n results, subqueries, correlated subqueries, rollups, cubes, set operations, substitution variables and a variety of relevant functions (e.g., regression coefficients, string manipulation, output formatting, correct null value handling). Transaction control commands and triggers are introduced. 75.0
CST2103 Students learn the important concepts necessary to understand modern LAN and Internet networking with a particular focus on understanding the BI environment. Topics include a detailed study of the terminology and concepts related to the implementation, operation, basic structure and design of modern converged networks; layered communications models; IP addressing and subnetting, and industry network standards and protocols (with an emphasis on TCP/IP protocol suite and Ethernet). The use of common networking tools to diagnose and troubleshoot typical network problems is explored and practiced in a lab environment. The major components of a BI network are examined in depth from a networking perspective. Students practice and apply their networking skills and knowledge to the BI world in a lab environment by planning, implementing, deploying, testing and troubleshooting a network that incorporates the major BI components. Students are introduced to a structured approach to identifying and resolving network issues in a BI environment. Networking Strategies for Business Intelligence Platforms Students learn the important concepts necessary to understand modern LAN and Internet networking with a particular focus on understanding the BI environment. Topics include a detailed study of the terminology and concepts related to the implementation, operation, basic structure and design of modern converged networks; layered communications models; IP addressing and subnetting, and industry network standards and protocols (with an emphasis on TCP/IP protocol suite and Ethernet). The use of common networking tools to diagnose and troubleshoot typical network problems is explored and practiced in a lab environment. The major components of a BI network are examined in depth from a networking perspective. Students practice and apply their networking skills and knowledge to the BI world in a lab environment by planning, implementing, deploying, testing and troubleshooting a network that incorporates the major BI components. Students are introduced to a structured approach to identifying and resolving network issues in a BI environment. 60.0
CST2104 Students explore the concepts and core functions of the Windows and Linux operating systems in a stand-alone environment and the different administrative expectations in a multi-user environment. Students learn basic commands and capabilities of both operating systems, along with the skills required to perform system configuration, backups, system support and management. Typical tasks covered include, but are not limited to: installing and configuring operating systems, installing device drivers, managing memory, command-line environment, managing file systems, granting file permissions, troubleshooting the boot process and customizing the operating environment to meet BI requirements. Operating System Component of Business Intelligence Platforms Students explore the concepts and core functions of the Windows and Linux operating systems in a stand-alone environment and the different administrative expectations in a multi-user environment. Students learn basic commands and capabilities of both operating systems, along with the skills required to perform system configuration, backups, system support and management. Typical tasks covered include, but are not limited to: installing and configuring operating systems, installing device drivers, managing memory, command-line environment, managing file systems, granting file permissions, troubleshooting the boot process and customizing the operating environment to meet BI requirements. 60.0
MGT0032 An introduction to quality assurance and control programs within a business organization is provided. Topics include the nature and history of quality, factors which affect quality, quality inspection and verification. Students review collection and analysis and interpretation of data, histograms and frequency distributions, probability and its applications normal and binomial curves, control charts for variables and attributes and statistical sampling. Fundamentals of Quality Assurance An introduction to quality assurance and control programs within a business organization is provided. Topics include the nature and history of quality, factors which affect quality, quality inspection and verification. Students review collection and analysis and interpretation of data, histograms and frequency distributions, probability and its applications normal and binomial curves, control charts for variables and attributes and statistical sampling. 39.0
Level: 02 Hours
CST2200 Students continue their exploration of an enterprise class dbms, with an emphasis on administration, security and performance. A database is created and key configuration parameters are examined. Special topics and technologies related to typical and advanced Business Intelligence, Business Analytics, big data environments are introduced. Students create a data warehouse and are exposed to key concepts associated with implementing a dimensional model and populating it with data extracted, transformed and loaded from relational and other sources.

Prerequisites: CST2102
Database Systems Administration and Management Students continue their exploration of an enterprise class dbms, with an emphasis on administration, security and performance. A database is created and key configuration parameters are examined. Special topics and technologies related to typical and advanced Business Intelligence, Business Analytics, big data environments are introduced. Students create a data warehouse and are exposed to key concepts associated with implementing a dimensional model and populating it with data extracted, transformed and loaded from relational and other sources.

Prerequisites: CST2102
60.0
CST2201 Students are provided with the tools and strategies for managing technical projects. Students use strategies relating to team building, goal setting, leadership skills, scheduling and assessing performance. Student teams create a project charter and work on a project to develop their skills. Project management software tools are used to support scheduling and resource management. Opportunities to lead and to participate are provided throughout this course.

Prerequisites: CST2100
Project Management Students are provided with the tools and strategies for managing technical projects. Students use strategies relating to team building, goal setting, leadership skills, scheduling and assessing performance. Student teams create a project charter and work on a project to develop their skills. Project management software tools are used to support scheduling and resource management. Opportunities to lead and to participate are provided throughout this course.

Prerequisites: CST2100
28.0
CST2202 Students are provided with a conceptual framework for studying BI systems. The value of this information is that it assists students in understanding the subsystems and their communication protocols, as well as providing a structured approach to comparing and contrasting available systems.

Prerequisites: CST2102
Introduction to Business Intelligence Architecture Students are provided with a conceptual framework for studying BI systems. The value of this information is that it assists students in understanding the subsystems and their communication protocols, as well as providing a structured approach to comparing and contrasting available systems.

Prerequisites: CST2102
12.0
CST2203 Through a combination of lectures and hands-on exercises, students gain valuable experience with the tools needed to responsibly administer servers and content in Cognos BI. Students set up a Cognos BI system, implement security and manage the server components. Through the installation and configuration of add-ons, such as Cognos Office Connection and Map Manager, students also schedule tasks, manage and deploy content and set up a package based drill-through access.

Prerequisites: CST2103
Security and Administration of Business Intelligence Platforms Through a combination of lectures and hands-on exercises, students gain valuable experience with the tools needed to responsibly administer servers and content in Cognos BI. Students set up a Cognos BI system, implement security and manage the server components. Through the installation and configuration of add-ons, such as Cognos Office Connection and Map Manager, students also schedule tasks, manage and deploy content and set up a package based drill-through access.

Prerequisites: CST2103
20.0
CST2204 Through hands-on demonstrations and workshops, students use report building techniques based on relational data models to enhance, customize, manage and distribute professional reports. Using Cognos Connection, Cognos BI portal interface, and Report Studio, students author reports that navigate and manipulate dimensional data structures.

Prerequisites: CST2102
Report Authoring Through hands-on demonstrations and workshops, students use report building techniques based on relational data models to enhance, customize, manage and distribute professional reports. Using Cognos Connection, Cognos BI portal interface, and Report Studio, students author reports that navigate and manipulate dimensional data structures.

Prerequisites: CST2102
33.0
CST2205 Students model various operational and dimensional representations of data appropriate for addressing business requirements. They design, import, manage and publish meta data models for use with IBM Cognos BI software.

Prerequisites: CST2102
Data Modeling Students model various operational and dimensional representations of data appropriate for addressing business requirements. They design, import, manage and publish meta data models for use with IBM Cognos BI software.

Prerequisites: CST2102
60.0
CST2206 Ongoing relationships with customers are a crucial component of successful BI platforms, through effective technical support either onsite or remotely. Students explore advanced topics that assist in resolving issues with Cognos BI; requiring in-depth investigation of the architecture.

Prerequisites: CST2103
Troubleshooting Business Intelligence Platforms Ongoing relationships with customers are a crucial component of successful BI platforms, through effective technical support either onsite or remotely. Students explore advanced topics that assist in resolving issues with Cognos BI; requiring in-depth investigation of the architecture.

Prerequisites: CST2103
40.0
CST2207 Students participate in a group project. Teams of students use their knowledge of the Cognos BI architecture to install, troubleshoot, configure and customize the Cognos BI environment. Students also build, optimize and maintain a reporting environment using relational and OLAP data sources. Teams manage their projects and complete work in a timely fashion, ensuring that problems and solutions are well documented.

Prerequisites: CST2100 and CST2101 and CST2102 and CST2103 and CST2104
Business Intelligence Project Students participate in a group project. Teams of students use their knowledge of the Cognos BI architecture to install, troubleshoot, configure and customize the Cognos BI environment. Students also build, optimize and maintain a reporting environment using relational and OLAP data sources. Teams manage their projects and complete work in a timely fashion, ensuring that problems and solutions are well documented.

Prerequisites: CST2100 and CST2101 and CST2102 and CST2103 and CST2104
32.0
MGT0044 This course develops the more advanced statistical techniques to evaluate quality, analyze processes, products and out-of-control conditions, solve manufacturing problems, establish and evaluate specifications and tolerances, and reduce product variability. The course develops the skills of statistical analysis and decision making, testing of hypotheses, risks of incorrect decisions, estimation of population parameters, sample size determination, analysis of variance, correlation and regression techniques. Pre-requisite: MGT0032 Fundamentals of Quality Assurance or equivalent Statistical Methods of Quality Assurance This course develops the more advanced statistical techniques to evaluate quality, analyze processes, products and out-of-control conditions, solve manufacturing problems, establish and evaluate specifications and tolerances, and reduce product variability. The course develops the skills of statistical analysis and decision making, testing of hypotheses, risks of incorrect decisions, estimation of population parameters, sample size determination, analysis of variance, correlation and regression techniques. Pre-requisite: MGT0032 Fundamentals of Quality Assurance or equivalent 36.0
Co-op: 01 Hours
WKT8001 Students complete a cooperative work term, and submit a written report which documents the location of employment and the duties performed. Work Term I Students complete a cooperative work term, and submit a written report which documents the location of employment and the duties performed.

Fees & Expenses

Tuition Fees: $4,398.22 per term.

Information Technology Fee: $86 per term. *

BYOD Fee: $150 per term. **

eTextbook Fees: see www.algonquincollege.com/etextbooks

Student Activity/Sports Fee: $240.50 per term.

Student Commons/Auditorium Fee: $22 per term.

Student Centre Building Fee: $17.50 per term.

Student Experience Fee: $17 per term.

Health Services Fee: $20 per term.

Health Plan Fee: $123.96 paid once annually. ***

A $40 graduation fee is payable in the final term.

A $20 transcript fee is payable in the first term a student attends Algonquin College.

International Students pay all relevant Canadian fees plus an International Premium of $3,975 per term.

* Students paying the Information Technology fee are provided with a network account, an email address, and Internet access. For more information please visit our website at www.algonquincollege.com/its/services/it_fee.htm

** The BYOD Fee covers the costs associated with providing various services and software to students registered in a BYOD program.

*** Students who have coverage with another plan can request a refund by supplying the Students' Association with documentation supporting the request. This request will have to be made annually.

Supplies can be purchased at the campus store. For more information about books, go to www.algonquincollege.com/etextbooks/

Admission Requirements 

Program Eligibility

  • Ontario College Diploma, Ontario College Advanced Diploma, Degree (in areas of business, science, technology, engineering); or equivalent.
  • Applicants with International transcripts must provide proof of the subject specific requirements noted above along with proof of either: IELTS-International English Language Testing Service-Overall band of 6.5 with a minimum of 6.0 in each band; OR TOEFL-Internet-based (iBT)-overall 90, with the minimum in each component: Reading 21; Listening: 20; Speaking: 27, Writing: 22.

Application Information

Applications to full-time day programs must be submitted with official transcripts showing completion of the academic admission requirements through:

ontariocolleges.ca
60 Corporate Court
Guelph, Ontario N1G 5J3
1-888-892-2228

Applications are available online at www.ontariocolleges.ca.. A $95 fee applies.

Applications for Fall Term, Winter Term and Spring Term admission received by February 1 will be given equal consideration. Applications received after February 1 will be processed on a first-come, first-served basis as long as places are available.

International applicants applying from out-of-country can obtain the International Student Application Form at xweb.algonquincollege.com/FormIE/index.aspx or by contacting the Registrar's Office.

For further information on the admissions process, contact:

Registrar's Office
Algonquin College
1385 Woodroffe Ave, Room C150
Ottawa, ON K2G 1V8
Telephone: 613-727-0002
Toll-free: 1-800-565-4723
TTY: 613-727-7766
Fax: 613-727-7632
Email: AskAlgonquin@algonquincollege.com

Additional Information

Several courses can assist in the preparation for industry standards Oracle and IBM Cognos examinations (CST2102, CST2200, CST2202, CST2203, CST2204, CST2205, CST2206 and CST2207).

Program curriculum is reviewed annually to reflect evolving industry trends and standards in this information technology field.

Applicants should have intermediate computer skills, such as experience installing software, writing basic SQL queries, as well as understanding basic operating system and programming concepts and commands. Candidates without this background, that are otherwise from a relevant discipline and are confident in their ability to learn these skills, are also encouraged to apply.

For more information, please contact the Program Coordinator at coordbi@algonquincollege.com

Every attempt is made to ensure the accuracy of the information in this publication. The College reserves the right to modify or cancel any course, program, fee, timetable, or campus location at any time