Data Warehousing Fundamentals


overall satisfaction for this course

?Average calculated from scores obtained from 555 participants who took this course.
  • Duration 2 days
  • Regular fee 895
  • Preferential fee 750?
  • Locations
    • Montreal
    • Quebec City

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

Application developers and business analysts.


General knowledge of computer science.

Customer Testimonials

Genious. Very good trainer. Very comptetent. Bravo!

Marie-Ève L. / Chef d'équipe de données, CNESST


  • 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)
  • Building a data warehouse: extracting, cleansing, transforming, consolidating, loading, implementing, operating and refreshing
  • Multidimensional 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 modelling
  • 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

    January 19 to January 20 2017

  • Montreal

    April 18 to April 19 2017

  • Quebec City

    July 12 to July 13 2017

Trainer(s) assigned(s)

Other course(s) in this category