Business Intelligence and Visualization Analyst LEA.CV
Profile: Microsoft Azure Data Engineer
Become a Data Engineer
Learn to master the fundamentals of databases, SQL, power BI, python programming, data warehousing, data pipleines, report to uncover insights, communicate critical findings, and create data-driven solutions through specialized blended learning.
Fast Track : 8 Months
Schedule: Monday, Wednesday, Friday
18h00 to 21h00-
14 February 2025
Mode of Delivery: Hybrid & Online Attend an Info Session
November 14th
6PM-7PM
Online
OVERVIEW
As a Microsoft Azure Data Engineer, you empower organizations to design, implement, and manage secure, scalable, and efficient data solutions using the Azure platform. You leverage Azure’s suite of data services to streamline data collection, storage, processing, and analysis. This program equips you with expertise in Azure Data Factory, Azure Databricks, Azure Synapse Analytics, and other tools to deliver impactful business insights.
MCIT’s Azure Data Engineer Program has been developed in collaboration with leading data professionals and organizations in Montreal. This ensures the curriculum stays current with industry trends and technologies. The program focuses on providing hands-on experience in data engineering best practices, preparing you for roles in industries where data is the backbone of decision-making. Small, personalized classes and expert-led instruction make this program an ideal choice for aspiring Azure data engineers.
- See if you Qualify
- Talk to an Advisor
COURSE OUTLINE
AEC Program – Business Intelligence and Visualization Analyst (LEA.CV) Profile: Microsoft Azure Data Engineer
-(900 hrs)-
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.
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.
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.
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.
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.
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.
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.
Become ready for the workplace
These MCIT programs help you to be job ready.
NETWORK EVENTS
The Intelligent Networking with companies, instructors sharing their network, Peer to peer networking, Meet with recruiters.
Resume is the key to making the first impact with your profile.
INTERVIEW PREPARATION
Resume building, LinkedIn Training, Mock interviews hosted by companies, Technical interview prep, Behavioral interviews.
We assist you turn your projects into relevant portfolios.
PORTFOLIO PREPARATION
Enhance your portfolio with relevant projects, Tell your story, Relevancy of the projects, Display experience.
Mentorship & guidance - the key to career success.
MENTORSHIP
The Mentors, instructors, or alumni help you understand the required skills for your desired career path and the path to land your dream job!
WHO SHOULD APPLY?
If you aspire to become any of the following roles:
Data Engineer | Data Analyst | ETL Developer | Big Data Engineer | Cloud Data Engineer| Azure Data Engineer Associate
Speak to an advisor to determine your eligibility and learn how this program can help you achieve your career goals.
Sihame B
BI Developer, Groupe Touchette
Mario A
BI Developer, National Bank, Canada
Aasma Lit M
BI Developer, Montreal College
Olga Zamora D
BI Analyst, Industrial Alliance, Canada
Admissions Process
The admission process entails the submission of several key documents. Applicants must provide their diploma and transcripts
- Highest level of education.
- Current resume detailing professional and education
- Birth certificate translated into either English or French
- 2 Photo identification are necessary.
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
Zaid Hossain
Zahid Hossain is a seasoned professional with a rich background in Business Intelligence (BI) and IT projects. Currently serving as the Manager of Business Transformation at MSC Mediterranean Shipping Company in Montreal, Quebec, Canada, Zahid has been instrumental in driving significant changes within the organization.
Parminder Jit Singh
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.Loans & Scholarships
Scholarships for New Graduates
Students who have graduated with a post secondary diploma or degree from a qualifying institution in the last two years.
Scholarships for New Immigrants
Students who have arrived in Canada two years or less at the time of submitting their application.
Merit based Scholarships
The Montreal College of Information Technology offers merit-based scholarships to deserving candidates,for exceptional academic or professional contributions.
Other Options
We also have scholarships
for students who were laid off recently
in the past 6 months.
Empower students through Financial Aid
Conveying our commitment to student success through financial support.
Loans through the Government
Apply with the government to get financial aid through the AFE loan program (Aide financière aux études/Student financial assistance).
Loans from Partners
Our financial partners offer loans and personalized support to local entrepreneurs and internationally trained professionals.
Application Advice
Our financial partners offer loans and personalized support to local entrepreneurs and internationally trained professionals.
COMMUNITY TESTIMONIAL
I am international student from Haiti. I evaluated multiple colleges and choose Montreal College of Management taking into consideration several factors including tuition fee, program content and delivery methodology. Looking back, I feel that I have a made a right choice. The school’s blended training methodology of combining instructor led classroom training with e-learning aids has augmented and fast tracked my learning. I am glad that I have joined Montreal College and I am well and truly on my way to fulfill my career dreams.
Sacha Vieux Roy — Former studentCALENDAR
Registration deadline:
For international students, it is highly recommended to register three months before the starting date. Talk to one of our advisors for more details about the registration process.
— F.A.Q —
This course begins with foundational skills in SQL, Power BI, and Python, crucial for data engineering. You will then learn to design, implement, and manage data solutions using Microsoft Azure services like Azure SQL Database, Azure Data Factory, Azure Databricks, and Azure Synapse Analytics. With hands-on experience, you’ll develop the skills to process, store, and analyze data at scale in the cloud, preparing you for a career in Azure data engineering.
Yes, our programs are designed to accommodate students with varying levels of expertise, including beginners. Our instructors and courses tailored for beginners to provide a solid foundation with varying levels of expertise.
Our course content is curated from industry-recognized leaders such as Enterprise Big Data Framework, Microsoft, Python, ensuring alignment with the latest industry standards and practices. Each program is thoughtfully designed to equip students with the knowledge and skills necessary to excel in their chosen field and to confidently pursue real-world certifications.
To be eligible for a program of study leading to an attestation of college studies (AEC), Student must have training deemed sufficient by the college and meet one of the following conditions:
- have interrupted your full-time studies or pursued full-time post-secondary studies for at least 2 consecutive sessions or one school year;
- be covered by an agreement concluded between the college and an employer or benefit from a government program;
- have interrupted your full-time studies for one session and have pursued full-time post-secondary studies for one session;
- hold a professional studies diploma.
- the program of study makes it possible to acquire technical training in a field for which there is no program of study leading to a college diploma;
- the study program is covered by an agreement concluded between the Minister and a department or agency of the Government of Québec regarding training.
Student must meet all the following requirements:
- Knowledge of computer hardware and Operating Systems like Windows, MacOS.
- Advanced High School mathematics
- Good to have Knowledge on programming language
Graduates of this program can pursue various career paths including business intelligence analyst, data scientist, big data engineer, data engineer, data analyst, and more. Our career services team provides guidance and support for job placement and advancement.
Yes, we offer flexible study options including part-time evening classes and online courses to accommodate students with busy schedules or those unable to attend in person.
Yes, we facilitate internships and practical experience opportunities with industry partners to help students apply their skills in real-world scenarios and gain valuable experience.
A basic understanding of computer systems and networking concepts is recommended.
