Home / All Courses / Microsoft / Microsoft Business Intelligence / 20768: Developing SQL 2016 Data Models

20768: Developing SQL 2016 Data Models Training & Certification Course

Overview

Developing SQL Data Models course imparts core skills to implement multidimensional databases using SSAS (SQL Server Analysis Services), and create tabular semantic data models for analysis. This SSAS training is meant for database professionals who create enterprise BI solutions in order to fulfil the role of a BI Developer. This SQL Data Model Development course is also suitable for power users, information workers and data analysts.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

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

Fees & Schedule

Delivery Mode Course Duration Fees
Live Virtual Training 3 Days Ask for Quote
Onsite Classroom Training 3 Days Ask for Quote
Customized Training 3 Days Ask for Quote

FAQ's