PDP Url

Developing SQL Data Models - MOC On Demand (MS-20768)

The focus of this 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.

Self-Paced

Learning Style

Intermediate

Difficulty

2 Days

Course Duration

2

SATV Value

Course Info

Download PDF

Certificate

See Sample

Subscribe Buy Individually
About Individual Course:
  • Individual course plan gives you access to this course
On Sale!
Now Only $550.00 Regular Price $1,195.00
Now Only $550.00 Regular Price $1,195.00
/ Each
When you subscribe, you get:
Master Subscription plan gives you access to this course and over 1180 other popular courses
On Sale!
Now Only $2,999.00 Regular Price $3,499.00
Now Only $2,999.00 Regular Price $3,499.00
/ Year
The focus of this 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.

Course Information

This course prepares you for the 70-768 Exam leading to 70-768 Certification. This course does not include the Official Exam Voucher, however, you can request to purchase the Official Exam Voucher separately.

About this course: 

This course is Microsoft Official On-Demand course accessible for 90 days from the date of course request, if you have annual subscription, or course purchase individually. Course access will expire after 90 days of course enrollment.

Let’s have an insight on SQL and data modeling. SQL (Structured Query Language) is a standardized programming language used for managing relational databases and performing various operations on the data in them. Data modeling is the process of documenting a complex software system design as an easily understood diagram, using text and symbols to represent the way data needs to flow. The diagram can be used as a blueprint for the construction of new software or for re-engineering a legacy application. The focus of this 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. The actual purpose of this course is to prepare students for Microsoft 70-768: Developing SQL Data Models certification exam.

The average salary for Data Engineer with SQL Skills is $82,958 per year.

Course Objective: 

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

Audience: 

This course is intended for: 

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

Prerequisites:

Before attending this course, students must have:

  • Experience of querying data using Transact-SQL

    Outline

    Practice Certification Exam

    https://www.quickstart.com/exam-70-768-developing-sql-data-models.html

    More Information

    More Information
    Brand Microsoft
    Subjects IT Ops & Management
    Lab Access Yes
    Technology Microsoft, MOCOD
    Learning Style Self-Paced Learning
    Difficulty Intermediate
    Course Duration 2 Days
    Language English
    SATV Value 2
    VPA Discount VPA Discount

    Reviews

    Write Your Own Review
    Only registered users can write reviews. Please Sign in or create an account

    Course Prerequisites
    Sale
    Transact SQL
    Transact SQL
    300%
    • Self-Paced Learning
    • 9 Hours
    Now Only $10.00 Regular Price $149.00
    Sale
    SQL Basics
    SQL Basics
    10300%
    • Self-Paced Learning
    • 3 Hours
    Now Only $10.00 Regular Price $29.00

    Contact A Learning Consultant


    click here