BD106

Data Warehouse Design

Discover key principles, techniques, tools and applications.

86%

overall satisfaction for this course

?Average calculated from scores obtained from 583 participants who took this course.
  • Duration 2 days
  • Regular fee 955
  • Preferential fee 860?
  • Locations
    • Quebec City
    • Montreal
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

Business analysts and developers.

Prerequisite

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

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)
  • 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

DATES*

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

    December 5 to December 6 2018 - Virtual Classroom

  • Montreal

    December 5 to December 6 2018

  • Montreal

    April 8 to April 9 2019

Trainer(s) assigned(s)

Other course(s) in this category