How to...Prep Index

1. Introduction









2. Connecting to Data









3. Data Types





4. Clean 









5. Shape your Data

How to... Aggregate in Prep



6. Multiple Data Sets
How to... Join Datasets Together


How to...Union


How to...Scaffold your Data


7. Strategy
How to...decide Where to Prepare your Data?


How to... decide where to where to Store your Data

How to... use Smarter Filtering






8. Output
How to... Choose an Output


How to... keep your data up to date

How to... document your Data Preparation


9. Advanced Techniques
How to... use Custom SQL in Prep


10. Tips and Tricks

Popular posts from this blog

2023: Week 1 The Data Source Bank

2023: Week 2 - International Bank Account Numbers

How to...Handle Free Text