MS-MCSA-SQL-2016-BI MCSA: SQL 2016 Business Intelligence Development (MS-MCSA-SQL-2016-BI)

The MCSA: SQL 2016 Business Intelligence Development Certification validates your 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. This certification will qualify you for a position as a BI developer.
  • Virtual Classroom

    Learning Style
  • Intermediate

    Difficulty
  • 6 Days

    Course Duration
  • 7 Days

    SATV Value
Pricing
About Individual Course:
  • Individual course plan gives you access to this course
New
$4,095.00
$4,095.00
/ Seat
The MCSA: SQL 2016 Business Intelligence Development Certification validates your 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. This certification will qualify you for a position as a BI developer.

About this course:

The MCSA: SQL 2016 Business Intelligence Development Certification validates your 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. This certification will qualify you for a position as a BI developer.
This Unitek Training Boot Camp provides students hands-on experience with SQL Server 2016. The boot camp will highlight what is new in SQL Server 2016 in comparison to SQL Server 2012/2014. It provides guidance on designing, implementing and populating Data Warehouses in SQL 2016. As well as working with cubes and other data models in SQL Server Analysis Services 2016.

Course Objective:

After completing this course, students will be able to:

  • 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

Audience:

The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions. 
Primary responsibilities will include:

  • Implementing multidimensional databases by using SQL Server Analysis Services
  • Creating tabular semantic data models for analysis by using SQL Server Analysis Services

Prerequisite:

Before attending this course, students must have:

  • Experience of querying data using Transact-SQL

Suggested prerequisite course:

Developing SQL Data Models (MS-20768)

About this course:

The MCSA: SQL 2016 Business Intelligence Development Certification validates your 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. This certification will qualify you for a position as a BI developer.
This Unitek Training Boot Camp provides students hands-on experience with SQL Server 2016. The boot camp will highlight what is new in SQL Server 2016 in comparison to SQL Server 2012/2014. It provides guidance on designing, implementing and populating Data Warehouses in SQL 2016. As well as working with cubes and other data models in SQL Server Analysis Services 2016.

Course Objective:

After completing this course, students will be able to:

  • 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

Audience:

The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions. 
Primary responsibilities will include:

  • Implementing multidimensional databases by using SQL Server Analysis Services
  • Creating tabular semantic data models for analysis by using SQL Server Analysis Services

Prerequisite:

Before attending this course, students must have:

  • Experience of querying data using Transact-SQL

Suggested prerequisite course:

Developing SQL Data Models (MS-20768)

More Information
Brand Microsoft
Lab Access No
Learning Style Virtual Classroom
Difficulty Intermediate
Course Duration 6 Days
Language English
SATV Value 7 Days
VPA Eligible VPA Eligible
Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account
Sales Support

Sales (866) 991-3924

Mon-Fri. 8am-6pm CST

Have Questions? Ask Us.

Why QuickStart

Turn Training Into A Personalized Learning Experience


  • Problem Solving through ExpertConnect & Peer-To-Peer Learning
  • Find The Quickest Path To Learn With Career Paths
  • Access All Courses With Master Subscription
  • Manage Your Team With Learning Analytics
  • Virtual Classroom Training & Self-Paced Learning
  • Integrate With Your LMS Through API's