- Transformation responsibility (Data shaping – mostly Power Query / ETL):
I prepare and clean raw data so it becomes analysis-ready.
I remove duplicates, fix data types, handle nulls, split columns, and standardize formats.
I combine multiple source files and create calculated columns like “Net Amount”.
Example: I merged CRM + billing exports and converted dates & currencies before loading.
Goal is to make data accurate, consistent, and structured — not analytical yet.
What is transformation vs modeling responsibility?
Updated on February 11, 2026
< 1 min read