0845 470 1000 / enquiries@flane.co.uk
> > > 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

Classroom Training

Duration 3 days

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

Duration 3 days

Price (excl. VAT)
  • United Kingdom: £ 1,703.-
  • 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
 
...