logo
Home

Introduction to Data Warehousing Training

  • CMDBID 107440
  • Course Code WA1816
  • Duration 2 Days
Scroll

Data Center Course

course overview

Click to View dates & book now

Overview

This 2-day course examines and establishes the fundamental theories, concepts, domains, techniques and terminology that are essential for every business and information technology professional who is involved in data warehousing. Students are introduced to best practice approaches and structures for data warehouse development and implementation. Common definitions and characteristics of data warehouses, data warehouse architectures, readiness issues, incremental data warehouse project planning, data warehouse strategy and mistakes to avoid all receive special emphasis.

This course concentrates on data warehouse deliverables independent of any specific methods, but within the framework of best practices. It focuses on understanding deliverables that may be produced throughout the data warehouse process and issues reasons for producing them. This course closes with exploration for practical next steps the students can take. This includes steps further to develop knowledge and skills, to position oneself for success, and to get started with data warehousing.

Audience

  • Anyone new to data warehousing
  • Those who want to review the fundamentals of data warehousing from a best practices standpoint
  • Business and systems managers who are evaluating data warehousing

Skills Gained

  • Understand and apply the concepts, processes and principles of data warehousing
  • Identify the components of a data warehouse architecture
  • Be familiar with data warehouse terminology
  • Identify success and risk factors of data warehousing
  • Place deliverables within the context of a comprehensive data warehousing process
  • Take practical steps to begin a success data warehousing initiative

Prerequisites

There are no prerequisites

Duration 2 days

Outline

Outline of Introduction to Data Warehousing Training 1. Introduction to Data Warehousing

  • Basic Concepts and Definitions
    • Definition of the data warehouse (DW)
    • Overall architecture of a DW
    • DW processes
    • Categories of DW technology
    • DW project and initiative types
  • Project Management Deliverables
    • DW strategy
    • DW project scope
    • DW project plan
    • Managing a DW project
    • The iterative release model
  • Introduction to the Dimensional Model
    • Facts
    • Dimensions
    • Star schemas
    • Snowflakes
  • Architectural deliverables
    • Requirements
    • Analysis
    • Design
    • Infrastructure
    • Implementation

2. Implementation, Operation and Expansion

  • Implementation Deliverables
    • Outcomes from analysis
    • Outcomes from design
    • Outcomes from construction
    • Outcomes from deployment
    • Operational Deliverables
    • Service level agreements
    • Outcomes of usage
    • DW monitoring
    • DW governance
  • Maintaining the DW
    • Incremental DW releases
    • Follow-up to DW
    • On-going assessment
    • Post mortem and lessons learned
    • Managing consultants
    • Managing the vendor
    • Getting started with data warehousing

Talk to an expert

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

All $ prices are in USD unless it’s a NZ or AU date

SPVC = Self Paced Virtual Class

LVC = Live Virtual Class

Please Note: All courses are availaible as Live Virtual Classes

Trusted by over 1/2 million students in 15 countries

Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well as public sector institutions such as the Department of Defence and the Department of Health.