Developing SQL Data Models (M20768)
Learn about SQL Server Analysis Services (SSAS) for SQL Server 2016.
GK# 4399 Vendor# M20768
Learn about SQL Server Analysis Services (SSAS) for SQL Server 2016.
GK# 4399 Vendor# M20768
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. This course helps you prepare for the Exam 70-768.
This course incorporates material from the Official Microsoft Learning Product 20768: Developing SQL Data Models
Learn more about this topic. View the recorded webinar Overview of Microsoft SQL Server and High Availability Options
1. Introduction to Business Intelligence and Data Modeling
2. Create Multidimensional Databases
3. Working Cubes and Dimensions
4. Working with Measures and Measure Groups
5. Introduction to Multidimensional Expressions (MDX)
6. Customize Cube Functionality
7. Implement a Tabular Data Model by Using Analysis Services
8. Introduction to Data Analysis Expression (DAX)
9. Perform Predictive Analysis with 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
Redeeming your Microsoft Software Assurance Training Vouchers:
This course comes with 12 months access to the following benefits:
This course is available in the following formats:
Receive face-to-face instruction at one of our training center locations.
Experience live, expert-led online training from the convenience of your home, office or anywhere with an internet connection.