Developing SQL Data Models (M20768)

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

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

Lab 1: Exploring a BI Solution
Lab 2: Create a Multidimensional Database
Lab 3: Work with Cubes and Dimensions
Lab 4: Configure Measures and Groups
Lab 5: Use MDX
Lab 6: Customize a Cube
Lab 7: Working with an Analysis Services Tabular Data Model
Lab 8: Create Calculated Columns and Measures using DAX
Lab 9: Using Data Mining

Lab 1: Exploring a BI Solution
Lab 2: Create a Multidimensional Database
Lab 3: Work with Cubes and Dimensions
Lab 4: Configure Measures and Groups
Lab 5: Use MDX
Lab 6: Customize a Cube
Lab 7: Working with an Analysis Services Tabular Data Model
Lab 8: Create Calculated Columns and Measures using DAX
Lab 9: Using Data Mining