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

Dental practice CRM consolidation

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

What am I looking at? Every client practice keeps its leads in its own CRM sheet, with different column names and formats. This pipeline consolidates 180 of those sheets into one table, so the agency can steer setters and campaigns: who books, who shows up, which campaign brings the appointments. Press Run pipeline and watch the cleanup happen.

Pipeline idle

Source sheets raw · 3 client practices

Three CRM sheets belonging to three client practices: a Google Sheet with Italian dates and comma decimals, a clinic-software XLSX with ISO timestamps, and a hand-kept CSV export with mixed formats. Header names, value vocabularies and available columns 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

id_studionome_cognometelefonosetteresito_chiamatadata_appuntamentoora_appuntamentopresentatoad_nametotale_preventivo
run the pipeline to materialize the unified table