Data Warehouse Design

Discover key principles, techniques, tools and applications.


overall satisfaction for this course

?Average calculated from scores obtained from 590 participants who took this course.
  • Duration 2 days
  • Regular fee 955
  • Preferential fee 860?
  • Locations
    • Montreal
    • Quebec City
  • Laboratory


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

Wow! Finally, training I can truly use in the workplace.

Annie L. / Directrice de produits, Banque Nationale du Canada


  • 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

    November 7 to November 8 2019

  • Quebec City

    November 7 to November 8 2019 - Virtual Classroom

Trainer(s) assigned(s)

Other course(s) in this category