|Faculty:||School of Advanced Technology
|Description:||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, and/or similar or related 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.