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

Business Intelligence and Visualization Analyst
International students need to apply four months before the start date

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.

  • Familiarise with SQL server for BI
    Designed to teach you specific BI & SQL skills to unravel data and make sense of it for critical business decisions.
  • Unleash the force of Power BI
    Use Microsoft Power BI to draw up timely reports, envisage dashboards and valuable insights into a organisation's data .
  • Understand BI Predictive Analysis
    Utilize SAS Azure and other innovative data sets, learning tools to understand historical data to predict the future.
  • Hands-On SQL Programming
    Actively develop hands on programming skills in SQL programming , working on projects that job market demands everyday.
  • Cutting Edge Learning Tools and Infrastructure
    Provide cutting edge infrastructure to provide Business Intelligence tools, data sets and project sandboxes 24/7.
  • BI Industry Expert Instructors
    Our instructors bring in years of professional experience, having spent time in the fields they teach & design courses.
  • Personalized Attention
    We take pride in providing personal attention you seek to solve your unique set of career challenges.
  • Intensive BI Mentorship
    You can take advantage of our years of vast industry knowledge by closely working with our mentors one to one.

KEY FEATURES

  • Business Intelligence and Visualization Analyst

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

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

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

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

    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.
*Industry focus *Job market matched programs *Get trained by industry experts *Learn while you work *Latest tools and frameworks *24/7 Lab access *Co-Op internship available *Over 5000 strong alumni network *State of the Art Infrastructure (dedicated VM for each student)

SKILLS ACQUIRED

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

ELIGIBILITY AND REQUIREMENTS

This is a career starter program. Applicants with Post-secondary studies in Business Management, Social Science or Information Technology, are a good match for this AEC. Having a CEGEP Diploma, or relevant experience of at least 1 year make you as well a good candidate. Students need the following (minimum) ministry stipulated requirements: Secondary V / High School Diploma with good knowledge of Microsoft Office Applications (Word, Excel, PowerPoint)

To determine your eligibility, you need to meet with an advisor.

Upon successful completion  the college grants the student an AEC (Attestation d’études collégiale)

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

Certification Tracks
 CBIP 
 Cloudera 
 

COURSE OUTLINE

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

<Download Outline>

This module will cover the basics of business intelligence. Basic skills on how to build and manage a data warehouse platform for business intelligence applications are covered, but emphasis is given to people and processes, with an introduction to the technologies involved.

SQL is the foundation of most data tools used today. With SQL, you don’t have to rely on others sending you data and executing queries for you. This allows you to be independent and dig deeper into the data to obtain answers that might improve the way your company does business. This course provides all the knowledge and structure needed to be proficient in SQL.

In this module, you extract data from a wide variety of sources, such as files and relational data sources, apply data integration and transformation solutions, and load data into single or multiple destinations. You solve complex business problems using best practices and troubleshooting techniques.

When you have large volumes of data, you need intuitive, interactive and high-performance access to your data. In this module, you learn how to import tables of data from different sources and relate them to form the foundation of your model. You then learn how to enhance your model with usability features, such as hierarchies. Additional topics include how to manage a tabular database along with table storage, processing, permissions and deployment.

You will learn SQL Server Reporting Services to create and deploy high-level interactive reports for mobile and desktop. Reading data information in visualization mode enables to see analytics presented visually. In other words, an end-user can drill down into charts and graphs for more detail.

The Power BI Business analytic service tool will allow you to create and enhance interactive visualization, with self-service BI capabilities. It has the capacity to connect with and retrieve information from any database.

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.

INSTRUCTOR SPOTLIGHT

STUDENT LOANS & SCHOLARSHIPS

If you need any guidance for financial aid and our various government grants, please see the following and speak with an advisor for further details. Each student case is unique but we offer a variety of methods to help our students get the education they need to succeed.

Apply for a Scholarship

AFE – Aide financière aux études/Student financial assistance 

As all our diploma programs are officially recognized and approved by the Ministry of Education of Quebec, if financial aid for students is required, you can apply with the government of Quebec to get the assistance through the AFE loans. Scholarships – MCIT also offers scholarships for a select few students in the form of reduced payments offered through through our financial program.

Talk to an advisor to determine your eligibility

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. Most importantly, the school has also delivered on its commitment to provide an industry internship program. 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
  • Business Intelligence and Visualization Analyst
  • Business Intelligence and Visualization Analyst
  • Business Intelligence and Visualization Analyst
  • Business Intelligence and Visualization Analyst
  • Business Intelligence and Visualization Analyst

CALENDAR

— 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 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
Not at this time, but please consult our Financial Aid section for information on grants and loans.
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 (or 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

Collège des TI de Montréal   

110-1255 Robert-Bourassa Blvd.
Montreal, Quebec H3B 3V8

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