Course Specifications
- Code of the program LEA.DK
- In effect since July 2020
- Number of classes 15 (1065 hours)
- Number of internships 1 (285 hours)
- Total duration 1350 Hours / 24 Months
PROGRAM DESCRIPTION
The Business Intelligence Analyst program at College Canada Inc. consists of 14 distinct competencies aimed at training future computer analysts. At the end of his training, the student will be proficient at:
- analyzing organizational and environmental data in order to make strategic decisions within the company;
- specifying the requirements of a data warehouse;
- modeling, designing, building and administering a data warehouse;
- providing management, statistics and analysis reports to those in charge of his business.
The Business Intelligence Analyst program at College Canada Inc. aims to train students in the field of information technology (IT). The student will be capable of performing analysis using powerful tools (Oracle and Microsoft) as well as modeling complex, efficient reports and decision-making dashboards adapted to the employers’ expectations.
The objectives of the curriculum are to:
- understand the definition, structure and purpose of data warehouses, data counters, as well as other forms of storage;
- define the key stages of data integration and understand the contribution of specialized tools compared to conventional programming languages;
- understand how the data access and analysis tools can make end customers autonomous in the analytical process;
- identify and understand the different phases of a business intelligence project;
- define the actors, as well as their roles and responsibilities, in a business intelligence project;
These technicians are called upon to work in:
- consulting firms;
- information technology services in the private sector;
- information technology services in the public sector;
- as self-employed workers, as consultants.
Computer analysts main tasks include to:
- identify and document customer needs;
- carry out technical and commercial studies;
- design, develop, integrate and implement computer systems;
- counsel on information systems strategies, policies, management, security and service delivery.
The profile corresponds to the following national occupational classification:
-
2171 – Information systems analysts and consultants
Other job titles corresponding to the national occupational classification:
- Commercial analyst / IT analyst
- Sales analyst / Computer systems analyst
- Commercial analyst / IT analyst (Information Technology)
- Computer systems analyst
- Information systems analyst – Computer systems
- Computer systems analyst
- Business continuity analyst
- Computer analyst
- MIS (Management Information System) analyst – IT systems
- Management Information System (MIS) analyst
- Management Information System (MIS) analyst – Computer systems
- Information technology analyst
- IT consultant
- Consultant in MIS (management information system) – Computer systems
- Management information system (MIS) consultant – Computer systems
- Computer systems consultant
- Information technology (IT) consultant
- Data processing consultant
- Commercial IT systems specialist
- Electronic data processing verifier
List of Courses
| Subjects |
Hours |
| Business Intelligence Workplace |
45h |
| Programming Languages |
75h |
| Query and Reporting Tools |
75h |
| Data Integration Platforms |
75h |
| Business Intelligence Concepts and Architecture |
60h |
| Data Warehouse |
75h |
| Database Server |
75h |
| ETL functionality and artificial intelligence |
75h |
| Architecture and Modeling |
75h |
| Reports and Dashboards |
75h |
| Information Security |
60h |
| e-commerce |
75h |
| Computer Network Monitoring |
75h |
| Master Data Management |
75h |
| Development of data exchange services |
75h |
| Business Intelligence Internship |
285h |
| Total: 1350 Hours/ 24 Month |
Please contact us to view Tuition Fees
ADMISSION REQUIREMENTS
By virtue of the provisions contained in Article 4 of College Education Regulations concerning the admission requirements, that it, the person who has a training deemed sufficient by the college and who meets one of the following conditions:
- The person interrupted her full-time studies or pursued full-time post-secondary studies for at least 2 consecutive sessions or 1 school year;
- The person is subject to an agreement concluded between the college and an employer or she benefits from a government program;
- The person interrupted her full-time studies during a semester and pursued full-time post-secondary studies during a semester;
- The person holds a Diploma of Professional Studies (DEP). College Canada Inc. recognizes as training deemed sufficient:
-
a) a person holding a high school diploma, or the equivalent issued by a school board;
or
b) a person with extensive professional experience related to the area of the program specialization;
or
c) the person with relevant training related to the field of the program specialization.
Program-specific requirements: after successful completion of the mathematics course TS5, SN5 or 526.
REQUIRED DOCUMENTS
- Complete admission form
- Copy of diploma and official transcripts (English or French)
- Resume (Curriculum vitae)
- Professional certificate or work certificate (Optional)
- Birth certificate
- Copy of passport (international student)
- Proof of address
- 2 photos
- Admission and registration fees: 250 $
LANGUAGES
All applicants to an Attestation of Collegial Studies (AEC) program must have sufficient oral and written skills in the program instruction language. The College may require that a candidate, whose mother tongue is neither French nor English, to take a standardized language test or a test prepared on site.
To be admitted to an AEC program in French, the minimum acceptable score at the Test de Français International (TFI) is 500.
To be admitted to an AEC program in English, the minimum score required at the International English Language Test System (IELTS) is 6.0. These results can be compared to other levels of standardized tests.
