Developing SQL Data Models

M20768

Ημερομηνία Έναρξης
Σε αναμονή
Διάρκεια
24 hours
Κόστος
Εξέταση - Πιστοποίηση

Audience profile

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

  • M20761 Querying Data with Transact SQL
  • 20767 Implementing a SQL Data Warehouse

Course outline

INTRODUCTION TO BUSINESS INTELLIGENCE AND DATA MODELING

  • Define the Basics of Business Intelligence
  • Get to Know the Microsoft Business Intelligence Platform

Lab: Explore a BI Solution

CREATING MULTIDIMENSIONAL DATABASES

  • Apply Multidimensional Analysis
  • Create Data Sources and Data Source Views
  • Deploy a Cube
  • Learn About Cube Security

Lab: Create a Multidimensional Database

WORKING WITH CUBES AND DIMENSIONS

  • Configure Dimensions
  • Define Attribute Hierarchies
  • Sort and Group Attributes

Lab: Work with Cubes and Dimensions

WORKING WITH MEASURES AND MEASURE GROUPS

  • Work with Measures
  • Practice Using Measure Groups

Lab: Configure Measures and Groups

INTRODUCTION TO MDX

  • Navigate the Fundamentals of MDX
  • Add Calculations to a Cube
  • Query a Cube Using MDX

Lab: Work with MDX

CUSTOMIZING CUBE FUNCTIONALITY

  • Implement Key Performance Indicators
  • Apply Actions, Perspectives and Translations

Lab: Customize a Cube

IMPLEMENTING A TABULAR DATA MODEL BY USING ANALYSIS SERVICES

  • Define and Create Tabular Data Models
  • Work with an Analysis Services Tabular Model in an Enterprise BI Solution

Lab: Work with an Analysis Services Tabular Data Model

INTRODUCTION TO DATA ANALYSIS EXPRESSION (DAX)

  • Master the Basics of DAX
  • Use DAX to Create Calculated Columns and Measures in a Tabular Data Model

Lab: Create Calculated Columns and Measures using DAX

PERFORMING PREDICTIVE ANALYSIS WITH DATA MINING

  • Gain an Introduction to Data Mining
  • Navigate the Data Mining Add-In for Excel
  • Create a Custom Data Mining Solution
  • Validate a Data Mining Model
  • Connect to and Consume a Data Mining Solution

Lab: Practice Data Mining

Δήλωσε Συμμετοχή

Προέκυψε κάποιο σφάλμα

Παρακαλούμε προσπαθήστε ξανά σε λίγο

Επιτυχής Εγγραφή

Σύντομα θα επικοινωνήσουμε μαζί σας.