Business Intelligence and Visualization Analyst LEA.CV: Profile Microsoft BI Developer
Become a Business Intelligence Developer
Learn to master the fundamentals of databases, SQL, data warehousing, data modelling, 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-
Mode of Delivery: Hybrid & Online
OVERVIEW
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.
- See if you Qualify
- Talk to an Advisor
COURSE OUTLINE
AEC Program – Business Intelligence and Visualization Analyst (LEA.CV)
-(900 hrs)-
This course provides an overview of the fundamental concepts and practices in the fields of Business Intelligence (BI), 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 business intelligence, Data Scientist, Big Data Developer, Database Administration.
This course on Data Visualization and Reporting is designed to equip participants with the essential skills and knowledge needed to effectively utilize Microsoft Power BI for data analysis and visualization, combined with a strong foundation in statistical concepts and techniques. It provides a comprehensive understanding of both statistical methodologies and the practical application of Power BI for making data-driven decisions. After completing this course, students will be able to create reports, KPIs and dashboards using Power BI, the latest reporting technologies, and methods.
This course covers the most important step in Business Intelligence; the preparation of the data for: analysis, reporting, data warehousing and mining. In this course, we use SQL Server Integration Service (SSIS), a component from Microsoft SQL Server Database Software that is used to implement a wide range of data migration tasks. SSIS is a graphical, fast and flexible data warehousing tool used for data extraction, loading and transformations like cleaning, aggregation and merging data from a variety of sources such as: SQL Server Databases, Oracle, DB2, Azure, Excel, Text, CSV, Json, XML files etc.
In this course, students will acquire the knowledge of multidimensional and tabular data models by using SQL Server Analysis Services (SSAS). The course will help students learn dimensional modelling using Star/Snowflake/Hybrid schemas to create DataMart and data warehouses. These are used by the stakeholders, clients and/or businesses for deep analysis and data mining. It is a unique way of representing the data using different dimensions very quickly, effectively and with minimal code.
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 want to become any of the following
Business Intelligence Analyst | Data Analyst | Reporting Analyst | SQL Developer | ETL Developer | Business Intelligence Developer | Speak to an advisor to determine eligibility.
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.
Merrit 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 fromPartners
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 student— F.A.Q —
Our Business Intelligence program equips students with the skills and knowledge to analyze business data effectively using Microsoft tools such as Power BI, SQL Server,SSIS, SSAS & SSRS. The program covers data visualization, reporting, data modeling, and dashboard development to help students become proficient BI professionals.
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
Our programs utilize a combination of lectures, hands-on lab exercises, case studies, and real-world projects to ensure a comprehensive learning experience. We also provide access to online resources and support forums for additional learning.
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.
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.
