etl overview training
DESCRIPTION
ETL, Business Intelligence, DWH, BI TrainingTRANSCRIPT
Business Intelligence - BI - ETL - Developer -Training
Index1. Data Warehousing Concepts2. What is Data Warehouse (DHW)?3. Difference between OLTP and DWH?4. Data Acquisition5. Data Extraction6. Data Transformation7. Data Loading8. Data Marts9. Dependent Data Mart
10. Independent Data Mart11. Database Design12. Star Scheme
13. Basic Concept in SQL14. Overview of ETL Tool Architecture15. White Box Testing Functionality on
Different transformation Rules16. Data Warehouse Life Cycle17. Types of Testing Techniques in ETL
What is ETL?In computing, extract, transform, and load (ETL) refers to a process in database usage and especially in data warehousing that:
● Extracts data from outside sources● Transforms it to fit operational needs, which can
include quality levels● Loads it into the end target (database, more
specifically, operational data store, data mart, or data warehouse)
ETL
Data Sources A
Data Warehouse Data Sources B
Data Sources C
ETL Scenario ● When there are many source systems to be
integrated
● When source systems are in different formats
● When this process needs to be run repeatedly
(e.g. daily, hourly, real time)
● To take advantage of pre-built
warehouses/marts. Many of these exist for
popular platforms such as PeopleSoft, SAP, JD
Edwards.
ETL Process
From Data -> Business Value
ETL Testing ConceptsSource System ETL Layer Data and Meta data Layer Presentation Layer
EnterpriseDataWarehouse
MetadataRepository
ODS
Data
Data
Data
Extract.Transformation, and load (ETL) Layer
● Clease Data● Filter Records● Standardizad Value● Decode Values● Apply Business
Rules● Householding● Dumpe records● Merge record
Transaction system● SAP ERP● SAP CRM● E-Commerce
External Data● Excel●
● Reporting Tools
● OLAP TOOLS
● Ad Hoc Query Tools
● Data Mining Tools
External Data● Excel●
ETL Tools:- BODS 4.0- Informatica PowerMart
- Oracle- SQL Server- Teradata- DB2
ETL Tools:- Business Objects 4.0- HTML ReportsCognos
Source systems
ETL Vendors
ETL Reporting tools
2. BI Launchpad
3. BO Dashboard
4. Information design Tool
5. Crystal Reports 2011
6. BO Analysis for OLAP
7. BI Workspaces
SAP BO 4.0 Interactive Analysis
Next step?
Contact Me● ETL Design● ETL Building● ETL Testing● ETL Support● ETL Training
BSc. Mondy HoltenSoftware Engineer (ETL, BI, SAP, HCM)
[email protected]+31629446309