Home Programs & Courses Business Intelligence Data Analysis and Reporting

Business Intelligence Data Analysis and Reporting

Open for Fall 2022

Open for Spring 2022

Waitlisted for Winter 2022

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

Apply now

Next information session

Business Intelligence - Con Ed Info Session
Dec 14 @ 12:00pm | Zoom
Upcoming Information Sessions


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.

You will learn industry-standard data management best practices and techniques. Visit Microsoft's website 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.

Is this the right fit for me?

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 businesses through technology solutions
  • experience with relational databases, computer programming or operating systems (for example, 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.


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.


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

Read more


Want to learn more about this program?

Sign up

Career opportunities

Graduates can pursue job opportunities as a(n): 

  • business intelligence analyst 
  • business intelligence consultant 
  • data warehouse analyst 

Related careers include: 

  • Market research analyst 

Tuition and fees per year*

Year 1: $12,010 
Year 1 (International): $17,676

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

Full costs
Tuition and financial aid


You will be offered admission to this program through direct entry if you meet the admission requirements and space is available.

When can you apply?

Applications are accepted until the program start date but are subject to change.

  • Applications for winter 2022 open March 31, 2021.
  • Applications for spring 2022 open June 14, 2021.
  • Applications for fall 2022 open Oct. 6, 2021.
Classes begin Year start date Year end date
Winter 2022 Jan. 10, 2022 June 24, 2022
Spring 2022 May 9, 2022 Oct. 28, 2022
Fall 2022 Sept. 6, 2022 March 10, 2023

Doubling down on data

SAIT’s data programs prepare students to harness a company’s most valuable asset — its information.

Admission Requirements

Admission and selection

Applications are accepted until the program start date but are subject to change.

  • Winter 2022 start: applications open March 31, 2021.
  • Spring 2022 start: applications are open June 14, 2021.
  • Fall 2022 start: applications are open Oct. 6, 2021.

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

Direct entry: four-step process

Step 1: Read the program information and review this program presentation to learn more about student expectations during the program. 

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

Step 3: Apply to Business Intelligence program.

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

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

Previous relational database experience gained through education, industry experience, industry certifications, or completion of online tutorials related to database management systems or SQL is strongly recommended.

Communication during admissions

Email is the primary source of communication during the admissions 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

Looking for course descriptions and requisites? Visit the course catalogue

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-207 Reporting and Analytics 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.

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.


2021/22 Domestic Tuition and Fees*

Year Tuition fees SAIT fees Saitsa fees Health & Dental Plan 2021/22 total
1 $10,676 $793.20 $287.77 $252 $12,009

2021/22 International Tuition and Fees*

Check back for updates on the 2021/22 fees and program total.

Year Tuition fees SAIT fees Saitsa fees Health & Dental Plan 2021/22 total
1 $16,343 $793.20 $287.77 $252 $17,676

*Fees and tuition are based on a two-semester full course load structure. There may be additional fees for practicums and terms held outside this time frame. 


Campus athletic and recreation Fee: $183.20
Universal transit pass (UPass): $310 - Check eligibility here.
Student support fee: $150
Student technology fee: $150

Health and Dental Fees

Domestic Students 

  • Health Plan: $122
  • Dental Plan: $130
  • For students with existing health and/or dental plans, please refer to the Saitsa website for information on opting out.

International Students 

  • Health and Dental Plan: $252
  • For more information on Health and Dental Benefits for International students please contact the International Centre.

Books and supplies*

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

Next steps for incoming students

Have you been accepted to this program? Here's what you'll need for your first day of classes.

Winter 2022


Your program orientation will take place Jan. 7 on campus. Check your schedule in mySAIT for the time and location details.

Learn more about campus orientation.

How to register for classes

You'll follow a fixed block registration process to enrol in your classes. Learn how to register on our registration and schedules page.

Computers and laptops

This is a bring your own device program with a power-user hardware and software requirement. See the specific requirements on our computers and laptops page

Students will also be required to purchase personal subscriptions to software discussed in class.

Preparation courses

To support your success, you’ll be automatically registered in two short courses to prepare you for the academic year:

PERS 050: Student Rights and Responsibilities

This course is designed to introduce you to student rights and responsibilities at SAIT. You will learn about SAIT's rich and diverse community, become familiar with guidelines and procedures that create a safe, respectful learning experience for you, and gain practical tips for how you can engage in the SAIT community in a positive and responsible way. PRES-050 must be completed within 30 days from the start of the semester.

PREP 100: The SAIT Experience

Get tips and insider information on time management, exam preparation, effective notetaking and more through this free, online short course for new students. Plus, learn about discussion boards, online communication and submitting assignments online. Course completion is recommended by the end of your first semester.

Both courses can be accessed through Brightspace D2L before the first day of classes.

Required textbooks

Textbooks and virtual lab access will be provided at no additional cost.


Phone: 403.284.8543
Email: fast-track@sait.ca

Academic chair

Blake Kanewischer, Academic Chair

Next steps for all students

Here's what else you'll need to do to get ready!

Next steps for accepted students

Important dates and deadlines

Find important dates applicable to all students, including your transcript and tuition payment deadlines on our Important Dates page.

Important Dates

Student Guidelines

Review the student guidelines to learn about the School of Information and Communications Technologies' expectations before you start your studies. 

Download Guide

Have questions about this program?

Contact us at

School of Information and Communications Technologies (fast-track programs)

More programs you might like

  • Full Time
  • Classroom
  • Certificate
  • Open for Fall 2022
See more web and digital technology programs
mail envelope

Your journey starts here

Sign up to get important updates on:

  • Business and technology programs
  • Application information
  • Relevant news and events

Get important updates about our business and tech programs

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

Search results

Sait.ca Website Feedback

Hello, we'd love to hear your feedback about our website...

Would you like a response?*

Please answer the math question below.