● This module introduces data warehouse concepts, architecture consideration, main hardware considerations for building a data warehouse, and designing and implementing a schema for a data warehouse.
Montreal College of Information Technology
Collège des technologies de l’information de Montréal
CERTIFICATES
MCSA – SQL 2016 BI Development
State of the Industry
As a business intelligence specialist, you help organizations collect and process the intelligence that helps them stay competitive. This fast-paced course provides IT professionals with the knowledge and skill to provision a Microsoft SQL Server database (on-premise and in Azure) and creates managed BI solutions. This course also covers the implementation of multidimensional and tabular data models along with the creation of cubes, dimensions, measures, and measure groups. After completing the course, professionals are able to implement the logical and physical design of a data warehouse, deploy SSIS projects, implement Azure SQL Data warehouse and dimensions in the cube, as well as perform data mining techniques for predictive analysis. This course prepares professionals for two official Microsoft certifications.
- English
- 64 hours*
- As per demand
- Talk to an
ADVISOR
* Morning, evening, weekends
Professional Benefits
The average annual salary for a business intelligence specialist is $79,641, with a usual range between 56 and 111K.
Who Should Apply
BI developers
Database professionals
IT professionals
Dwany H
Big Data Developer
Rosana N
Java Developer
Sihame B
BI Developer
Chloe D
STQA
Abilities acquired
at course completion
Creating data warehouse architecture
Implementing the logical and physical design of a data warehouse
Creating and working with Columnstore indexes
Implementing an Azure SQL data warehouse
Implementing an ETL solution with SSIS
Deploying and configuring SSIS packages
Analyzing data with Azure SQL data warehouse
Creating multidimensional databases
Configuring measure and measure groups.
MDX and cube functionality
Implementing a tabular data model by using analysis services
DAX and performing predictive analysis with data mining.
WHAT YOU WILL LEARN COURSE OUTLINE
MCSA – SQL 2016 BI Development
This module focuses on Azure SQL data warehouses and on data and control flow in a SSIS package. This module also covers debug and troubleshoot SSIS packages.
This module focuses on implementing SSIS solutions that support incremental DW loads, on changing data, and on how to implement master data services that enforce data integrity at source.
This modules examines the configuration and deployment of SSIS packages in sample production environments. This includes creating SSIS packages and environments for an SSIS solution.
This module introduces key BI concepts and the Microsoft BI product suite. It also focuses on creating multidimensional databases using SQL Server Analysis Services. It also covers attribute hierarchies, relationship hierarchies and dimension attributes.
This module examines the implementation of dimensions in a cube along with measures and measure groups in a cube.
This modules covers the syntax and usage of MDX. Participants will learn the customization of cube functionality, implementing key performance indicators (KPIs), and using perspectives and translations.
SKILLS ACQUIRED
Data warehousing solutions
Logical and physical design of data warehouse
Working with indexes
Azure SQL data warehouse
ETL solution with SSIS
Master data services
Multi dimensional databases
Cubes, dimensions, MDX, DAX
Tabular data model by using analysis services
Data mining
CERTIFICATION EXAMS
70-767 - Implementing a Data Warehouse using SQL.
70-768 - Developing SQL Data Models.
TOP REASON
TO JOIN MCIT
- Industry-relevant, job-ready programs
- Internship possibilities
- Eligibility for off-campus work permit program [ocwpp]
- Eligibility for post-graduation work permit [pgwp]
- Eligibility for points under Quebec’s immigration policy
- Scholarships and financial aid
INSTRUCTOR SPOTLIGHT
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.
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.
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.
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.
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.
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.COMMUNITY TESTIMONIAL
The AEC program at MCIT helped me gain a solid understanding of mobile app development modules, algorithms, data structures, JUnit, MVC patterns, and enterprise solutions.
Maria Angela Diaz — Mobile Development Student
