20768 Developing SQL Data Models

Are you looking for hands-on experience developing SQL data models? This course from Network Technology Academy will equip you with the skills you need to level up in your Business Intelligence career. 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).

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

Actual course outline may vary depending on offering center. Contact your sales representative for more information.

This course is SATV-Eligible
All class times shown are in Pacific Standard Time (PST)

Contact Us For Price

Course Length: 3 Days

1. Choose a Date | 2. Click Enroll Now
Need Help Picking the Right Course? Give us a call! 781-388-0026
Awaiting product image

Description

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

Reviews

There are no reviews yet.

Be the first to review “20768 Developing SQL Data Models”

Your email address will not be published. Required fields are marked *

Related products

© Copyright - Network Technology Academy
20767 Implementing a SQL Data Warehouse 55232 Writing Analytical Queries for Business Intelligence