Skip to main content

Data Shaping

Unpivoting, pivoting, splitting and merging columns, reshaping wide to long.

Questions

DD-TRF-001-Q018 — Unpivoted target rows

DD-TRF-002-Q032 — Largest monthly shortfall against target

Datasets

DD-TRF-001 — Basic Data Cleaning and Shaping

DD-TRF-002 — Multi-File Transformation and Data Quality

Compatible tools

Power BI

Python

Excel

SQL