Developing SQL Data Models (M20768)
COURSE OUTLINE:
In this course, you will learn about business intelligence (BI) solutions that implement multidimensional databases and create tabular semantic data models for analysis using SQL Server Analysis Services (SSAS).�
This course x incorporates material from the Official Microsoft Learning Product 20768: Developing SQL Data Models and can assist you in preparing for the 70-768: Developing SQL Data Models exam
Audience
- 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
Prerequisites
- Basic knowledge of the Microsoft Windows operating system and its core functionality
- Working knowledge of Transact-SQL
- Working knowledge of relational databases
Learning Objectives
- 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
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
- Create a Cube
- Overview of Cube Security
- Configure SSAS
- Monitoring SSAS
3. Working with Cubes and Dimensions
- Configure Dimensions
- Define Attribute Hierarchies
- Sort and Group Attributes
4.�Working with�Measures and 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, Perspectives, and 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
- Create Columns and Measures in a Tabular Data Model Using DAX
9. Perform Predictive Analysis with Data Mining
- Overview of Data Mining
- Use the Data Mining Add-in for Excel
- Create a Custom Data Mining Solution
- Validate, Connect, and Consume a Data Mining Model