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