|
Aug 31, 2024
|
|
|
|
PUBLISHED 2024-2025 Credit Catalog
Business Intelligence: Data Analysis and Reporting
|
|
Return to: Programs
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. Credential
Upon successful completion of this program, you’ll receive a SAIT Business Intelligence: Data Analysis and Reporting certificate. 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.
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.
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
Progression
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. |
Return to: Programs
|
|