David Haertzen

Business Process Engineering
Business Process Modeling
Business Process Engineering

Data Managmenent
Conceptual Data Modeling
Logical/Physical Data Modeling
Data Resource Management
Rapid Modeling with Teams
Modeling Fast Start

Data Warehousing
Dimensional Modeling
Extract Transform Load (ETL)

Project Management


Call: 612-281-2998


"Excellent presentation -  very crisp and effective ..." 

"The seminar was very practical and addressed our needs ..." 

"I came away with some new ideas and ways of thinking ..." 

The feature packed two-day course that gives you the tools
to populate the effective Data Warehouse or Data Mart. 

The First Place Learning Data Warehouse / Data Mart ETL Seminar will give you the knowledge needed to obtain and manage the data that is needed for business intelligence processes.

A complete architecture is described showing how data is obtained, manipulated and put into usable form. This approach enables the developers of the data warehouse to implement quickly and operate on an on going basis. Seminar participants will learn by case study examples as well as by "hands on" experience.

These seminars include an effective mix of exercises and presentations. Our Tricks and Traps sections will show you how to avoid problems and make good choices. Three database levels are included: data mart, integrated data mart, and data warehouse. Students will learn how to design and build extract, transform, cleanse and data into data warehouses and data marts.

  • HOW TO extract data from source systems
  • HOW TO cleanse and transform data
  • HOW TO handle data and process errors
  • HOW TO load the data warehouse
  • HOW TO select data going into the data warehouse
  • HOW TO load the data mart
  • HOW TO avoid traps and pitfalls
  • HOW TO manage the ongoing ETL process

You will receive a comprehensive manual and Data Warehousing ETL toolset that provides useful checklists, examples and reference material that will help you in your data warehousing ETL efforts. The usefulness of the course continues long after the class sessions.  

You will receive a Certificate of Completion upon successful completion of the course.  

  • Data Warehouse/Data Mart Implementers
  • Data Warehouse/Data Mart Architects
  • ETL Developers
  • Database Administrators

    I. Introduction to Extracting, Transforming, and Loading (ETL)  
    • Decisions Impact the Bottom Line
    • Data Warehouse Technical Architecture
    • ETL's Place in the Technical Architecture
    II. Identifying Input Sources  
    • Recognizing Business Events
    • Identifying the System of Record
    • Modeling the Input
    • Technology of the Input
    • Improving Data Quality
    III. Extracting Data  
    • Extract Strategies
    • Extract Techniques
    IV. Transforming Data  
    • Source to Target Mapping
    • Types of Transformations
    V. Controlling and Cleansing Data  
    • Data Quality Rules
    • Data Auditing, Filtering and Correction
    • Cleansing at Source and Target
    VI. Loading Data  
    • Data Staging
    • Mapping to Data Warehouse Key Structure
    • Data Aggregation / Summarization
    VII. ETL Tools  
    • In-house Tools
    • Metadata Management Tools
    • Data Modeling Tools
    • Integration Tools
    • Middleware
    • Data Warehouse Process Management
  • The Analytical Puzzle

    Copyright© 1996-2013, First Place Software, Inc.