20768 Developing SQL Data Models

Are you looking for hands-on experience developing SQL data models? This course from New Horizons 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).

20768 Developing SQL Data Models

Skip to Available Dates

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 Details

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.

    Who is it For?

    Target Audience

    If you’re a BI developer responsible for creating enterprise BI solutions, this course is perfect for you. You’ll also benefit from this course if you are a power information worker or data analyst.

    Other Prerequisites

    We want you to get the most value possible out of your SQL Server training. To maximize your time taking this course, you should have a basic understanding of the Microsoft Windows operating system and its core functionality. You should also have experience working with Transact-SQL and relational databases.

    If you don’t feel ready to jump into this course quite yet, we suggest that you complete 20761 Querying Data with Transact SQL before taking this course.

    20768 Developing SQL Data Models

    Call | This course is SATV-Eligible
    Course Length : 3 Days

    There are currently no scheduled dates for this course. Please contact us for more information.

    Need Help Picking the Right Course? Give us a call! 415-767-5996