Data Warehouse Design

Discover key principles, techniques, tools and applications.


overall satisfaction for this course

?Average calculated from scores obtained from 583 participants who took this course.
  • Duration 2 DAYS
  • Regular fee 945
  • Preferential fee 795?
  • Locations
    • Montreal

Formation path :

Databases Training Paths

View path


To provide the knowledge and skills required to identify the main concepts of data warehousing and to make use of effective approaches in designing a data warehouse.

Targeted audience

Business analysts and developers.


General knowledge of computer science.

Customer Testimonials

Very good course to learn the basics of a data warehouse.

Richard A. / Spécialiste Technique Systèmes, Intact Assurance


  • What are data warehouses and why do they exist?
  • Architecture of data warehouses and data stores
  • Business Intelligence: data mining, data warehousing and data visualization
  • Referential/Universal set (metadata)
  • Different stages of data warehouse design
  • Modeling, and the star, snowflake and galaxy models
  • Normalization rules for multidimensional schemas
  • Modeling approaches: ascending, descending, mixed
  • OLAP techniques (OnLine Analytical Processing): roll-up, drill-down, slice, dice, pivot, drill-through and drill-cross
  • ROLAP, MOLAP and HOLAP servers
  • Data warehousing applications (ETL, OLAP, etc.)
  • Case studies and exercises in multidimensional modeling
  • Illustration of various features using the Integration Services and Analysis Services modules in MS SQL Server


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

    December 5 to December 6 2018

Trainer(s) assigned(s)

Other course(s) in this category