Got a question? Call 1800 853 276   |   

Microsoft 20768 – Developing SQL Data Models

  • Length 3 days
  • Price $2750 inc GST
  • Version C
Course overview
View dates &
book now
  • Register interest

Why study this course

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.

Please note: This course is due to retire on 30 December 2021.

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.


What you’ll learn

After completing this course, students will be able to:

  • Describe the 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


Microsoft at DDLS

DDLS is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia’s First and largest Microsoft Gold Learning Solutions Partner. All DDLS Microsoft courses follow Microsoft Official Curriculum (MOC) and are led by Microsoft Certified Trainers. Join more than 5,000 students who attend our quality Microsoft courses every year.


Stay ahead of the technology curve

Don’t let your tech outpace the skills of your people

Quality instructors and content

Expert instructors with real world experience and the latest vendor- approved in-depth course content.

Partner-Preferred Supplier

Chosen and awarded by the world’s leading vendors as preferred training partner.

Ahead of the technology curve

No matter your chosen technologies or platforms, we can help you stay one step ahead.

Who is the course for?

The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions.

Primary responsibilities will include:

  • Implementing multidimensional databases by using SQL Server Analysis Services

  • Creating tabular semantic data models for analysis by using SQL Server Analysis Services

We can also deliver and customise this training course for larger groups – saving your organisation time, money and resources. For more information, please contact us on 1800 853 276.


Course subjects

Module 1: Introduction to Business Intelligence and Data ModelingThis module introduces key BI concepts and the Microsoft BI product suite.

Lessons

  • Introduction to Business Intelligence

  • The Microsoft business intelligence platform

Lab : Exploring a BI Solution

  • Exploring a Data Warehouse

  • Exploring a data model

Module 2: Creating Multidimensional DatabasesThis module describes how to create multidimensional databases using SQL Server Analysis Services.

Lessons

  • Introduction to Multidimensional Analysis

  • Creating Data Sources and Data Source Views

  • Creating a Cube

  • Overview of Cube Security

  • Configure SSAS

  • Monitoring SSAS

Lab : Creating a multidimensional database

  • Creating a Data Source

  • Creating and Modifying a data Source View

  • Creating and Modifying a Cube

Module 3: Working with Cubes and DimensionsThis module describes how to implement dimensions in a cube.

Lessons

  • Configuring Dimensions

  • Defining Attribute Hierarchies

  • Sorting and Grouping Attributes

  • Slowly Changing Dimensions

Lab : Working with Cubes and Dimensions

  • Configuring Dimensions

  • Defining Relationships and Hierarchies

  • Sorting and Grouping Dimension Attributes

Module 4: Working with Measures and Measure GroupsThis module describes how to implement measures and measure groups in a cube.

Lessons

  • Working with Measures

  • Working with Measure Groups

Lab : Configuring Measures and Measure Groups

  • Configuring Measures

  • Defining Dimension Usage and Relationships

  • Configuring Measure Group Storage

Module 5: Introduction to MDXThis module describes the MDX syntax and how to use MDX.

Lessons

  • MDX fundamentals

  • Adding Calculations to a Cube

  • Using MDX to Query a Cube

Lab : Using MDX

  • Querying a cube using MDX

  • Creating a Calculated Member

Module 6: Customizing Cube FunctionalityThis module describes how to customize a cube.

Lessons

  • Introduction to Business Intelligence

  • The Implementing Key Performance Indicators

  • Implementing Actions

  • Implementing Perspectives

  • Implementing Translations

Lab : Customizing a Cube

  • Implementing a KPI

  • Implementing an action

  • Implementing a perspective

  • Implementing a translation

Module 7: Implementing a Tabular Data Model by Using Analysis ServicesThis module describes how to implement a tabular data model in Power Pivot.

Lessons

  • Introduction to Tabular Data Models

  • Creating a Tabular Data Model

  • Using an Analysis Services Tabular Data Model in an Enterprise BI Solution

Lab : Working with an Analysis Services Tabular Data Model

  • Creating an Analysis Services Tabular Data Model

  • Configure Relationships and Attributes

  • Configuring Data Model for an Enterprise BI Solution.

Module 8: Introduction to Data Analysis Expression (DAX)This module describes how to use DAX to create measures and calculated columns in a tabular data model.

Lessons

  • DAX Fundamentals

  • Using DAX to Create Calculated Columns and Measures in a Tabular Data Model

Lab : Creating Calculated Columns and Measures by using DAX

  • Creating Calculated Columns

  • Creating Measures

  • Creating a KPI

  • Creating a Parent – Child Hierarchy

Module 9: Performing Predictive Analysis with Data MiningThis module describes how to use data mining for predictive analysis.

Lessons

  • Overview of Data Mining

  • Creating a Custom Data Mining Solution

  • Validating a Data Mining Model

  • Connecting to and Consuming a Data-Mining Model

  • Using the Data Mining add-in for Excel

Lab : Using Data Mining

  • Creating a Data Mining Structure and Model

  • Exploring Data Mining Models

  • Validating Data Mining Models

  • Consuming a Data Mining Model

  • Using the Excel Data Mining add-in


Prerequisites

Before attending this course, students must have:

  • Experience of querying data using Transact-SQL


Terms & Conditions

The supply of this course by DDLS is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.



Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.