May 24, 2024  
PUBLISHED 2024-2025 Credit Catalog 
PUBLISHED 2024-2025 Credit Catalog

Business Intelligence: Data Analysis and Reporting

Location(s): In Person (Main Campus), Blended (Main Campus & Online)

Return to {$returnto_text} Return to: Programs in the School for Advanced Digital Technology

Understanding how to access and utilize corporate information is crucial in today’s data-driven business environment. 

This program will provide practical, hands-on experience using Microsoft SQL Server, one of the industry’s leading relational database management systems. You’ll become adept in writing SQL queries, managing databases, and understanding data structures. You’ll have the knowledge and skills to make data-driven decisions that can contribute to business success. 

You’ll learn:

  • to query, administer and maintain databases through tasks such as database backup and recovery, security management and optimization for performance
  • data analysis proficiency and how to extract valuable insights from data, perform data cleansing and transformation, and apply statistical and analytical techniques
  • industry-standard data management best practices and techniques
  • how to design and maintain databases and business intelligence software that align with industry standards, ensuring data accuracy, security and reliability
  • the essential skills and experience to complete the relevant Microsoft certifications related to business intelligence, like Microsoft Power BI, making you even more competitive in the job market
  • to bridge the gap between theory and practice by applying your skills in real-world business scenarios.

As a graduate, you can pursue various career opportunities, including database administrator, business analyst or data analyst roles or business intelligence consultant. The skills you acquire will be valuable in multiple industries and organizations. 

Due to the tight integration of the courses in the Business Intelligence Data Analysis and Reporting program, credit for prior learning is not available.

Traits, skills and aptitudes

Those working in the business intelligence and data analysis field tend to be innovative, methodical and directive. 

You need:

  • to learn quickly, think logically and study information 
  • to build abstract structures that represent complex relationships 
  • to focus on details without losing sight of the whole 
  • an awareness of legal, policy and privacy restrictions 
  • speaking, listening and writing skills 
  • to work well in a team 
  • an active interest in keeping up with changes in technology. 

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

To do well in this field, you should enjoy working with a variety of people in a team setting and solving problems. 

Practicum, co-op and work integrated learning opportunities

In your second semester, you’ll participate in a practicum placement with an employer where you’ll apply the skills and knowledge you’ve learned in an industry environment. 

Accreditations, designations or certifications

This 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 exam preparation, you’ll be prepared to challenge and complete appropriate Microsoft Certifications. 


Upon successful completion of this program, you’ll receive a SAIT Business Intelligence: Data Analysis and Reporting certificate.

Program length

24 weeks

Accepts international applicants - not-PGWP eligible

This program is open to international applicants; however, program availability may be limited. This program does not meet the eligibility criteria for the Post-Graduation Work Permit program

Not eligible for CAJG

This program is not eligible for the Canada Alberta Job Grant

Related careers

Our graduates may work in the following occupations. Some careers require additional experience and education.

Potential careers (NOC):

  • Database analysts and data administrators (21223)
  • Business systems specialists (21221)
  • Professional occupations in business management consulting (11201)
  • Data scientists (21211)
  • Business development officers and market researchers and analysts (41402)

Admission requirements - Applicants educated in Canada

Applicants must demonstrate English language proficiency and completion of the following courses or equivalents:

  • at least 60% in English Language Arts 30-1 or 30-2, and
  • at least two years of post-secondary education from a recognized university, institute or college.

SAIT accepts high school course equivalents for admission for applicants educated outside Alberta.

Admission requirements - Applicants educated outside of Canada

All applicants who were educated outside of Canada must demonstrate English language proficiency and provide proof they meet the program admission requirements with an international document assessment. Find accepted educational documents and assessment options

SAIT may also accept courses completed at certain international post-secondary institutions.

Program outline

The Business Intelligence Data Analysis and Reporting requires 19.5 credits (nine courses) to complete.

The program spans 24 weeks, with one semester of study and a second semester practicum placement.

Suggested schedule of study


You must attain a PGPA and/or a CGPA of 2.0 or better each semester and pass the prerequisite courses to progress through the program.

To qualify for graduation, you must pass all courses, attain a CGPA of 2.0 or better and complete course requirements within the prescribed timelines.

Review our grading and progression procedure > 

Books and supplies

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

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.

Advanced Digital Technology program advising

For any questions or to set up an advising appointment, please contact our School for Advanced Digital Technology.

Phone: 403.284.8543

Return to {$returnto_text} Return to: Programs in the School for Advanced Digital Technology