Developing SQL 2016 Data Models (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