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.
Get trained by Industry Experts
Our courses are delivered by professionals with years of experience having learned first-hand the best, in-demand techniques, concepts, and latest tools.Project-Based Learning
Our curriculum is kept up to date with the latest industry trends ensuring all our graduates are prepared for the job market.Learn while you Work
Working closely with our industry expert instructors, they can provide guidance and help you network within the field, providing you with a unique advantage in the workforce.State of the Art Infrastructure
State of the Art facility with over 20 labs, Data centers and server setups in the core of the downtown hub, giving access to , transit, business & entertainment districts.24/7 Lab access
Our students have access to their labs and course materials at any hour of the day to maximize their learning potential and guarantee success.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.
Business Intelligence Analyst | Data Analyst | Reporting Analyst | SQL Developer | ETL Developer | Business Intelligence Developer | Speak to an advisor to determine eligibility.
BI Developer, Groupe Touchette
BI Developer, National Bank, Canada
BI Developer, Montreal College
BI Analyst, Industrial Alliance, Canada
Upon successful completion the college grants the student an AEC (Attestation d’études collégiale)
Business Intelligence and Visualization Analyst (LEA.CV)
-900 hrs-
Our financial partners offer loans and personalized support to local entrepreneurs and internationally trained professionals.
The Montreal College of Information Technology awards scholarships prospective students to make quality education more accessible.
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 studentRegistration deadline:
For international students, it is highly recommended to register two months before the starting date. Talk to one of our advisors for more details about the registration process.