The Knowledge Academy Logo
The Knowledge Academy Logo
+61 1-800-150644 - Available 24/7

Send us your message.

X

Developing SQL Data Models (M20768) - Australia

Key points about this course


Duration: 3 Days*

Exam: Developing SQL Data Models

Accredited: Yes

Support: 24/7

Dates & Prices Enquire
  • Understand how to create a custom data mining solution
  • Learn to implement actions, perspectives, and translations
  • Identify MDX fundamentals

Available delivery methods for this course

Classroom Icon

Classroom

Virtual Icon

Live Virtual

Online Icon

Online

Onsite Icon

In-house

Course Information

Developing SQL Models (M20768)​ Overview

This 3-day official Microsoft course focuses on creating managed enterprise BI (Business Intelligence) solutions. On the course, you will learn how to implement both multidimensional and tabular data models, and how to create cubes, dimensions, measures, and measure groups. You will also prepare for the accompanying Exam 70-768, which is included.

 

Developing SQL Data Models (M20768)​ Outline

Module 1: Introduction to Business Intelligence and Data Modeling

This 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

 

After completing this module, students will be able to:
 

  • Describe BI scenarios, trends, and project roles.

  • Describe the products that make up the Microsoft BI platform.

 

Module 2: Creating Multidimensional Databases

This 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

 

After completing this module, you will be able to:

  • Describe considerations for a multidimensional database.

  • Create data sources and data source views.

  • Create a cube

  • Implement security in a multidimensional database.

  • Configure SSAS to meet requirements including memory limits, NUMA and disk layout.

  • Monitor SSAS performance.

 

Module 3: Working with Cubes and Dimensions

This 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

 

After completing this module, you will be able to:

  • Configure dimensions.

  • Define attribute hierarchies.

  • Implement sorting and grouping for attributes.

  • Implement slowly changing dimensions.

 

Module 4: Working with Measures and Measure Groups

This 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

 

After completing this module, you will be able to:

  • Configure measures.

  • Configure measure groups.

 

Module 5: Introduction to MDX

This 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

 

After completing this module, you will be able to:

  • Use basic MDX functions.

  • Use MDX to add calculations to a cube.

  • Use MDX to query a cube.

 

Module 6: Customizing Cube Functionality

This 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

 

After completing this module, you will be able to:

  • Implement KPIs in a Multidimensional database

  • Implement Actions in a Multidimensional database

  • Implement perspectives in a Multidimensional database

  • Implement translations in a Multidimensional database

 

Module 7: Implementing a Tabular Data Model by Using Analysis Services

This 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.

 

After completing this module, students will be able to:

  • Describe tabular data models

  • Describe how to create a tabular data model

  • Use an Analysis Services Tabular Model in 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

 

After completing this module, students will be able to:

  • Describe the key features of DAX

  • Create calculated columns and measures by using DAX

 

Module 9: Performing Predictive Analysis with Data Mining

This 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

 

After completing this module, students will be able to:

  • Describe considerations for data mining

  • Create a data mining model

  • Validate a data mining model

  • Connect to a data-mining model

  • Use the data mining add-in for Excel

Who should attend?

The course is aimed at database professionals who need to create enterprise BI solutions as part of a BI Developer role. Responsibilities of the target audience may include the following:

  • Implementing multidimensional databases by using SQL Server Analysis Services

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

 

Prerequisites

You should have experience of querying data using Transact-SQL before attending.

Yes, we are Microsoft Silver Learning Partners and our courses are accredited.
Our Microsoft SQL courses are available in thousands of locations across the world, allowing you to easily find the session most convenient for you.
The course helps you prepare for Exam 70-768.
You should have experience of querying data using Transact-SQL before attending.
No, the official Microsoft exam is not included.
The price for Developing SQL Data Models (M20768) certification in Australia starts from $795
The Knowledge Academy is the Leading global training provider in the world for Developing SQL Data Models (M20768).

Developing SQL Data Models (M20768)  Exam

The course prepares you for Exam 70-798: Developing SQL Models. This exam is not included. It measures ability to accomplish technical tasks within these areas:

  • Design a multidimensional business intelligence semantic model

  • Design a tabular BI semantic model

  • Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)

  • Configure and maintain SQL Server Analysis Services

Dates & Prices

Select your preferred delivery method

Choose a Region

Choose a Location

Choose a Month

Office Icon Attend your course from the office or home
Trainers Icon Interactive support from experienced trainers
Simple Icon Simple to setup and easy to use on any device
VirtualLive Virtual
Mon 26th Aug 2019
Places available
$5995
Brisbane
Mon 26th Aug 2019
Places available
$5995
Adelaide
Mon 9th Sep 2019
Places available
$5995
Perth
Mon 16th Sep 2019
Places available
$5995
VirtualLive Virtual
Mon 23rd Sep 2019
Places available
$5995
Melbourne
Mon 23rd Sep 2019
Places available
$5995
Sydney
Mon 30th Sep 2019
Places available
$5995
Brisbane
Mon 21st Oct 2019
Places available
$5995
VirtualLive Virtual
Mon 28th Oct 2019
Places available
$5995
Melbourne
Mon 28th Oct 2019
Places available
$5995
Adelaide
Mon 4th Nov 2019
Places available
$5995
VirtualLive Virtual
Mon 18th Nov 2019
Places available
$5995
Perth
Mon 18th Nov 2019
Places available
$5995
Sydney
Mon 2nd Dec 2019
Places available
$5995
Canberra
Mon 9th Dec 2019
Places available
$5995
VirtualLive Virtual
Mon 16th Dec 2019
Places available
$5995
Brisbane
Mon 16th Dec 2019
Places available
$5995

Complete the steps below to receive a quote or more information

How will you be funding your training?

Self funding

Company funding

Not sure

Key points about this course


Duration: 3 Days*

Exam: Developing SQL Data Models

Accredited: Yes

Support: 24/7


Why choose TKA logo


Gold Tag

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

Trusted Icon

Trusted & Approved

Microsoft Silver Learning Partner

Delivery Icon

Various delivery methods

Flexible delivery methods are available depending on your learning style.

Resource Icon

Resources

Resources are included for a comprehensive learning experience.

Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

Google Logo
Samsung Logo
Shell Logo

"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."

Diane Gray, Shell