← Back to portfolio
ITSynthetic interactive reconstruction based on real delivery patterns. No production or client data.
Case 03 / ETL and QA lab

Payment tooling and CRM analysis

Synthetic interactive reconstruction based on real delivery patterns. No production or client data.

What am I looking at? Money stops slipping through the cracks: 180 messy spreadsheets become one clean table of who paid and who is behind. Press Run pipeline and watch the cleanup happen.

Pipeline idle

Source files raw · 3 systems

Three exports from different tools: a booking CSV (Italian dates, comma decimals), a payments dump (ISO dates, dotted decimals), and a hand-kept ledger (mixed, some malformed rows). Column names and formats disagree on purpose.

Run log discover → map → normalize → QA

Press "Run pipeline" to discover the sources, map columns, normalize values, and produce the QA report.

Normalized output no rows yet

patient_refsourcebooking_dateamount_eurplan_statusmethod
run the pipeline to materialize the unified table