20768: Developing SQL Data Models

This 24 hours instructor-led course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS.

Audience(s):  IT Professionals
Technology: SQL Server 2016
Duration:  24 hours

Module 1: Introduction to Business Intelligence and Data Modeling

Module 2: Creating Multidimensional Databases

Module 3: Working with Cubes and Dimensions

Module 4: Working with Measures and Measure Groups

Module 5: Introduction to MDX

Module 6: Customizing Cube Functionality

Module 7: Implementing a Tabular Data Model by Using Analysis Services

Module 8: Introduction to Data Analysis Expression (DAX)

Module 9: Performing Predictive Analysis with Data Mining

See Complete Content

Session 1   Session 2
Start Date:  Start Date:
End Date:  End Date:
Day(s):  Day(s):
Hours:  Hours:

More Information