Business Intelligence Data Analysis and Reporting

This course introduces the principles of developing, administering and querying a SQL server database. Students will learn to administer an SQL server from installation through to back-ups, performance monitoring and the foundations of developing databases. As students progress through this course, they will learn and use T-SQL language elements and gain the ability to use SQL Management Studio tools to query and maintain an SQL environment. Students will use Microsoft Azure Data Services to explore relational data in a cloud environment.

This course prepares students to capture the business and technical requirements for a business intelligence solution with an emphasis on assessment and development of a business intelligence project lifecycle. They will also learn how to create, manage and maintain databases and database elements such as triggers, views, stored procedures, views and tables. Students will examine cloud-based data services related to data storage, provisioning, processing and consumption.

This course will introduce students to designing and developing the extract, transform and load processes. They will implement control flow, data flow, and logging as they create and debug Integration Services packages to enable the ETL process. They will then deploy these integration services packages. Working with SQL Server Integration Studio (SSIS), they will plan data transfer and staging solutions for ETL operations. These packages will require students to implement error handling, optimization and reliability as they work toward the deployment and operation of an SSIS solution. Students will explore data ingestion, preparation, and quality management while building solutions that use various data discovery control methods. They will also build skills in the implementation of an Azure Data Solution.

This course introduces students to designing, developing and deploying Business Intelligence applications. They will complete reporting and analytical interfaces optimized for execution performance. They will use reporting services to create and manipulate data sets and look for opportunities to enhance reports in business functional areas.

In this course, students will plan, design, implement and optimize the infrastructure for an OLAP (Online Analytical Processing) solution. They will create the logical design and physical storage for multidimensional solutions. They will implement KPIs (key performance indicators), associated actions, stored procedures and data sets. They will implement data mining solutions as they deploy, manage, and maintain an analysis services solution. Students will work with SQL analysis services to create multidimensional analysis solutions, work with measures and measure groups and execute queries against multidimensional analysis solutions. They will look at data mining activities by customizing cube functionality as they deploy and secure an analysis services database. They will design for various data platforms such as on-premise, cloud and hybrid. Students will also learn about data scenarios involving relational data, NoSQL, and data warehouse architectures.

This course is an introduction to the role of business analysis in a business development lifecycle. Students will learn the business intelligence lifecycle, the role of corporate performance management, business intelligence value within various business functional groups (i.e. finance, supply change management), and business requirements gathering for corporate performance management methodologies. They will gain familiarity with several strategic design methodologies and data's role in their success (SWOT, PESTLE, PEST, Five Forces, etc.) Balanced scorecards and data-driven business processes will also be examined in building data-literate organizations.

This course introduces students to the principles of creating and using performance management tools and methods in organizations. They will learn how to design and create compelling performance management applications such as scorecards, dashboards and reports used for decision-making at all levels of an organization.

This is a practicum conducted off campus at a participating corporation or business. It provides learners with a realistic taste of what it is like to work in the technology industry. Learners are involved in all steps of the practicum process.

This course will thread throughout the program and learners will incorporate all the elements of the program into a final project based on a business intelligence case study.