Extracting, Transforming and Loading data (ETL) is typical the most time consuming and difficult tasks of most data integration projects such as required for Data Warehousing solutions. The usability of most ETL tools has improved greatly in the last decade but finding the right things to click on is just a minor part of the challenge. Data cleansing, managing historic data, ensuring data integrity and implementing business rules presents the ETL developer with many challenges. Addressing these challenges is done though a well designed and structured approach.

Content: This course teaches the skills required to plan and design the ETL process, covering areas such as structure, techniques and operations. You will learn to address the typical challenges in a structured and proven approach. More specifically the course covers:

• Architecture and ETL design
• Designing logical layers in the ETL process
• Source system analysis
• Capturing and storing historic data, e.g. slowly changing dimensions
• Data quality and data cleansing
• Typical transformations and ETL flows
• Managing Meta Data
• Designing for stable operations, maintenance and error management
• Organizational roles and responsibilities
• Practical exercises

Target audience: The course is aimed at Business Intelligence architects and developers who are new to the ETL processes as well as the more experienced who are looking for ways to structure their work and improve their skills.

Attendee requirements: Attendees should have a professional IT background or should have worked with IT for a longer period of time. Experience with relational databases and SQL is required. Attendees should have data modeling skills at a similar level to the course Data Mart design – dimensional modeling.

Duration: 1 day advanced course

Price: AUD 1.150 ex. VAT