Finance area · 4 datasets

Data Transformation datasets for Power BI, Excel and Python practice

Tool-neutral cleaning, shaping, integration and performance exercises.

Basic Data Cleaning and Shaping

Clean one dirty transaction export: fix types, remove duplicates, standardise codes, map regions and unpivot a wide target sheet.

DD-TRF-001 · XLSX · ~10,000 rows · 30 questions

Multi-File Transformation and Data Quality

Combine four branch files with schema differences, reconcile them to the central export, validate keys and unpivot monthly targets.

DD-TRF-002 · CSV · ~30,000 rows · 40 questions

Complex Joins, Exceptions and Transformation Logic

Join effective-dated customer attributes, map aliases, convert currencies, apply exception rules and reconcile six monthly batches to the export.

DD-TRF-003 · PARQUET · ~500,000 rows · 50 questions

Enterprise Data Transformation and Performance Lab

Run the same transformation logic over a multi-million-row export and twelve monthly partitions with schema drift, incremental loads and survivorship...

DD-TRF-004 · PARQUET · ~3,000,000 rows · 60 questions

Free account: download the data, check your answers and earn a certificate.

Create a free account

More practice data

Real Estate Retail Healthcare Manufacturing Logistics Consolidation General Ledger & Trial Balance Budget vs Actual Working Capital Procurement & Spend Project Management & Project Accounting HR & Payroll Analytics Accounts Receivable & Collections Inventory & Stock Accounts Payable & Payments Cash Flow Planning