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 945
  • Preferential fee 795?
  • 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

Business analysts and developers.

Prerequisite

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 Corporation Financière

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.
  • Montreal

    February 21 to February 22 2018

  • Quebec City

    February 28 to March 1 2018

  • Montreal

    June 6 to June 7 2018

Trainer(s) assigned(s)

Other course(s) in this category