20768: Developing SQL 2016 Data Models

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Experience of querying data usingTransact-SQL.

• Querying Data with Transact-SQL (20761)
• Implementing a SQL Data Warehouse (M20767)

• 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

• Data analysts and power information workers
• Database professionals who fulfill a BI developer role and create enterprise BI solutions and whose primary responsibilities include:
  • Implementing multidimensional databases by using SSAS
  • Creating tabular semantic data models for analysis by using SSAS

1. Introduction to Business Intelligence and Data Modeling

• Introduction to Business Intelligence
• Microsoft Business Intelligence Platform

2. Create Multidimensional Databases

• Introduction to Multidimensional Analysis
• Create Data Sources and Data Source Views
• Cubes
• Overview of Cube Security
• Configure SSAS
• Monitoring SSAS

3. Working Cubes and Dimensions

• Configure Dimensions
• Define Attribute Hierarchies
• Implementing Sorting and Grouping Attributes
• Slowly Changing Dimensions

4. Working with Measures and Measure Groups

• Working with Measures
• Working with Measure Groups

5. Introduction to Multidimensional Expressions (MDX)

• MDX Fundamentals
• Add Calculations to a Cube
• Use MDX to Query a Cube

6. Customize Cube Functionality

• Implement Key Performance Indicators
• Implement Actions
• ImplementPerspectives
• Implement Translations

7. Implement a Tabular Data Model by Using Analysis Services

• Introduction to Tabular Data Models
• Create a Tabular Data Model
• Use an Analysis Services Tabular Model in an Enterprise BI Solution

8. Introduction to Data Analysis Expression (DAX)

• DAX Fundamentals
• Using Dax to create Calculated Columns and Measures in a Tabular Data Model

9. Perform Predictive Analysis with Data Mining

• Overview of Data Mining
• Create a Custom Data Mining Solution
• Validate a Data Mining Model
• Connecting to and Consume a Data Mining Model
• Using the Data Mining add-in for Excel