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.

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,995.00
  • Delivery Format VLT (Instructor Led; Virtual LIVE Online; Remote Training)
  • Course Topic Business Intelligence
  • Vendor Microsoft
  • Technology SQL Server

Register for course: M20768

"*" indicates required fields

Training Agreement*
This field is for validation purposes and should be left unchanged.