MCSA SQL 2016 Business Intelligence Development Training & Certification Boot Camp

6 Days

Description

The Microsoft Official MCSA SQL 2016 Business Intelligence Development certification boot camp is a 6 day comprehensive deep dive into the SQL Server covering topics such as extract, transform, and load (ETL) and data warehouse skills, along with those for implementing BI solutions using multidimensional and tabular data models and online analytical processing (OLAP) cubes.

The Microsoft SQL 2016 Business Intelligence Development boot camp incorporates Microsoft Official Courses 

20767 Implementing a SQL Data Warehouse
20768 Developing SQL Data Models

While attending this training program - you take two exams to test and certify for the official Microsoft Certified Solutions Associate (MCSA) SQL 2016 Business Intelligence Development certification. If your goal is to learn how to use SQL Server 2016 and pass the certification exams (70-767 / 70-768) - you've found the right place. This course is a hybrid of actual hands on learning combined with focused materials mapped to exam objectives. 

Upcoming Classes

Classroom Live
November 13, 2017

Sarasota, FL or Virtual LIVE
$4,995.00
6 Days    9:00am EST - 5:00 PM EST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

  • Topics covered in this boot camp:
    • Describe the key elements of a data warehousing solution
    • Describe the main hardware considerations for building a data warehouse
    • Implement a logical design for a data warehouse
    • Implement a physical design for a data warehouse
    • Create columnstore indexes
    • Implementing an Azure SQL Data Warehouse
    • Describe the key features of SSIS
    • Implement a data flow by using SSIS
    • Implement control flow by using tasks and precedence constraints
    • Create dynamic packages that include variables and parameters
    • Debug SSIS packages
    • Describe the considerations for implement an ETL solution
    • Implement Data Quality Services
    • Implement a Master Data Services model
    • Describe how you can use custom components to extend SSIS
    • Deploy SSIS projects
    • Describe BI and common BI scenarios
    • Describe the components, architecture, and nature of a BI solution
    • Create a multidimensional database with analysis services
    • Implement dimensions in a cube
    • Implement measures and measure groups in a cube
    • Use MDX syntax
    • Customize a cube
    • Implement a tabular database
    • Use DAX to query a tabular model
    • Use data mining for predictive analysis

Upcoming Classes

Classroom Live
November 13, 2017

Sarasota, FL or Virtual LIVE
$4,995.00
6 Days    9:00am EST - 5:00 PM EST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

none

Upcoming Classes

Classroom Live
November 13, 2017

Sarasota, FL or Virtual LIVE
$4,995.00
6 Days    9:00am EST - 5:00 PM EST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date