96%
Next information session
Overview
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.
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 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.
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.
Credentials
After successfully completing this program, graduates will receive a SAIT certificate in Business Intelligence: Data Analysis and Reporting.
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
$64,000
Tuition and fees per year*
Year 1: $11,488
Year 1 (International): $17,355
*Tuition, fees, books and supply costs are subject to change
Full costs
Tuition and financial aid
Requirements
This is a competitive program. If applicants meet the admission requirements they will be assessed based on additional criteria. Applicants will be offered admission to this program if they’re qualified through the competitive process and space is available.
When can you apply?
- Applications for winter 2021 open March 30, 2020 and are accepted until the program start date.
| Term | Program start |
|---|---|
| Winter 2021 | Jan. 11, 2021 |
| Spring 2021 | May 10, 2021 |
Admission Requirements
Admission and selection
- Winter 2021 start: applications open March 30, 2020 and are accepted until the program start date.
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.
Courses
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 | |
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.
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.
Costs
Domestic Tuition and Fees*
| Year | Tuition fees | SAIT fees | Saitsa fees | Health & Dental Plan | 2020/21 total |
|---|---|---|---|---|---|
| 1 | $10,266 | $682 | $288 | $252 | $11,488 |
International Tuition and Fees*
| Year | Tuition fees | SAIT fees | Saitsa fees | Health & Dental Plan | 2020/21 total |
|---|---|---|---|---|---|
| 1 | $16,022 | $682 | $288 | $344 | $17,355 |
SAIT Fees
Campus athletic and recreation Fee: $171.20
Universal transit pass (UPass): $310 - Check eligibility here.
Student support fee: $100
Student technology fee: $100
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: $344
- For more information on Health and Dental Benefits for International students please contact the International Centre.
Books and supplies*
- Find out about tuition and financial aid.
* 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.
Important dates and deadlines
Find important dates applicable to all students, including your transcript and tuition payment deadlines on our Important Dates page.
Delivery
All classes in this program will be delivered online for the Fall 2020 term due to the COVID-19 pandemic and associated health and safety guidelines.
Student Guidelines
Review the student guidelines to learn about the School of Information and Communications Technologies' expectations before you start your studies.
Computers and laptops
This is a bring your own device program with a standard hardware and software requirement. See the specific requirements on our computers and laptops page.
Preparation courses
To support your success, SAIT offers some short courses before classes start, including PREP 100: The SAIT Experience and ETHI 110: SAIT Ethical Practices.
Required textbooks
The booklist will be available about two weeks before classes start.
Can’t find your program or course? The bookstore didn't receive a textbook list. Contact your program directly to determine if they’re still refining course details or if you're in luck, no textbook purchase required this term.
Contact
Email: fast-track@sait.ca
Academic chair
"Thank you for choosing the SAIT School of Information and Communications Technologies! As your academic chair for the Business Intelligence – Data Analysis and Reporting program, it’s my pleasure to welcome the newest members of our innovative learning community on behalf of the entire program. We look forward to seeing the impact you’ll make and to supporting your academic journey."
Karen Graham, Academic Chair