Duration:

5 Days

Audience:

Employees of federal, state and local governments; and businesses working with the government.

Course Description:

In the Developing SQL Data Models course, you will learn how to implement multidimensional databases and create tabular semantic data models for analysis using SQL Server Analysis Services (SSAS).

Learning Objectives:

After finishing this course, you’ll have the confidence to create high-quality enterprise BI solutions and apply multidimensional and tabular data models.
This course prepares you to:

  • Describe the components, architecture and nature of a BI solution
  • Create a multidimensional database with analysis services
  • Implement dimensions and measures in a cube
  • Customize a cube
  • Apply MDX syntax
  • Implement a tabular database
  • Work with DAX to query a tabular model
  • Use data mining for predictive analysis

Course Outline

1 – 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
2 – 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
3 – WORKING WITH CUBES AND DIMENSIONS
  • Configure Dimensions
  • Define Attribute Hierarchies
  • Sort and Group Attributes
  • Lab: Work with Cubes and Dimensions
4 – WORKING WITH MEASURES AND MEASURE GROUPS
  • Work with Measures
  • Practice Using Measure Groups
  • Lab: Configure Measures and Groups
5 – INTRODUCTION TO MDX
  • Navigate the Fundamentals of MDX
  • Add Calculations to a Cube
  • Query a Cube Using MDX
  • Lab: Work with MDX
6 – CUSTOMIZING CUBE FUNCTIONALITY
  • Implement Key Performance Indicators
  • Apply Actions, Perspectives and Translations
  • Lab: Customize a Cube
7 – 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
8 – 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
9 – 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