Business Intelligence System Infrastructure
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 14-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://mlearning.algonquincollege.com. Computers and supplies can be purchased directly from Algonquin's New Technology Store at educational rates.