Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-800-268-7737 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Developing SQL Data Models (M20768)

Learn about SQL Server Analysis Services (SSAS) for SQL Server 2016.

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

GK# 4399 Vendor# M20768
Vendor Credits:
  • Global Knowledge Delivered Course
  • Training Exclusives
  • GSA Eligible
No matching courses available.
Start learning as soon as today! Click Add To Cart to continue shopping or Buy Now to check out immediately.
Scheduling a custom training event for your team is fast and easy! Click here to get started.
$
Your Selections:
Location:
No available dates

Who Should Attend?

  • 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

What You'll Learn

  • 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

Course Outline

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
BUY NOW

Labs Outline

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

BUY NOW

Prerequisites

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Experience of querying data usingTransact-SQL.

Related Certifications

Earning an MCSA: SQL 2016 Business Intelligence Development certification validates your extract, transform, and load (ETL) and data warehouse skills, along with those for implementing BI solutions using multidimensional and tabular data models and online analytical processing (OLAP) cubes. This certification will qualify you for a position as a BI developer.

Vendor Credits

This course is eligible for Software Assurance Training Vouchers (SATVs).

BUY NOW

Follow-On Courses