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
6:00 pm - 9.00 pm
13 October 2023- International
Students >>
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.
GRADUATION STATS
- 60%+ of grads are employed within 180 days of graduation.
- 95%+ of our grads found a relevant job with 1 year of graduation.
- 95 days is the average time it takes a grad to find their first job in the field.
- $65,000 CAD is the average starting salary after graduation.
- See if you Qualify
- Talk to an Advisor
KEY FEATURES
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.
COURSE OUTLINE
AEC Program – Business Intelligence and Visualization Analyst (LEA.CV)
-(900 hrs)-
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.
SKILLS ACQUIRED
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
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
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.
Aimable Karangwa
With a masters in IT management and Certified Business Analyst Professional (CBAP) certification, Aimable is an industry standard Business Analysis expert. A PMI-Agile Certified Practitioner (PMI-ACP) with PRINCE2 Foundation certification, he has over 17 years of experience and has risen to be a senior business analyst consultant. Additionally, he is an instructor at our college, sharing his expertise with aspiring business analysts.FINANCIAL AID AND LOANS
Our financial partners offer loans and personalized support to local entrepreneurs and internationally trained professionals.
MCIT SCHOLARSHIPS
The Montreal College of Information Technology awards scholarships prospective students to make quality education more accessible.
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 two months before the starting date. Talk to one of our advisors for more details about the registration process.
