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

Open for Winter 2018

Open for Spring 2018

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 Program PDF

Next Information Session

All Information Sessions

Tuition and Fees Per Year*

Year 1: $10,338
Year 1 (International): $15,136

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

Requirements

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: 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 2018 open Oct. 18, 2017.
TermProgram start
Winter 2018 Jan. 8, 2018
Spring 2018 May 7, 2018

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 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.

Credential

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

Accreditation

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

Once completed, this SAIT credential may be eligible for transfer credit at another post-secondary institution. Visit Transfer Options to learn more about the transfer agreements currently available to SAIT graduates and incoming students.

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

Admission Requirements

Admission and Selection

  • Applications are accepted until the program start date.
  • Spring 2018 start: applications open Oct. 18, 2017.

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.

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.

Courses

Program Outline

  • To find the course description for a course shown below, please go to our Course Finder and enter the course acronym and numbers (e.g. DMST-202) into the Quick Search by Course Code field.
  • 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.

Some of the technologies you will learn in this program are:

Course CodeCourse NameCredit
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
PRAC-249 Business Intelligence Practicum 3.0
PROJ-212 Applied Business Intelligence Project 3.0
Program Total 19.5

Progression

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.

Costs

Domestic Tuition and Fees*

YearTuition feesSAIT feesSAITSA fees2017/18 total
1 $9,595 $220 $523 $10,338

International Tuition and Fees*

YearTuition feesSAIT feesSAITSA fees2017/18 total
1 $14,393 $220 $523 $15,136

SAIT Fees

Campus Athletic and Recreation Fee: $80
Universal Transit Pass (UPass): $140 (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*

  • Microsoft Official Curriculum and other textbook resources and supplies are included in the tuition.


Find out about tuition and financial aid.

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

Contact Information

Fast-Track  
403.210.4522
fast-track@sait.ca