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.
Graduates may find employment as a business intelligence analyst, business intelligence consultant or data warehouse analyst.
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.
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 firstname.lastname@example.org.
Admission and Selection
- Applications are accepted until the program start date.
- Spring 2018 start: applications open Oct. 18, 2017.
- 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
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 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 email@example.com or fax to 403.210.4523.
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 firstname.lastname@example.org and the sait.ca domain to your safe senders list or you risk missing critical email messages.
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.
- 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 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|
|PRAC-249||Business Intelligence Practicum||3.0|
|PROJ-212||Applied Business Intelligence Project||3.0|
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||2017/18 total|
International Tuition and Fees*
|Year||Tuition fees||SAIT fees||SAITSA fees||2017/18 total|
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.