Microsoft SQL Server Certification (70-768): SQL Data Models
4.5 (20 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
172 students enrolled

Microsoft SQL Server Certification (70-768): SQL Data Models

A comprehensive and practical course designed to help you pass the Microsoft SQL Server (70-768) Exam.
4.5 (20 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
171 students enrolled
Created by Thinkable Tribe
Last updated 1/2020
English
English [Auto-generated]
Current price: $129.99 Original price: $199.99 Discount: 35% off
15 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6.5 hours on-demand video
  • 1 article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn how to obtain a Microsoft Certification
  • Design a tabular BI semantic model
  • Configure and maintain SQL Server Analysis Services (SSAS)
  • Design a multidimensional business intelligence (BI) semantic model
  • Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)
  • Learn how to pass the Microsoft SQL Server 70-768 exam
Requirements
  • A PC
  • Internet Access
  • SQL Server 2016 (or 2017/2019)
  • No pre-knowledge is required - enthusiasm is all you need!
Description

Welcome to this course: Microsoft SQL Server Certification (70-768) - SQL Data Models. Business Intelligence Semantic Models (BISM) is a technology that is designed to deliver analytical information to users through a variety of mechanisms that include model structure, definition, and design. This course demonstrates how to create BISM models so that information can be presented to users in an intuitive and easy-to-use format. Once the model is defined, we also show you how it can be managed and maintained so that the data in it remains current and secure. This course help demonstrate your real-world mastery of Business Intelligence (BI) solutions development with SQL Server 2016 (2017/2019) Analysis Services (SSAS), including modeling and queries. Designed for experienced IT professionals ready to advance their status.

In this course, you'll learn:

  • Developing SQL Data Models

  • Learn How to pass the Microsoft SQL Server 70-768 exam

  • Design a tabular BI semantic model

  • Configure and maintain SQL Server Analysis Services (SSAS)

  • Design a multidimensional business intelligence (BI) semantic model

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

Who this course is for:
  • IT professionals
  • Web Developers
  • Programmers
  • Software Developers
  • Business intelligence (BI) Developers
Course content
Expand all 52 lectures 06:38:04
+ Getting started with this course
11 lectures 01:28:08
Introduction
00:54
Microsoft SQL Server Analysis Services - Creating multidimensional databases - 1
07:11
Microsoft SQL Server Analysis Services - Creating multidimensional databases - 2
12:17
Microsoft SQL Server Analysis Services - Creating Dimensions and Hierarchies - 1
06:40
Microsoft SQL Server Analysis Services - Creating Dimensions and Hierarchies - 2
10:59
All attributes have a relationship to the key attribute - 1
03:17
All attributes have a relationship to the key attribute - 2
13:28
SQL Server Analysis Services - Implement measures and measure groups - 1
06:18
SQL Server Analysis Services - Implement measures and measure groups - 2
12:07
Design and implement aggregate functions - 1
03:45
Design and implement aggregate functions - 2
11:12
+ Designing a tabular BI semantic model
8 lectures 01:01:32
Learn About Multidimensional or Tabular Models - 1
03:12
Learn About Multidimensional or Tabular Models - 2
13:12
Deploying a Tabular Model
07:14
Processing a Tabular Model
11:56
Learn About Tabular Model Storage
04:46
Learn About Configuration
10:25
Configuring Tabular Model Security - 1
04:09
Configuring Tabular Model Security - 2
06:38
+ Developing queries using MDX and DAX
12 lectures 01:47:51
Multidimensional Expressions (MDX) - 1
06:29
Multidimensional Expressions (MDX) - 2
13:19
Learn About Calculated Members and Named Sets - 1
08:14
Learn About Calculated Members and Named Sets - 2
17:18
Learn About MDX Functions - 1
03:18
Learn About MDX Functions - 2
13:36
Define a SCOPE Statement - 1
01:44
Define a SCOPE Statement - 2
09:27
Implement custom MDX solutions
05:58
Learn How to Use the EVALUATE and CALCULATE functions
09:54
Learn About Calculated Measures and Columns
10:30
Learn How to Perform data analysis by Using DAX
08:04
+ Configure and maintain SQL Server Analysis Services (SSAS)
18 lectures 02:16:21
SQL Server Analysis Services - 1
10:52
SQL Server Analysis Services - 2
09:05
Monitor and Optimize Performance - 1
03:02
Monitor and Optimize Performance - 2
09:12
Learn How to Configure Usability Limits - 1
03:39
Learn How to Configure Usability Limits - 2
07:05
Learn How to Configure Partition Processing - 1
07:22
Learn How to Configure Partition Processing - 2
15:58
Learn How to Configure Dimension Processing - 1
02:01
Learn How to Configure Dimension Processing - 2
09:26
Learn How to Create Key Performance Indicators (KPIs) - 1
03:46
Learn How to Create Key Performance Indicators (KPIs) - 2
15:10
Create KPIs in Multidimensional Models and Tabular Models
08:19
Create Key Performance Indicators (KPIs) and Actions - 1
02:38
Create Key Performance Indicators (KPIs) and Actions - 2
10:27
Learn How to Create and Develop Translations - 1
03:43
Learn How to Create and Develop Translations - 2
06:29
+ Course Summary
2 lectures 01:29
Summary
01:25
Thank You
00:04