03_Data Transformation
- What is trimming and why is it required?
- What is validation after transformation?
- What is window function usage in transformation?
- What issues arise due to wrong data types?
- What questions should a BA ask before defining transformations?
- What risks exist if transformation logic is incorrect?
- Which transformations break query folding?
- Why is data transformation required after extraction?
- Why step order matters in Power Query transformations?