Introduction
Overview
This ETL guide builds on the earlier guide written: ‘Starting with ETL’, and goes through a series of new and different techniques, for building on and further developing your ETL skills.
Guide summary
An outline of the main areas covered in this guide is provided below:
Combining Mismatched Tables
Use Conversion Tables to help overcome data inconsistencies
Preserving Context
Learn how to integrate into a dataset contextual information that maybe stored somewhere else
Transforming Data into tables
Understand the most performant way of laying out tables for later analysis
Generalised Unpivoting
Learn how to unpivot tables with a N x M hierarchical structure
Generalised Function
Create a generalised and re-usable custom function for unpivoting any M x N data table
Avoiding commont dataset pitfalls
Learn some tips and tricks for overcoming commonly encountered problems with ETL processes on datasets
The Challenge!
A short exercise for how to combine files that are in different layouts and formats
Data Cop!
A short exercise for how to uncover changes to a suspected compromised dataset
Feedback
Submit and view feedback