This one-year Ontario College Graduate Certificate program is delivered in collaboration with IBM and prepares students for entry to careers requiring specialized technical knowledge to support corporate use of Business Intelligence (BI). Students develop technical and soft skills to work as managers and collaboratively with peers to collect, analyze, design, build, support, integrate and manage systems to aid business decision making through data analysis using complex databases and data warehouses. Business and statistics courses provide the foundation for developing BI solutions to meet business needs.
Students research and evaluate current societal BI implementation and develop criteria for personal, professional and business use of BI. Students install, troubleshoot and configure BI platforms. Hands-on experience is provided in programming, database design and administration, operating systems, networking, and multi-tiered Enterprise Internet and intranet application solutions. Labs include extraction of operational data to create data warehouses, data mining, advanced data analysis, database sharding, Online Analytical Processing (OLAP), Relational OLAP and Multidimensional OLAP. Structured Query Language (SQL) extensions for OLAP, including data grouping, rollup, cube, multiple-column aggregations and materialized views are used. Students learn how to guide clients in the authoring of reports for data analysis, using Cognos software.
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 private, industrial, governmental and service sectors; such as organizations focused on software installation, support and maintenance, information service and technical support.
This program is part of Algonquin's mobile learning initiative. All students entering into the program are expected to have and use a laptop or mobile computing device that meets or exceeds the recommended hardware requirements as designated by the program. Students in mobile learning programs will use their devices to enhance their learning experience, obtain and work with course materials, participate in collaborative and mlearning environments and become skilled, confident users of the technologies used within an educational environment and workplace. Hardware and software specifications are outlined at http://www3.algonquincollege.com/mlearning/. Computers and supplies can be purchased directly from Algonquin's New Technology Store at educational rates.
This program is well-suited for students who:
Are problem solvers and critical thinkers. .
re interested in working with computers and a wide range of technological applications (network, web, database and programming).
Enjoy working with others as well as independently.
Are organized in their work and pay attention to detail.
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 positions.
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
** The Mobile Computing Fee covers the costs associated with providing various services to students registered in a mandatory laptop programs.
*** 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.
Books and supplies cost approximately $850 and can be purchased in the campus bookstore. Selected books are available for a reduced price through ebook initiatives at www.coursesmart.com. This program is a mandatory laptop program.
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 either: TOEFL-Internet-based (iBT)-overall 90, with the following minimum section requirements: Reading: 21; Listening: 20; Speaking: 27; Writing: 22; OR IELTS-International English Language Testing Service-Overall band of 6.5 with a minimum of 6.0 in each band.
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 either: TOEFL-Internet-based (iBT)-overall 90, with the following minimum section requirements: Reading: 21; Listening: 20; Speaking: 27; Writing: 22; OR IELTS-International English Language Testing Service-Overall band of 6.5 with a minimum of 6.0 in each band. <
Applications to full-time day programs must be submitted with official transcripts showing completion of the academic admission requirements through:
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.
Several courses in this program assist in the preparation for industry standards Oracle and Cognos examinations (CST2102, CST2200, CST2202, CST2203, CST2204, CST2205, CST2206 and CST2207).
Curriculum for this program is reviewed annually to reflect evolving industry standards in the information technology field.
Applicants should have basic computer skills, such as keyboard proficiency, Internet browsing and searching and proficiency with an office software suite (word processing, spreadsheets, etc.) prior to the start of the program.
This program has an annual intake in the Fall. For more information, please contact the Program Coordinator at firstname.lastname@example.org.
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