Course Status
Availability
Course Duration
Timing
Course ID
Exam Number
Registration Open
Weekdays – Weekends
6 Days, 42 Hours
9:00 AM – 04:00 PM
20768
70-768

Developing SQL Data Models

Course Overview

Developing SQL Data Models course imparts core skills to implement multidimensional databases using 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 fulfill the role of a BI Developer. This SQL Data Model Development course is also suitable for power users, information workers, and data analysts.

Course Objectives

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

Prerequisites

  • Must have a working knowledge of Transact-SQL.

Must have a working knowledge of relational databases.

You have made the
best choice!

Book Your Seat Today

  • Course Status: Registration Open
  • Availability: Weekdays - Weekends
  • Duration: 6 Days, 42 Hours
  • Course Status: Registration Open
  • Availability: Weekdays - Weekends
  • Duration: 6 Days, 42 Hours
  • Course Status: Registration Open
  • Availability: Weekdays - Weekends
  • Duration: 5 Days - 35 Hours
  • Course Status: Registration Open
  • Availability: Weekdays - Weekends
  • Duration: 7 Days, 49 Hours

More Courses in this category

  • Course Status: Registration Open
  • Availability: Weekdays - Weekends
  • Duration: 6 Days, 42 Hours
  • Course Status: Registration Open
  • Availability: Weekdays - Weekends
  • Duration: 6 Days, 42 Hours
  • Course Status: Registration Open
  • Availability: Weekdays - Weekends
  • Duration: 5 Days - 35 Hours
  • Course Status: Registration Open
  • Availability: Weekdays - Weekends
  • Duration: 7 Days, 49 Hours

Request Information

Request Information