We move! Starting September 1st, our QUEBEC CITY training center will be located at 5400, des Galeries Blvd, Suite 500, 5th Floor, Québec (Quebec) G2K 2B4
BD106

Data Warehouse Design

Discover key principles, techniques, tools and applications.

86%

overall satisfaction for this course

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

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.

Training Details

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
  • Considerations for Power BI
  • 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

Customer Testimonials

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

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

Select the training date*

*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

  • Montreal

    February 24 to February 25 2020

  • Quebec City

    June 15 to June 16 2020

Trainer(s) assigned(s)

Other course(s) in this category