We are happy to advise you!
0845 470 1000     Contact

Instructor-Led Online Training (ILO)
Live Online Classes in the Virtual Classroom

Find out more and view dates

Developing SQL Data Models (20768)

 

Course Overview

This three-day instructor-led course will teach you how to implement multidimensional databases and create tabular semantic data models for analysis with SQL Server Analysis Services (SSAS).

Who should attend

Database professionals and BI Developers working with enterprise BI solutions.

Certifications

This course is part of the following Certifications:

Prerequisites

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of Transact-SQL
  • Working knowledge of relational databases

Course 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

Follow On Courses

Online Training

Duration 3 days

Price (excl. VAT)
  • £ 1,870.-
  • SA Voucher: 3
    hardcoded default SA
Classroom Training

Duration 3 days

Price (excl. VAT)
  • United Kingdom: £ 1,870.-
  • SA Voucher: 3
    hardcoded default SA

Schedule

This class will become guaranteed to run with one more student registration.
This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
This is a FLEX course, which is delivered both virtually and in the classroom. Please note, local pricing is applicable.
English
Time zone BST
12/10/2020 ― 14/10/2020 Online Training Time zone: BST
21/12/2020 ― 23/12/2020 Online Training Time zone: GMT
13/01/2021 ― 15/01/2021 Online Training Time zone: GMT
10/03/2021 ― 12/03/2021 Online Training Time zone: GMT
This class will become guaranteed to run with one more student registration.
This is a FLEX course, which is delivered both virtually and in the classroom. Please note, local pricing is applicable.
United Kingdom
12/10/2020 ― 14/10/2020 London (Int Hse) This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training
13/01/2021 ― 15/01/2021 London (Int Hse) This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training
10/03/2021 ― 12/03/2021 London (Int Hse) This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training