View all courses

Learn about SQL Server Analysis Services (SSAS) for SQL Server 2016. The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures and measure groups. This course can also help a learner to prepare for the Exam 70-768.

Target Audience
The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions such as implementing multidimensional databases by using SQL Server Analysis Services and creating tabular semantic data models for analysis by using SQL Server Analysis Services

What You'll Learn

  • 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

*Request Detailed Syllabus
~Epic LIVE! or On-Demand delivery options also available!

Register for this course
View all courses
  • Course Number M20768
  • Course Length 3 days
  • Course Fee $1,775.00
  • Delivery Format VLT (Instructor Led; Virtual LIVE Online; Remote Training)
  • Course Topic Business Intelligence
  • Vendor Microsoft
  • Technology SQL Server
Need a different date? This course is also offered on these dates
Date Course ID Course Name Duration Delivery Format Registration
09/14/2020 M20768 Developing SQL Data Models (M20768); 70-768 3 days VLT Register
11/02/2020 M20768 Developing SQL Data Models (M20768); 70-768 3 days VLT Register

Register for course: M20768

By registering for this course, I acknowledge that I understand the terms of the Enspire Training Agreement that I agree to the stated course fee; and that I agree to pay in full the stated cost. We look forward to having you attend this training class!