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

> > > 20768

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)
  • United Kingdom: £ 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
E-Learning MOC on Demand

Duration 90 days

Price (excl. VAT)
  • United Kingdom: £ 449.-
  • SA Voucher: 2
    hardcoded default SA
Buy E-Learning
 
Click on the location to go directly to the booking page Schedule
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.
United Kingdom
20/04/2020 ― 22/04/2020 Virtual This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training
03/06/2020 ― 05/06/2020 Manchester This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training
29/06/2020 ― 01/07/2020 London (Int Hse) This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training
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
21/12/2020 ― 23/12/2020 Manchester Enroll
FLEX & Online Training

Please see below our alternative, English language, FLEX course options.

31/05/2020 ― 02/06/2020 Online Training Time zone: Africa/Cairo Course language: English Enroll
07/06/2020 ― 09/06/2020 Online Training Time zone: Asia/Qatar Course language: English Enroll

Fast Lane Flex™ Classroom If you can't find a suitable date, don't forget to check our world-wide FLEX™ training schedule.