BD106

Data Warehousing Fundamentals

85%

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
Parcours

Formation path :

Databases Training Paths

View path
SUMMARY
DETAILS

Objectives

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.

Prerequisite

General knowledge of computer science.

Customer Testimonials

Genious. Very good trainer. Very comptetent. Bravo!

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

Content

  • 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

DATES*

*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