Apr 23, 2024  
PUBLISHED 2022-2023 Credit Catalog 
PUBLISHED 2022-2023 Credit Catalog [ARCHIVED CATALOG]

Business Intelligence: Data Analysis and Reporting

Return to {$returnto_text} Return to: Programs by School

Program Description

Access to corporate information to make business decisions has made database and reporting tools critical for business success. The Business Intelligence (BSN) program will use the Microsoft SQL Server and B.I. toolset to give you the skills you need to develop, administer and analyze corporate data. You will learn industry-standard data management best practices and techniques. Visit www.microsoft.com/bi for more information on this exciting specialization.

You will master the technical aspects of data gathering using SQL Server within a Windows platform. You will also learn to use and manage multiple databases, then apply these skills to develop corporate reports using specific reporting tools. With additional relevant work experience and exam preparation study, you will be prepared to successfully challenge and complete the relevant Microsoft designation.

Program Overview

Fast Facts

Your Career

Graduates may find employment as a business intelligence analyst, business intelligence consultant or data warehouse analyst.

Student Success

The ideal candidate for the Business Intelligence program has:

  • Previous post-secondary education in business or technology.
  • A technical aptitude and a desire to combine their business and technology skills to assist business through technology solutions.
  • Experience with relational databases, computer programming or operating systems (e.g. Linux/Unix, Windows).

This is an intensive program requiring a commitment of both time and energy, students who experience success are those who make their education a priority throughout the program.

Students with higher grades usually experience more success in SAIT programs.


After successfully completing this program, graduates will receive a SAIT certificate in Business Intelligence: Data Analysis and Reporting.


The program, offered in conjunction with the Microsoft IT Academy initiative, is delivered using Microsoft Official Curriculum for many courses. With additional relevant work experience and additional exam preparation study, you will be prepared to successfully challenge and complete appropriate Microsoft Certifications.


The progression requirement for students taking credit courses is a Term GPA and Total Institutional GPA of 2.0, with the exception of English Language Foundations and Academic Upgrading programs.

Admission Requirements

  • At least 60% in English Language Arts 30-1 or English Language Arts 30-2 or equivalent, OR,
  • A minimum of two years post-secondary education from a recognized university, institute or college.
  • All applicants must demonstrate English Language Proficiency prior to admission, including students educated in Canada.

Due to the tight integration of the courses in the Business Intelligence - Data Analysis and Reporting (BSN) program, credit for Prior Learning is not available.

Program Outline

Total Credits 19.5

Return to {$returnto_text} Return to: Programs by School