20768: Developing SQL Data Models SQL Server (SQL Server 2017)

  • Live Vritual Classroom
  • Classroom Training
  • On-Site Training

Enquire Details & Pricing

Key Features MONEY BACK GUARANTEE

How this works :

At Learnfly, we greatly value the trust of our patrons. Our courses are designed to deliver an effective learning experience, and have helped over half a million find their professional calling. But if you feel your course is not to your liking, we offer a 7-day money-back guarantee. Just send us a refund request within 7 days of purchase, and we will refund 100% of your payment, no questions asked!

For Instructor Led Training :

Raise refund request within 7 days of commencement of the first batch you are eligible to attend. Money back guarantee is void if the participant has accessed more than 25% content of an e-learning course or has attended Online Classrooms for more than 1 day.

  • Learn with practical projects and hands on real tools.
  • Official Curriculum & Courseware Content.
  • Online Interactive Lab's Access.
  • Adaptive e-Learning with trainer's support.
  • Access Class via PC, Mobile App or on a large screen.
  • Attend Live HD Training Sessions via Go To MeetingTM. Interact with trainer and peers like in a real classroom via voice, video conference and live chat.

Course Description

About the Course

The focus of this 20768: Developing SQL Data Models SQL Server 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. This course helps you prepare for the Exam 70-768.

 

This course is based on the objectives of the course version 20768C.

Objectives

  • 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

Target Audience

  • 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

Prerequisites

  • Required: Experience of querying data using Transact-SQL

Course Curriculum

Course # : 20768
Exam : Developing SQL Data Models SQL Server (SQL Server 2017)

See what our Alumni says

Our alumni’s are hired by top brands

Hundreds of employers — have maximized their talent with us.

Ready to enroll for this Course? Book your slot now: