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: Profile Microsoft BI Developer

Business Intelligence and Visualization Analyst
  • Fast Track : 8 Months

    Schedule:
    Monday, Wednesday, Friday

    18h00 to 21h00
  • 14 June 2024

    Mode of Delivery:
    Hybrid & Online
  • Attend an Info Session

    July 10 2024
    6PM-7PM
    Online

     

  • Talk to an Advisor

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.

COURSE OUTLINE

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

Download Outline

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 helps you to be job ready.

NETWORK EVENTS

The Intelligent Networking Networking with companies Instructors sharing their network Peer to peer networking Meet with recruiters.

NETWORK EVENTS
X NETWORK EVENTS

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.

INTERVIEW PREPARATION
X INTERVIEW PREPARATION

We assist you turn your projects into relevant portfolios.

PORTFOLIO PREPARATION

Turn your projects into a portfolio Portfolios tell your story Relevancy of the projects display experience.

PORTFOLIO PREPARATION
X PORTFOLIO PREPARATION

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!  


MENTORSHIP
X MENTORSHIP

WHO SHOULD APPLY?

Career starters : For those people who are either entering the job market or are interested in making a shift in their current job status. MCIT’s BI program can help you transition into, or start a new career as a fully equipped Business Intelligence Developer.
Career advancers : Get a grip on how-to techniques, tools and terminologies to collect and process business information to derive insights and make business decisions
Professionals : Skilled data miners and analytics personnel, the BI program can further help you learn how to take that data, formulate actionable plans and present it to relevant stakeholders.
Fresh Graduates : New university graduates who ' d like to expand their skillset and augment their academic credentials.
Business Intelligence and Visualization Analyst
Sihame B

BI Developer, Groupe Touchette

Business Intelligence and Visualization Analyst
Mario A

BI Developer, National Bank, Canada

Business Intelligence and Visualization Analyst
Aasma Lit M

BI Developer, Montreal College

Business Intelligence and Visualization Analyst
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

Determine eligibility 

Eligibility criteria includes full-time studies for at least one year, covered by a college-employer agreement or government program or having a combination of interrupted and full-time studies besides the foll.


  • Holding a professional studies, diploma
  • Demonstrating proficiency in hardware, operating systems, and Microsoft Office applications
  • Recommended Mathematics Secondary 4 CST
  • Possessing basic knowledge in operating systems as well as one of the following:
  • Networking, ERP, or Object-oriented Programming.

Determine eligibility 

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

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.

OtherOptions

We also have scholarships
for students who were laid off recently
in the past 6 months.

montrealcollege

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.

ApplicationAdvice

Our financial partners offer loans and personalized support to local entrepreneurs and internationally trained professionals.

montrealcollege

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

    CALENDAR

    Registration 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.

    — 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 "desktop" in the classroom. However, students can bring their own laptops.
    You can visit the College from Monday to Friday between 9 a.m. and 5 p.m. Individual appointments can be scheduled by calling the Montreal College office at 514-312-2383. Info Sessions are also regularly hosted, during which students can gain an in-depth understanding of their program of interest and meet with industry experts.
    We offer flexible schedule during daytime, evenings and weekends
    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 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.

    Montreal College of Information Technology

    200-1255 Robert-Bourassa Blvd.
    Montreal, Quebec H3B 3B2

    +1 514-312-2383
    .(JavaScript must be enabled to view this email address)