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: