ETL & DATAWAREHOUSE TESTING Workshop

Data Warehouse and ETL Course

TOPICS:

1) Fundamentals of Business Intelligence and Data warehousing

  • Overview of the BI Organization Architecture
  • Business Intelligence Fundamentals
  • What is a Data Warehouse
  • What is a Data Mart
  • Enterprise Data Warehouse
  • What is ETL
  • Data Structures in ETL

2) Data Flow

  • Data Extraction
  • Data Cleaning and Conforming
  • Data Delivery with Dimension Tables
  • Data Delivery with Fact Tables

3) Implementation and Operations

  • Marketplace ETL Tools
  • Current Scripting Languages
  • Third Party Data Transfer
  • Sorting Data on Mainframe Systems
  • Sorting Data on Unix and Windows Systems
  • Using Database Bulk Loader utilities
  • Increasing ETL Throughput
  • ETL Scheduling
  • Tuning ETL Processes

4) Metadata

  • Defining Metadata
  • Business Metadata
  • Technical Metadata
  • Process Metadata

5) Planning and Testing ETL

  • Building Development Environment
  • Business Requirements Analysis
  • Defining the Scope of the ETL project
  • Designing the Logical Data Map
  • Defining the Data Quality Strategies
  • Testing the ETL processes
  • Developing Test Cases
  • Deployment

6) Real-Time ETL Overview

  • Defining Real-Time ETL
  • Real-Time Data warehouse review