Home Programs & Courses Full-Time Studies Business Intelligence - Data Analysis and Reporting
Classroom full of students use computers to analysis a businesses success.

Business Intelligence - Data Analysis and Reporting

Closed for Spring 2019

Open for Winter 2020

Length: 24 Weeks
Credential: Certificate
Available: Full Time Classroom

Program Highlights

Build a career as a business intelligence analyst or consultant by learning to develop, analyze and administer corporate data to help businesses and organizations make better decisions.

Download this program information

Next information session
What's up @ SAIT
No events found.

Add this calendar to your calendar

Note: Some filters are being applied, so the exported content is being filtered.

All information sessions

Tuition and fees per year*

Year 1: $10,580
Year 1 (International): $15,958

*Tuition, fees, books and supply costs are subject to change


You will be offered admission to this program if you meet the admission requirements and qualify through competitive entry. Competitive entry is based on a two-step process: a review of your supporting documentation (career and program investigation form, resumé and previous computer experience) and a selection appointment. 

When can you apply?

  • Applications are accepted until the program start date.
  • Applications for spring 2019 open Oct. 3, 2018.
  • Applications for winter 2020 open May 1, 2019.
TermProgram start
Spring 2019 May 6, 2019
Winter 2020 Jan. 6, 2020

Program Details

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.

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.

Credentials and accreditation

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.

Transfer options

The opportunity to advance your education through transfer to, within or from SAIT is available with the following universities and colleges:

  • Rocky Mountain College

To learn more, visit transfer options.

Have questions? Write to us at transfer.options@sait.ca.

Admission Requirements

Admission and selection

  • Applications are accepted until the program start date.
  • Spring 2019 start: applications open Oct. 3, 2018.
  • Winter 2020 program starts Jan. 6, 2020. Applications open May 1, 2019.

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.

SAIT accepts high school course equivalents for admission. If you don't meet the requirements, consider Academic Upgrading.

SAIT evaluates international documents for admissions. After you've applied, consider our international document assessment service if your education is from outside of 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

Competitive entry: seven-step process

Step 1: Read the program information to see the qualities needed for student success.

Step 2: Ensure that you meet all of the admission requirements listed above.

Step 3: Review the selection information to understand the process and deadlines.

Applications and proof of the admission requirements (transcripts and/or anticipated final grades) along with all supporting documents must be submitted to be included in selection.  

Selection is done on a continuous basis and is based on the following criteria:

  • Current resumé outlining previous education and experience.
  • ICT Fast-Track Career & Program Investigation form. This form will be emailed to you once you have applied. It will be scored to determine suitability for the program; please be detailed and thorough.
  • A photocopy of your educational transcripts and any other supporting documents.  
  • Proof of previous relational database experience. Transcripts, substantial industry experience or certifications will be considered. A relational database/scripting or computer programming tutorial may be required. Please refer to this document outlining the technical expectations of students entering this program.
  • Attend a mandatory selection appointment once the above documents have been submitted and scored by the department. Telephone appointments can be scheduled for out-of-town applicants.  
  • The final decision for acceptance into the program will be determined by the Academic Chair.

Step 4: Apply to Business Intelligence and submit your transcripts.

Step 5: Log in to mySAIT.ca to check your admission status. If eligible, your status will indicate that you're "In Selection."

Step 6: Submit your resumé, Career & Program Investigation form and transcripts.

  • Send your documentation to the School of ICT Fast-Track office by email to fast-track@sait.ca or fax to 403.210.4523.

Step 7: Continue to monitor changes to your application status through mySAIT.ca.

Failure to meet anticipated final grades will result in offers being rescinded.

Communication during selection

Email is the primary source of communication during the selection process. Ensure your personal email account is managed appropriately to receive our emails, files and communications.

We recommend you add fast-track@sait.ca and the sait.ca domain to your safe senders' list or you risk missing critical email messages.

Ideal applicant

The ideal candidate for the Business Intelligence program is a motivated, mature learner with post-secondary education in either Business or IT. You want to specialize or to upgrade existing skills. You understand the benefits to business of properly analyzing and reporting information. You are analytical, technically proficient and detail-oriented. Your approach to problem-solving is both creative and logical, depending on the circumstances. You work well as part of a team and enjoy interacting with others.


Program outline

  • The curriculum in SAIT's fast track programs is constantly changing to reflect the needs of the market and ensure the classes offered are up-to-date.
  • View additional Business Intelligence: Data Analysis and Reporting program information including course-specific descriptions and requisites.
Semester 1
Course code Course name Credit
CPSY-201 Introduction to Data Management 3.0
CPSY-203 Architecture and Design 1.5
CPSY-205 ETL (Extract, Transform, Load) 1.5
CPSY-209 OLAP (Online Analytical Processing) 1.5
MMGT-205 Business Analysis for B.I. Applications 1.5
MMGT-206 Performance Management Applications 3.0
PROJ-212 Applied Business Intelligence Project 3.0

Semester 2

Course code Course name Credit
PRAC-249 Business Intelligence Practicum 3.0
Program total 19.5


Students must attain a PGPA and/or a CGPA of 2.0 or better in each semester and pass the necessary prerequisite courses to progress through the program. To qualify for graduation, students must pass all courses, attain a CGPA of 2.0 or better and complete course requirements within the prescribed timelines.


Domestic tuition and fees*

Year Tuition fees SAIT fees SAITSA fees 2019/20 total
1 $9,595 $462 $523 $10,580

International tuition and fees*

Year Tuition fees SAIT fees SAITSA fees 2019/20 total
1 $14,974 $462 $523 $15,958

SAIT fees

Campus athletic and recreation fee: $80
Universal Transit Pass (UPass): $302 (If you meet the eligibility requirements, the UPass fee will be assessed with your tuition.)

SAIT Students' Association fees

Health plan: $110
Dental plan: $125
SAIT Students' Association (SAITSA): $288

Books and supplies*

  • Tuition includes all required textbooks. Students should be prepared to subscribe to Office 365 Business Premium at your own expense.

Find out about tuition and financial aid.

* Tuition, fees, books and supply costs are subject to change.


School of ICT: Fast-Track

Enter Your Search Term Here
Start typing to search SAIT.ca
Refine Results

Search results