The Data Warehouse Lifecycle

Training

Inhouse

£ 975 + VAT

Description

  • Type

    Training

  • Methodology

    Inhouse

  • Duration

    3 Days

This course is designed to equip delegates with the fundamentals and techniques required to build a comprehensive data warehouse. We believe that in today's market, professionals need to be multi talented and strategically positioned for the growth in Data Warehousing and Dimensional Modelling and this course will help prepare you for the implementation of a successful data warehouse. Suitable for: This course is valuable for all those involved in major roles on a data warehouse project, from project managers to DBAs to data modellers and application developers. It is also ideal for IT professionals from various backgrounds including Information technology, who plan to cross train into Data warehousing and Dimensional modelling to enhance their careers.

About this course

Information Technology background and good understanding of english.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

The Data Warehouse Lifecycle

Course Outline


Data Warehousing framework

  • Concepts and definitions

    Project Planning


  • Scoping and risk assessment


  • Data warehouse project team roles and responsibilities


  • Project plan development and maintenance

    Dimensional Modelling


  • Definition of dimensional modelling


  • Definition of Fact and dimension tables


  • 4-step process for designing dimensional models


  • Denormalizing dimension hierarchies


  • Surrogate keys


  • Factless fact tables


  • Degenerate dimensions


  • Conforming dimensions


  • Slowing changing dimension techniques


  • Types of Fact tables


  • Large dimension design considerations


  • Multi-valued dimension attributes

    Product Selection


  • Techniques

    Deployment


  • speeding up the load cycle


  • Integrating data from multiple sources


  • Data Quality and Data Cleansing


  • User Education

    Technical Architecture


  • Overview of technical architecture


  • Architecture and Infrastructure


  • Planning and Growth


  • Common components and services


  • Staging area considerations


  • Data warehouse user types

    Metadata Management


  • Sources and management of metadata

    Design and Development


  • Operational Data Store (ODS)


  • Data management


  • Basic extract, transformation and load techniques


  • Surrogate key creation and maintenance


  • Fact table extract issues


  • Building aggregates

    On-going Maintenance


  • Training and support approaches


  • User support


  • Documentation and the web


  • On-going system maintenance

  • Additional information

    Support: No.
    Students per class: 20

    The Data Warehouse Lifecycle

    £ 975 + VAT