Data Preparation Best Practices¶
Power Query¶
- Data should be transformed as far upstream as possible, and as far downstream as necessary 1
- Filter early in transformations
- Maintain Query folding as long as possible in Power Query to push transformations to source
- Use Incremental refresh where possible to reduce size of refreshes