Montreal College of Information Technology
Collège des technologies de l’information de Montréal English flagEN FlagFR


MCSA - SQL 2016 BI Development
State of the Industry

As a business intelligence specialist, you help organizations collect and process intelligence and information that helps them stay competitive. This fast-paced course provides IT professionals with the knowledge and skills to provision a Microsoft SQL Server database and creating a managed enterprise BI solutions. Participants will learn how to provision SQL Server both on-premise and in Azure, and installing from new and migrating from an existing install. This course also covers how to implement both multidimensional and tabular data models along with the creation of cubes, dimensions, measures, and measure groups. After completing the course, professionals would be 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, perform data mining techniques for predictive analysis. This course prepares professionals for two official Microsoft certifications.

​Class Schedule: Tuesday and Thursday (5:30PM to 9:30PM)

Professional benefits

Professionals work in a wide array of companies, from startups to global organizations. The annual salary range for a business intelligence specialist is between $56,000 to $111,000. BI developers, Database professionals, IT professionals

Eligibility and Requirements

Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of relational databases.
Some experience with database design.
Experience of querying data using Transact-SQL.

MCSA – SQL 2016 BI Development

This module introduces students to data warehouse concepts, architecture consideration, main hardware considerations for building a data warehouse, and designing and implementing a schema for a data warehouse.

This module focuses on Azure SQL Data Warehouses and on how to implement them, implement data and control flow in a SSIS package. This module also covers debugging and troubleshooting SSIS packages.

This module is designed to understand the implementation of an SSIS solution that supports incremental DW loads, changing data and how to implement master data services to enforce data integrity at source.

This course examines the configuration and deployment of SSIS packages in a sample production environment. Students also learn about creating SSIS packages and environments for an SSIS solution.

This course introduces students to 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 course covers the syntax of MDX and usage of it. Participants will also learn about customization of cube functionality, implementing key performance indicators, perspectives and translations.

This course is designed to implement a tabular data model in Power Pivot and the usage of data mining techniques for performing predictive analysis. Participants will be able to calculate columns and measures by using DAX and create a data mining solution by the end of course



70-767 - Implementing a Data Warehouse using SQL

70-768 - Developing SQL Data Models


  • Taught by Industry Experts as instructors
  • Discount on Certification Program
  • Eligible to claim tax credit up to 25% of course fees
  • 24*7 Lab Virtual Desktop access
  • Evening and Weekend schedule
  • Vendor Authorized Training


At 47, I was working in a no-consequence job at a retail center. At 48, I got into Bestseller with a diploma from MCIT with no prior experience in networking tools.

Vasilieos Nikiratas — Networking Student
  • MCSA - SQL 2016 BI Development
  • MCSA - SQL 2016 BI Development
  • MCSA - SQL 2016 BI Development
  • MCSA - SQL 2016 BI Development
  • MCSA - SQL 2016 BI Development