Certificate in Business Intelligence Systems Analyst - NEW - Ottawa - Ontario

In the Business Intelligence Systems Analyst certificate program, offered in collaboration with IBM, students develop entry-level technical and people skills to analyze, build, support and manage systems to support business decision making. Courses provide hands-on experience in introductory Java programming; database design and administration; operating systems and networking fundamentals; and multi-tiered Enterprise Internet and intranet application solutions interacting with databases. Students gain practical experience in developing data warehouses (including single-subject data marts) to support reporting that strengthens business decision making. Students learn how to extract from operational data to create data warehouses and explore data mining in the study of advanced data analysis using OLAP (Online Analytical Processing), Relational OLAP, and Multidimensional OLAP. Students use SQL extensions for OLAP, including data grouping, rollup, cube, multiple-column aggregations and materialized views. Intensive study of data warehouses with access to IBM Cognos software and courses provide real workplace tools to integrate classroom theory with hands-on practical experience in modeling and publishing of metadata to the Web, so end users can author reports and analyze data. Upon successful completion, graduates have worked collaboratively with peers to collect, analyze, integrate, and present information that supports business decision making, thereby increasing their marketability in the lucrative field of Business Intelligence.

Certificate in Business Intelligence Systems Analyst - NEW

Level 1

CST8110 Introduction to Computing

CST8182 Networking Fundamentals

CST8202 Desktop Operating Systems ´

CST8209 Web Programming I

CST8282 Introduction to Database Systems

CST8401 Making Cents with Numbers: an Introduction to Business Intelligence

WKT8100E Co-Operative Education Work Term Preparation

Level 2

CST8402 Network Operating Systems

CST8406 Linux Operating Systems

CST8407 Database Systems

CST8408 Database Administration

CST8409 Web Programming II

CST8450 Introduction to Business Intelligence Architecture

CST8451 Security and Administration of Business Intelligence Platforms

CST8452 Report Authoring

CST8453 Data Modeling

CST8454 Troubleshooting Business Intelligence Platforms

CST8456 Business Intelligence Project