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
  • APPLY
    HERE

* 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

MCSA - SQL 2016 BI Development        
Dwany Ho

Big Data Developer

MCSA - SQL 2016 BI Development        
Rosana

Java Developer

MCSA - SQL 2016 BI Development        
Sihame

BI Developer

MCSA - SQL 2016 BI Development        
Chloe Dai

STQA

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.

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 introduces 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 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.

This module overviews the implementation of a tabular data model in Power Pivot and the usage of data mining techniques for performing predictive analysis. Participants learn to calculate columns and measures by using DAX and create a data mining solution.

SKILLS ACQUIRED

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

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
  • 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