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(s)

Program Code: 1514X01FWO
Academic Year: 2015/2016


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, courses focus on helping students understand and develop core competencies in the essential technologies utilized in delivering BI/BA solutions. The courses in Level 02 focus on assisting students to understand and develop hands-on experience using the designated IBM Cognos software. Examples of hands-on 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.

This program offers one cooperative education (Co-op) Work Term(s) option. Qualified students with a minimum GPA of 2.7, have the opportunity to apply for paid co-op employment to gain valuable work experience and networks within industry. *See Additional Information for more details.

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 http://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, starting in the first week of class.

SUCCESS FACTORS

This program is well-suited for students who:

  • Are problem solvers and critical thinkers.
  • Have an interest in working with integrated software to deliver and support business solutions.
  • Are able to effectively work independently with little supervision.
  • Have the ability to professionally collaborate and achieve team deliverables.
  • Possess organization and time-management skills .
  •  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
CST2105 A focused examination of major statistical techniques (regression, clustering, classification, and association)is provided. The CRISP-DM framework is also examined and market leading software is used. Statistical Foundations for Bisi Students A focused examination of major statistical techniques (regression, clustering, classification, and association)is provided. The CRISP-DM framework is also examined and market leading software is used. 45.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 Students gain valuable experience with the tools needed to responsibly install, configure, administer and secure servers and content in Cognos BI. Students set up a Cognos BI system, implement security, integrate the BI platform with enterprise mail and authentication provider and manage the server components. Students also learn and practise creating security roles and groups, assigning access rights, scheduling tasks and managing, deploying and securing content.

Prerequisites: CST2103
Security and Administration of Business Intelligence Platforms Students gain valuable experience with the tools needed to responsibly install, configure, administer and secure servers and content in Cognos BI. Students set up a Cognos BI system, implement security, integrate the BI platform with enterprise mail and authentication provider and manage the server components. Students also learn and practise creating security roles and groups, assigning access rights, scheduling tasks and managing, deploying and securing content.

Prerequisites: CST2103
20.0
CST2204 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 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: CST2203
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: CST2203
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
CST2208 This course extends the knowledge gained in CST2105 by considering methods appropriate for more complex requirements, including an introduction to and use of analytical techniques and natural language processing for mining of unstructured data. Statistical Topics for Bisi Students This course extends the knowledge gained in CST2105 by considering methods appropriate for more complex requirements, including an introduction to and use of analytical techniques and natural language processing for mining of unstructured data. 45.0

Fees & Expenses

Total Fees for the first year of the program:

Domestic tuition/ancillary fees: $11,310.86. *

International tuition/ancillary Fees: $19,260.86. *

* Amounts include tuition fee, program specific lab and material fees, applicable eText fees, Students` Association fees and compulsory ancillary fees. Fees are subject to change. For detailed fees information please visit http://www.algonquincollege.com/ro/pay/tuition-and-expenses  

Note: For further information regarding your books, please visit http://www.algonquincollege.com/etexts

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 or information).
  • 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 ontariocolleges.ca . A $95 fee applies.

Applications for Fall 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 https://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: AskUs@algonquincollege.com

Additional Information

*Co-op is a real-world job search process requiring students to apply, interview, and earn jobs rather than being placed by the College. In the term prior to the cooperative education (Co-op) Work Term, students are required to independently complete online modules that assist with resume and cover letter writing, and interview technique preparation. Students must actively conduct a self-directed job search and are responsible to secure approved program related paid co-op employment. Students compete for co-op positions alongside students from Algonquin and other Canadian and international colleges and universities. Algonquin College`s Co-op Office provides assistance in developing co-op opportunities and facilitates the overall process but does not guarantee that a student will obtain employment in a cooperative education (Co-op) Work Term. Co-op employment opportunities requiring relocation may be considered, and are subject to departmental approval with the understanding that all associated expenses are incurred by students e.g., travel, work permits/visa applications, accommodation, etc.

Cooperative education (Co-op) Work Terms are typically four months in duration and are completed during a term when students are currently not studying on campus. For details on study-work progressions for specific programs, please visit http://www.algonquincollege.com/coop.

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