MS517

MS SQL Server 2008 / 2012 / 2014 Analysis Services (SSAS)

93%

overall satisfaction for this course

?Average calculated from scores obtained from 244 participants who took this course.
  • Duration 3 days
  • Regular fee 1 300
  • Preferential fee 1 125?
  • Locations
    • Montreal
    • Quebec City
  • Laboratory
    course
Parcours

Formation path :

Databases Training Paths

View path
SUMMARY
DETAILS

Objectives

To provide the knowledge and skills required to make effective use of MS SQL Server Analysis Services (SSAS).

Targeted audience

Data warehouse developers.

Prerequisite

Experience with data warehouse design (Courses BD106)

Special Note

Customer Testimonials

Technical course well-balanced between theory and practice.

David L. / Consultant, Manevco Management

Content

  • Fundamental concepts of SSAS: data sources, dimensions, cubes, the UDM model
  • New features of the SSAS architecture
  • Implementing star and snowflake schemas
  • Generating a cube
  • Implementing advanced cube functionality
  • SSAS administration
  • Configuring roles, groups and permissions
  • SSAS management: performance optimization
  • Managing partitions and Business Intelligence in real time
  • Generating scripts with MDX
  • Using data exploration solutions in SSAS
  • Using data exploration tools

DATES*

*Unless stated otherwise, all sessions are in French.
  • Montreal

    February 6 to February 8 2017

  • Montreal

    June 12 to June 14 2017

  • Quebec City

    June 26 to June 28 2017

Trainer(s) assigned(s)

Other course(s) in this category