MS SQL Server 2014 / 2016 Analysis Services (SSAS)


overall satisfaction for this course

?Average calculated from scores obtained from 274 participants who took this course.
  • Duration 3 days
  • Regular fee 1 435
  • Preferential fee 1 290?
  • Locations
    • Montreal
    • Quebec City
  • Laboratory


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

Targeted audience

Data warehouse developers.


Experience with data warehouse design (Courses BD106)

Special Note

Customer Testimonials

Excellent training with several examples.

Julien G., -


  • Key SSAS concepts: data sources, dimensions, cubes, the UDM model
  • New features of SSAS architecture
  • Implementing star and snowflake schemas
  • Generating a cube
  • Implementing advanced cube functionality
  • SSAS administration
  • Configuration of 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


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

    March 11 to March 13 2019

  • Quebec City

    March 11 to March 13 2019 - Virtual Classroom

  • Montreal

    September 30 to October 2 2019

Trainer(s) assigned(s)

Other course(s) in this category