Developing SQL Data Models (M20768)

COURSE OUTLINE:

Description

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