L2 · Required

Extract, transform and load

Use extract, transform and load to make decisions inspectable.

What you should be able to do

Independently: Map a source, transformation and destination table.

Suggested prerequisites

A short guide

Use extract, transform and load to make decisions inspectable. Map a source, transformation and destination table. Read the indicated source section, identify its key concepts and conditions, and work through the example. Record inputs, sources, units and assumptions. Keep your method separate from the result, mark unanswered questions, and review the output against the checklist.

An example

Retaining raw inputs helps trace transformation differences.

Your task

Map a source, transformation and destination table.

Start with this source

Read the indicated section relevant to extract, transform and load and complete the foundation task.

This source is awaiting renewed review. Try the task above and adjacent skills; reviewed sources will appear here.

Your learning checklist

Required items: 0 / 10 completed or already known

Device storage

Next: Read a role through its responsibilities

Checklist statuses are self-reported; exercise scores are recorded separately. You can reset any item.

Self-check