Montreal College of Information Technology
Collège des technologies de l’information de Montréal English flagEN FlagFR

Business Intelligence and Visualization Analyst (LEA.CV)

Business Intelligence and Visualization Analyst (Dip)
International students need to apply four months before the start date

State of the Industry

As a business intelligence specialist, you help organizations collect and process intelligence and information to keep them competitive. You collect the most current data and use your expertise in IT to improve your employer’s data functions. In this program, you use the Microsoft SQL Server and BI toolset to develop, administer and analyze data. You also learn industry-standard data management best practices and techniques.

MCIT’s Business Intelligence Program was built and is continuously updated, with BI professionals and organizations in Montreal. To stay relevant, and to offer the best career prospects to our students, industry experts follow your learning path in small, personalized classes, using the latest technologies. The power of BI is now used across all industries, making it a smart choice for your career.

6 Months Classes + 2 Months Project/Internship

  • Average annual salary
    is $71,000 in Canada
  • Global business intelligence
    market is predicted to reach
    $29.48 billion by 2022

Professional benefits

With business intelligence solutions, organizations can implement corrections and take the necessary measures to improve efficiency in various operational areas. An organization may also identify new business opportunities and expand accordingly. Business analysts play a key role in these initiatives. After completing the course, students can apply for these roles:

BI Analyst | Data Analyst | SQL Developer | ETL Developer | BI Developer | Data Analytics Specialist | Reporting Analyst | BI Consultant


Who should apply

This program is intended for individuals possessing creative abilities who want to make a career change or are looking to grow their business. Here is a list of professionals for whom learning business intelligence has turned out to be a great asset:

Marketing professionals
Business owners
IT professionals

Sihame B
Sihame B

BI Developer

Asmaa M
Asmaa M

BI Developer

Mario A
Mario A

BI Developer

Olga Zamora D
Olga Zamora D

BI Student


This is an entry-level program, but assumes that learners have the following:


Secondary V / High School Diploma
Good knowledge Microsoft Office Applications (Word, Excel, PowerPoint Presentation)
Completed post-secondary studies (in Business Management or Social Science or Information Technology) or have a CEGEP Diploma or have 1 year of relevant experience


AEC Program – Business Intelligence and Visualization Analyst (LEA.CV)
-(900 hrs)-

<Download Syllabus>

This module will cover the basics of business intelligence. Basic skills on how to build and manage a data warehouse platform for business intelligence applications are covered, but emphasis is given to people and processes, with an introduction to the technologies involved.

SQL is the foundation of most data tools used today. With SQL, you don’t have to rely on others sending you data and executing queries for you. This allows you to be independent and dig deeper into the data to obtain answers that might improve the way your company does business. This course provides all the knowledge and structure needed to be proficient in SQL.

In this module, you extract data from a wide variety of sources, such as files and relational data sources, apply data integration and transformation solutions, and load data into single or multiple destinations. You solve complex business problems using best practices and troubleshooting techniques.

When you have large volumes of data, you need intuitive, interactive and high-performance access to your data. In this module, you learn how to import tables of data from different sources and relate them to form the foundation of your model. You then learn how to enhance your model with usability features, such as hierarchies. Additional topics include how to manage a tabular database along with table storage, processing, permissions and deployment.

You will learn SQL Server Reporting Services to create and deploy high-level interactive reports for mobile and desktop. Reading data information in visualization mode enables to see analytics presented visually. In other words, an end-user can drill down into charts and graphs for more detail.

The Power BI Business analytic service tool will allow you to create and enhance interactive visualization, with self-service BI capabilities. It has the capacity to connect with and retrieve information from any database.

At the end of the program, students work on a real-time, industry-simulated project during which they build databases and extract information from them, create data models, and prepare visualization reports.



MCIT offers scholarships for
deserving students, recent graduates, women, the unemployed and recent immigrants. The College offers up to $2000 off the tuition fees. Limited places for each session.
* This is only available for Local students

Apply for a Scholarship

AFE Student loan program

Students are eligible to apply for full tuition fees through the AFE Student loan program.
* This is only available for Local students

Talk to an advisor to determine your eligibility.


Business Intelligence and Visualization Analyst (Dip)

Canadian Work space

Business Intelligence and Visualization Analyst (Dip)

The art of Networking – How to build a professional network

Business Intelligence and Visualization Analyst (Dip)

Cover Letters writing CV & Resume writing Internship preparation

Business Intelligence and Visualization Analyst (Dip)

Job Search Checklist (Exploration, Preparation, Implementation)

Business Intelligence and Visualization Analyst (Dip)

LinkedIn Profile

Business Intelligence and Visualization Analyst (Dip)

Interview Preparation


After completing my diploma in business intelligence at Montreal College, I was able to land my first job at Bell Canada, where I am currently working with the Intelligence & Analytics team.

Abdulla Alkhuzai — BI Student
  • Business Intelligence and Visualization Analyst (Dip)
  • Business Intelligence and Visualization Analyst (Dip)
  • Business Intelligence and Visualization Analyst (Dip)
  • Business Intelligence and Visualization Analyst (Dip)
  • Business Intelligence and Visualization Analyst (Dip)


— F.A.Q —

Fast track program is designed for local students whereas Regular track is designed for international students
Each student is provided with a PC in the classroom. However, students can bring their own laptops.
Yes, of course you can visit our campus and enquire about our program. You can register for the next upcoming information session through our website. You can also book an appointment to meet our program advisor.
We offer flexible schedule during daytime, evenings and weekends
Not at this time, but please consult our Financial Aid section for information on grants and loans.
Yes, we will. Please consult our Career center section for additional information.
Yes. We conduct prerequisite classes that will help you to start the program on a high note.
- Completed Post-Secondary (or post-secondary) studies in Business Management, Social Science or Information Technology, or CEGEP Diploma, or relevant experience of at least 1 year. -High School – Mathematics Secondary 4 436/4 SN or TS/5 CST - Basic knowledge of SQL is considered an asset.
Yes, there're Teaching Assistants (TAs) available for this program to help you during your labs and ease your learning process.