Become a Business Intelligence Analyst
Become a Business Intelligence Analyst
Fast Track Your Career
Fast Track Your Career
Master essential BI skills from database fundamentals and SQL to advanced Azure data warehousing, while building automated pipelines, creating impactful dashboards, and developing practical business solutions that communicate critical insights to decision-makers—all through our specialized blended learning approach.
Talk to an Advisor
Talk to an Advisor
Duration
8 Months
Duration
8 Months
Duration
8 Months
Start Date
Registration Deadline
Start Date
Registration Deadline
Start Date
Registration Deadline
Program Overview
Program Overview
Transform your career as a Microsoft Business Intelligence Analyst/Developer and empower organizations to unlock the full potential of their data. You'll design secure, scalable solutions that drive real business impact using cutting-edge Azure technologies including Azure Data Factory, Azure Databricks, Azure Synapse Analytics, and Power BI. MCIT's Business Intelligence Program has been developed in collaboration with leading BI professionals who work for Fortune 500 companies in Montreal, ensuring our curriculum stays current with industry demands.
With hands-on, project-based learning in small, personalized classes led by expert instructors, this program is ideal for career changers and professionals ready to advance into high-demand BI roles where data drives million-dollar decisions.
Course Outline
Course Outline
AEC Program – Business Intelligence and Visualization Analyst (LEA.CV) Profile: Microsoft Business Intelligence Analyst / Developer
Download Outline
Introduction to Data Science and Engineering
This course provides an overview of the fundamental concepts and practices in the fields of Data Engineering, Data Science and Big Data. It explores the techniques, tools, and methodologies used to collect, analyze, and derive valuable insights from data, catering to the growing demand for data-driven decision-making in various industries.
SKILLS GAINED
Framer is a web builder for creative pros. Be sure to check out framer.com to learn more.
Framer is a web builder for creative pros. Be sure to check out framer.com to learn more.
SKILLS GAINED
……………………..
Introduction to Data Science and Engineering
This course provides an overview of the fundamental concepts and practices in the fields of Data Engineering, Data Science and Big Data. It explores the techniques, tools, and methodologies used to collect, analyze, and derive valuable insights from data, catering to the growing demand for data-driven decision-making in various industries.
SKILLS GAINED
……………………..
Framer is a web builder for creative pros. Be sure to check out framer.com to learn more.
Framer is a web builder for creative pros. Be sure to check out framer.com to learn more.
SKILLS GAINED
……………………..
Fundamentals of SQL Programming
The course focuses on teaching individuals how to use SQL Server product features and tools related to implementing a database server. This training provides students with the technical skills required to write SQL queries. This course on SQL Server is the basis for all various roles related to Data Science like Data engineer, Data Scientist, Database Administration.
SKILLS GAINED
……………………..
Framer is a web builder for creative pros. Be sure to check out framer.com to learn more.
Framer is a web builder for creative pros. Be sure to check out framer.com to learn more.
SKILLS GAINED
……………………..
Data Visualization and Reporting Tool (Power BI)
This course on Data Visualization and Reporting teaches participants to use Microsoft Power BI for data analysis, visualization, and decision-making. It covers statistical concepts and techniques while focusing on creating reports, KPIs, and dashboards. Students will learn how to apply Power BI for practical data-driven insights. Upon completion, they will be proficient in the latest reporting technologies and methods.
SKILLS GAINED
……………………..
Data Visualization and Reporting Tool (Power BI)
This course on Data Visualization and Reporting teaches participants to use Microsoft Power BI for data analysis, visualization, and decision-making. It covers statistical concepts and techniques while focusing on creating reports, KPIs, and dashboards. Students will learn how to apply Power BI for practical data-driven insights. Upon completion, they will be proficient in the latest reporting technologies and methods.
SKILLS GAINED
……………………..
Azure Data Warehousing & Data Pipelines
This course introduces beginners to building scalable data solutions in Azure. Learn to design and implement data warehouses using Azure Synapse Analytics and create data pipelines with Azure Data Factory for efficient data integration and transformation. By the end of this course, you'll be prepared to manage large-scale data workflows and analytics in the cloud.
SKILLS GAINED
……………………..
Azure Data Warehousing & Data Pipelines
This course introduces beginners to building scalable data solutions in Azure. Learn to design and implement data warehouses using Azure Synapse Analytics and create data pipelines with Azure Data Factory for efficient data integration and transformation. By the end of this course, you'll be prepared to manage large-scale data workflows and analytics in the cloud.
SKILLS GAINED
……………………..
Azure Databricks & Data Services
This course introduces beginners to Azure Databricks, a cloud-based data engineering platform that integrates with Apache Spark. It covers how to process large-scale data, build data pipelines, and use machine learning models for analysis and insights. Students will learn how to work with data using Azure Databricks and explore various Azure data services for data engineering.
SKILLS GAINED
……………………..
Azure Databricks & Data Services
This course introduces beginners to Azure Databricks, a cloud-based data engineering platform that integrates with Apache Spark. It covers how to process large-scale data, build data pipelines, and use machine learning models for analysis and insights. Students will learn how to work with data using Azure Databricks and explore various Azure data services for data engineering.
SKILLS GAINED
……………………..
Career Development
This course is designed to teach students how to integrate themselves into the Canadian job market. In 4 short classes, we look at the kind of mindset that is needed to be successful in the job search process, how to shape the CV and cover letters, we practice interview skills, and much more.
SKILLS GAINED
……………………..
Career Development
This course is designed to teach students how to integrate themselves into the Canadian job market. In 4 short classes, we look at the kind of mindset that is needed to be successful in the job search process, how to shape the CV and cover letters, we practice interview skills, and much more.
SKILLS GAINED
……………………..
Azure Data Engineering Project
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.
SKILLS GAINED
……………………..
Azure Data Engineering Project
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.
SKILLS GAINED
……………………..
SKILLS GAINED
……………………..
SKILLS GAINED
……………………..
SKILLS GAINED
……………………..
SKILLS GAINED
……………………..
SKILLS GAINED
……………………..
Fundamentals of SQL Programming
The course focuses on teaching individuals how to use SQL Server product features and tools related to implementing a database server. This training provides students with the technical skills required to write SQL queries. This course on SQL Server is the basis for all various roles related to Data Science like Data engineer, Data Scientist, Database Administration.
SKILLS GAINED
Data Visualization and Reporting Tool (Power BI)
This course on Data Visualization and Reporting teaches participants to use Microsoft Power BI for data analysis, visualization, and decision-making. It covers statistical concepts and techniques while focusing on creating reports, KPIs, and dashboards. Students will learn how to apply Power BI for practical data-driven insights. Upon completion, they will be proficient in the latest reporting technologies and methods.
SKILLS GAINED
Azure Data Warehousing & Data Pipelines
This course introduces beginners to building scalable data solutions in Azure. Learn to design and implement data warehouses using Azure Synapse Analytics and create data pipelines with Azure Data Factory for efficient data integration and transformation. By the end of this course, you'll be prepared to manage large-scale data workflows and analytics in the cloud.
SKILLS GAINED
Azure Databricks & Data Services
This course introduces beginners to Azure Databricks, a cloud-based data engineering platform that integrates with Apache Spark. It covers how to process large-scale data, build data pipelines, and use machine learning models for analysis and insights. Students will learn how to work with data using Azure Databricks and explore various Azure data services for data engineering.
SKILLS GAINED
Career Development
This course is designed to teach students how to integrate themselves into the Canadian job market. In 4 short classes, we look at the kind of mindset that is needed to be successful in the job search process, how to shape the CV and cover letters, we practice interview skills, and much more.
SKILLS GAINED
Azure Data Engineering Project
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.
SKILLS GAINED
SKILLS GAINED
SKILLS GAINED
SKILLS GAINED
How to Apply
How to Apply
Scholarships
Financial Aid
Financial Aid
Admission
process
Eligibility
Admission Process
Step 1: Book an Appointment with an Advisor
Step 2: Prepare Your Documents
Diploma and transcripts (High School, CEGEP, College, or University)
Birth Certificate (in English or French)
Proof of Canadian status
French language proficiency proof
Current resume
Two government-issued photo IDs
Step 3: Pay Application Fees
$50 application + $150 registration.
Step 4: Submit Your Application Form
Talk to an Advisor
Financial Aid
Scholarships
Scholarships
Admission process
Eligibility
Our financial partners offer loans and personalized support to local entrepreneurs and internationally trained professionals.
You can also apply with the government to get financial aid through the AFE loan program (Aide financière aux études/Student financial assistance).
➔ Attend an Info Session
➔ Meet an Advisor
➔ Submit Documents
➔ Get Scholarship
➔ Begin your Career
Attend an infosession
Scholarships
Financial Aid
Scholarships
Scholarships
Admission process
Eligibility
Our financial partners offer loans and personalized support to local entrepreneurs and internationally trained professionals.
You can also apply with the government to get financial aid through the AFE loan program (Aide financière aux études/Student financial assistance).
➔ Attend an Info Session
➔ Meet an Advisor
➔ Submit Documents
➔ Get Scholarship
➔ Begin your Career
Attend an infosession
Scholarships
Reach us
Reach us
Meet & Greet
Schedule a meeting with our Advisors and discuss all the opportunities at MCIT.
Meet us
Meet & Greet
Schedule a meeting with our Advisors and discuss all the opportunities at MCIT.
Meet us
Schedule a meeting with our Advisors and discuss all the opportunities at MCIT.
1:1 with Advisor
Meet us
Schedule a meeting with our Advisors and discuss all the opportunities at MCIT.
1:1 with Advisor
Meet us
Info Sessions
Schedule a meeting with our Advisors and discuss all the opportunities at MCIT.
Meet us
i
Info Sessions
Schedule a meeting with our Advisors and discuss all the opportunities at MCIT.
Meet us
i
Become job ready
Become job ready
Networking Events
Networking Events
Financial Aid
Resume Preperation
Mentorship & Guidance:
Portfolio Preperation
Networking Events
Events That Make You Job-Ready
At MCIT, our programs go beyond the classroom. We create opportunities to connect, grow, and get hired through a range of career-focused events:
Intelligent Networking Events
Curated sessions designed to connect you with industry professionals and hiring companies.Instructor-Led Introductions
Our instructors share their own professional networks, opening doors to real-world opportunities.Peer-to-Peer Networking
Engage with classmates and alumni to build meaningful connections within your industry.Meet the Recruiter
Participate in exclusive events where recruiters come to meet, mentor, and hire MCIT students.
Attend an infosession
Resume preperation
Networking Events
Resume Preperation
interview Preperation
Portfolio
Preparation
Craft a Winning Resume & Land Your Dream Job Faster!
Your resume is your first impression on potential employers
Join our Resume Preparation Workshop to learn how to create a standout resume that highlights your skills, experience, and strengths in a way that grabs employers’ attention.
Attend an infosession
Resume preperation
Networking Events
Resume Preperation
interview Preperation
Portfolio
Preparation
Craft a Winning Resume & Land Your Dream Job Faster!
Your resume is your first impression on potential employers
Join our Resume Preparation Workshop to learn how to create a standout resume that highlights your skills, experience, and strengths in a way that grabs employers’ attention.
Attend an infosession
Upon successful completion the college grants the student an AEC (Attestation d’études collégiale)
Business Intelligence and Visualization Analyst (LEA.CV)
-8 months-
Upon successful completion the college grants the student an AEC (Attestation d’études collégiale)
Business Intelligence and Visualization Analyst (LEA.CV)
-900 hrs-
Instructor Spotlight
Michel Chamoun
Data Science & Business Analyst
5 Years
Michel is a highly skilled developer and consultant with expertise in AI, data analysis, and process optimization. As a developer in the GenAI team, he built proof-of-concepts leveraging chatGPT's natural language understanding capabilities and implemented AI modules on Microsoft Azure. As a consultant in the strategy and operations team, he designed algorithms for user access profiling.
Zahid Hossain
EPM & Data Analytics Delivery Lead
15 + Year
A fleeting Industry expert with over a decade in Business Intelligence and Analytics spent primarily in Tableau BI applications, Microsoft Power BI, OAC, PBCS, Data management, OBIEE and Essbase mostly in the big four consulting firms. An MBA and IT graduate who combines business goals with technological prowess. Dispenses his passion for knowledge & learning through teaching Business Intelligence & Data methodologies to ardent aspirants.
Parminderjit Singh
Senior Data Architect.
15 + Years
Parminder Jit Singh, with over 17 years of experience, is a highly skilled professional in MS SQL Server Azure and related technologies. He specializes in MS BI (SSIS, SSAS, SSRS), SharePoint, SQL Query Analyzer, SQL Server Management Studio, and Business Intelligence Development Studio. Parminder's expertise in delivering essential IT solutions is matched by his accessible mentoring style, guiding aspiring professionals effectively.
Intructor spotlight
Michel Chamoun
Data Science & Business Analyst
5 Years
Michel is a highly skilled developer and consultant with expertise in AI, data analysis, and process optimization. As a developer in the GenAI team, he built proof-of-concepts leveraging chatGPT's natural language understanding capabilities and implemented AI modules on Microsoft Azure. As a consultant in the strategy and operations team, he designed algorithms for user access profiling.
Zahid Hossain
EPM & Data Analytics Delivery Lead
15 + Year
A fleeting Industry expert with over a decade in Business Intelligence and Analytics spent primarily in Tableau BI applications, Microsoft Power BI, OAC, PBCS, Data management, OBIEE and Essbase mostly in the big four consulting firms. An MBA and IT graduate who combines business goals with technological prowess. Dispenses his passion for knowledge & learning through teaching Business Intelligence & Data methodologies to ardent aspirants.
Parminderjit Singh
Senior Data Architect.
15 + Years
Parminder Jit Singh, with over 17 years of experience, is a highly skilled professional in MS SQL Server Azure and related technologies. He specializes in MS BI (SSIS, SSAS, SSRS), SharePoint, SQL Query Analyzer, SQL Server Management Studio, and Business Intelligence Development Studio. Parminder's expertise in delivering essential IT solutions is matched by his accessible mentoring style, guiding aspiring professionals effectively.
Connect to Content
Add layers or components to make infinite auto-playing slideshows.
Student stories
Student stories
David Parr
@BeingMani97
My name is David Parr, Engineering graduate from McGill University. I am a Software developer, a set of skills that I substantially ascribed to Montreal College.
Abdullah Allukazai
@dvdwinden
After completing my diploma in BI at Montreal College, I was able to land my first job at Bell Canada, where I am currently working with the Intelligence & Analytics team.
Sihame Benhilima
Iam an Engineering grad(Diploma) from Morocco, I discovered MCIT during my Masters at the Technology University Montreal. Studying at MCIT helped me open up my Career prospects manyfold.With absolutely no background in IT I think the teachers helped me learn a lot in the program. The teachers industry experience helped us understand the needs of companies. Initially I was very unsure of my decision, but looking back I realise it was a worthwhile decision
David Parr
@BeingMani97
My name is David Parr, Engineering graduate from McGill University. I am a Software developer, a set of skills that I substantially ascribed to Montreal College.
Abdullah Allukazai
@dvdwinden
After completing my diploma in BI at Montreal College, I was able to land my first job at Bell Canada, where I am currently working with the Intelligence & Analytics team.
Sihame Benhilima
Iam an Engineering grad(Diploma) from Morocco, I discovered MCIT during my Masters at the Technology University Montreal. Studying at MCIT helped me open up my Career prospects manyfold.With absolutely no background in IT I think the teachers helped me learn a lot in the program. The teachers industry experience helped us understand the needs of companies. Initially I was very unsure of my decision, but looking back I realise it was a worthwhile decision
Program Cohorts
Upcoming sessions
& Schedule
Fall
Apply Early
Oct 1, 2025
Register Before
Sep 3, 2025
Fall
Apply Early
Oct 1, 2025
Register Before
Sep 3, 2025
Winter
Apply Early
Feb 13, 2026
Register Before
Jan 16, 2026
Winter
Apply Early
Feb 13, 2026
Register Before
Jan 16, 2026
Summer
Apply Early
Jun 13, 2026
Register Before
May 15, 2026
Summer
Apply Early
Jun 13, 2026
Register Before
May 15, 2026
FAQs
FAQs
What is Business Intelligence (BI)?
What is MCIT’s Microsoft Business Intelligence Analyst / Developer program about?
What is Business Intelligence (BI)?
What does a Business Intelligence Analyst/Developer do?
What is Business Intelligence (BI)?
What are the benefits of taking this Business Intelligence Analyst/Developer program at MCIT?
What is Business Intelligence (BI)?
Who are the instructors for Business Intelligence Analyst/Developer program?
What is Business Intelligence (BI)?
How do I enroll in the Business Intelligence Analyst/Developer program ?
What is Business Intelligence (BI)?
What is the average salary of a Business Intelligence Analyst/Developer program in Canada?
What is Business Intelligence (BI)?
What career paths can I pursue after Business Intelligence Analyst/Developer program?
What is Business Intelligence (BI)?
Do Business Intelligence Analysts/Developers need prior coding experience?
What is Business Intelligence (BI)?
Can I join this Business Intelligence Analyst/Developer program if I have no technical background?
What is Business Intelligence (BI)?
What is Business Intelligence (BI)?
Can I join this Business Intelligence Analyst/Developer program if I have no technical background?
Business Intelligence and Visualization Analyst LEA.CV Profile: Microsoft BI Analyst
Business Intelligence and Visualization Analyst LEA.CV Profile: Microsoft BI Analyst
What is Business Intelligence (BI)?
What is MCIT’s Microsoft Business Intelligence Analyst / Developer program about?
What does a Business Intelligence Analyst/Developer do?
What are the benefits of taking this Business Intelligence Analyst/Developer program at MCIT?
Who are the instructors for Business Intelligence Analyst/Developer program?
How do I enroll in the Business Intelligence Analyst/Developer program ?
What is the average salary of a Business Intelligence Analyst/Developer program in Canada?
What career paths can I pursue after Business Intelligence Analyst/Developer program?
Do Business Intelligence Analysts/Developers need prior coding experience?
Can I join this Business Intelligence Analyst/Developer program if I have no technical background?
Business Intelligence and Visualization Analyst LEA.CV Profile: Microsoft BI Analyst
Montreal College of Information Technology
200-1255 Robert-Bourassa Blvd.
Montreal, Quebec H3B 3B2
+1 514 312 2383
Montreal College of Information Technology
Collège des technologies de l’information de Montréal
200-1255 Robert-Bourassa Blvd.
Montreal, Quebec H3B 3B2
+1 514 312 2383
Montreal College of Information Technology
Collège des technologies de l’information de Montréal
200-1255 Robert-Bourassa Blvd.
Montreal, Quebec H3B 3B2
+1 514 312 2383