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.
Montreal College of Information Technology
Collège des technologies de l’information de Montréal
PROGRAMS
LEA.CV Business Intelligence and Visualization Analyst
State of the Industry
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.
- 8 months*
- 7 October 2019
- Talk to an
ADVISOR
*6-month class + 2-month project
- Annual salary range $56,000 – $112,000
- Average annual salary
is $61,705 per year
Professional benefits
With business intelligence solutions, organizations can implement corrections and take the necessary measures to improve efficiency in various operational areas. An organization may also identify new business opportunities and expand accordingly. Business analysts play a key role in these initiatives. After completing the course, students can apply for these roles:
Business intelligence administrator
Business intelligence consultant
Business intelligence analyst/developer
Business intelligence project manager
SKILLS ACQUIRED
SQL programming
SQL Server Integration Services (SSIS)
SQL Server Analysis Services (SSAS)
SQL Server Reporting Services (SSRS)
OLAP cubes and reports
Power BI
Data mining
Predictive analysis concepts
Data Reporting
Business Intelligence Key Concepts
Gathering and Managing Data
Who should apply
This program is intended for individuals possessing creative abilities who want to make a career change or are looking to grow their business. Here is a list of professionals for whom learning business intelligence has turned out to be a great asset:
Marketing professionals
Business owners
IT professionals
Sihame B
BI Developer
Asmaa M
BI Developer
Mario A
BI Developer
Olga Zamora D
BI Student
Upon successful completion of the program, the college grants the student an AEC (Attestation d’études collégiales)
Business Intelligence and Visualization Analyst (LEA.CV)
Certification Tracks
WHAT YOU WILL LEARN COURSE OUTLINE
AEC Program – Business Intelligence and Visualization Analyst (LEA.CV)
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.
INSTRUCTOR SPOTLIGHT
Gregory Shinder
I love working with SQL Server, especially to solve performance problems. Have a poor-performing query? Challenge accepted! I also like to design and implement high availability and disaster recovery solutions. When I’m not trying to break another SQL server, you’ll find me teaching SQL.
Dhruv Gusain
Enterprise Java developer with a passion for sports. My Aim, to have a connection with the students and make them understand the crux of any concept.
Ayda Ghasemi
I am a SQL instructor at MCIT and a member of the Data and BI team at Couche-Tard. I have expertise in Microsoft Azure stack on-premises and in Azure cloud. I hold a bachelors in Physics and an MBA. I also spent a year as a BI developer at MCIT.
Haythem Rehouma
I am a full-stack and mobile developer who works on native mobile (Android and iOS) and cross-platform (PhoneGap/Ionic/ReactNative/Angular) apps for both business and consumer customers. Examples of my apps included location-based services and sensors.
Jiji Raghavan
I am a software QA instructor at MCIT where I help students focus on their vision by guiding them through each phase of their career. I have 6 years of experience as a QA engineer and 2 years in teaching. It motivates me as I can see myself as an agent of change in my students’ life. I want to inspire all of my students to be ambitious and make a difference in their life and career.
Kashyap Vedantam
With more than 6 years of industry experience, I’ve developed many applications in various programming languages. I hold a masters in applied computer science from Concordia and am a certified Microsoft SQL developer. I seek to create a classroom atmosphere that is stimulating and makes students feel valued. "Grow by learning something new every day."
Souleyman Sidibe
I am an experienced IT project manager with significant expertise in business intelligence (BI). I hold high-level degrees in IT networking, telecommunications, business intelligence, and programming. I’ve previously worked as a database specialist, an ETL developer, a BI analyst, and a business analyst. My main motivation in teaching is to transfer the knowledge that helps others fulfill themselves.
Toufik Lazri
I am a university graduate in computer engineering and have been developing and implementing computer applications for more than 25 years. I have been teaching Java technologies for more than 10 years. I enjoy passing on my knowledge in a clear and dynamic way in order for students to make a successful transition to the labor market.
Vimal Kapoor
I am a dynamic IT professional with experience in corporate IT systems, network support solutions, and Wipro technologies. I have the proven ability to provide creative and effective server and networking strategies for all Microsoft operating systems and server products.
Aimable Karangwa
I hold a masters in IT management and am a Certified Business Analyst Professional (CBAP), a PMI-Agile Certified Practitioner (PMI-ACP), and have obtained a PRINCE2 Foundation certification. I have 17 Years of experience as a senior business analyst consultant.
Iraj Hedayati
I'm leading the data team at Guavus, a major data analytics company, working with the Hadoop ecosystem. I hold a master's degree in computer science and one in software engineering. I was always eager to pursue teaching, an activity that I thoroughly enjoy.
Marwan
I have over 10 years of Business Intelligence and Analytics experience primary to Tableau BI applications, Microsoft Power BI, OAC, PBCS, Data management, OBIEE and Essbase mostly in the big four consulting firms. I am an MBA and IT graduate where I combine business with technology. In addition, I do have teaching experience for a couple of years as a BI and BA Instructor.COMMUNITY TESTIMONIAL
After completing my diploma in business intelligence at Montreal College, I was able to land my first job at Bell Canada, where I am currently working with the Intelligence & Analytics team.
Abdulla Alkhuzai — BI Student
CALENDAR
— F.A.Q —
Yes. We conduct prerequisite classes that will help you to start the program on a high note.
Each student is provided with a PC in the classroom. However, students can bring in their own laptops.
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, of course you can visit our campus and enquire about our program. You can register for the next upcoming information session through our website. You can also book an appointment to meet our program advisor.
