{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,4,25]],"date-time":"2025-04-25T04:18:12Z","timestamp":1745554692597,"version":"3.40.4"},"reference-count":0,"publisher":"IOS Press","isbn-type":[{"value":"9781643685922","type":"electronic"}],"license":[{"start":{"date-parts":[[2025,4,24]],"date-time":"2025-04-24T00:00:00Z","timestamp":1745452800000},"content-version":"unspecified","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by-nc\/4.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2025,4,24]]},"abstract":"<jats:p>Background: The accumulation of Real-World Data (RWD) from Electronic Health Records (EHRs) and registries offers substantial potential for generating Real-World Evidence (RWE). However, the ability to generate robust evidence from real-world data hinges on its quality. This is especially critical when heterogeneous data is first transformed into standardized, research-ready data models. Objective: This study presents an approach for assessing data completeness through a pipeline for extracting and transforming oncological RWD. Methods: We introduce a technical solution that enables the assessment of data completeness across three data transformation stages, beginning with the initial data source and extending through Health Level 7 (HL7) Fast Healthcare Interoperability Resources (FHIR) to CSV. Results: Using Trino, a distributed SQL engine, we evaluate data completeness at the three transformation stages by comparing cancer diagnosis counts. The modular pipeline design, compatible with various data sources, allows for error detection in ETL processes. Conclusion: Future work will expand the system to address additional data quality dimensions, such as correctness and plausibility, improving the overall robustness of data analytics in federated environments.<\/jats:p>","DOI":"10.3233\/shti250161","type":"book-chapter","created":{"date-parts":[[2025,4,24]],"date-time":"2025-04-24T09:29:12Z","timestamp":1745486952000},"source":"Crossref","is-referenced-by-count":0,"title":["Assuring End-to-End Data Quality for Analytics on FHIR"],"prefix":"10.3233","author":[{"given":"Jasmin","family":"Ziegler","sequence":"first","affiliation":[{"name":"Medical Center for Information and Communication Technology, Universit\u00e4tsklinikum Erlangen, Erlangen, Germany"},{"name":"Bavarian Cancer Research Center (BZKF)"},{"name":"Friedrich-Alexander-Universit\u00e4t Erlangen-N\u00fcrnberg, Medical Informatics, Erlangen, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Clara","family":"Fischer","sequence":"additional","affiliation":[{"name":"Bavarian Cancer Research Center (BZKF)"},{"name":"Medical Data Integration Center (MEDIZUKR), University Hospital Regensburg, Regensburg Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Paul-Christian","family":"Volkmer","sequence":"additional","affiliation":[{"name":"Bavarian Cancer Research Center (BZKF)"},{"name":"Comprehensive Cancer Center Mainfranken, W\u00fcrzburg, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Marcel","family":"Erpenbeck","sequence":"additional","affiliation":[{"name":"Medical Center for Information and Communication Technology, Universit\u00e4tsklinikum Erlangen, Erlangen, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jonathan M.","family":"Mang","sequence":"additional","affiliation":[{"name":"Medical Center for Information and Communication Technology, Universit\u00e4tsklinikum Erlangen, Erlangen, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Thomas","family":"Ganslandt","sequence":"additional","affiliation":[{"name":"Friedrich-Alexander-Universit\u00e4t Erlangen-N\u00fcrnberg, Medical Informatics, Erlangen, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Hans-Ulrich","family":"Prokosch","sequence":"additional","affiliation":[{"name":"Bavarian Cancer Research Center (BZKF)"},{"name":"Friedrich-Alexander-Universit\u00e4t Erlangen-N\u00fcrnberg, Medical Informatics, Erlangen, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Christian","family":"Gulden","sequence":"additional","affiliation":[{"name":"Bavarian Cancer Research Center (BZKF)"},{"name":"Friedrich-Alexander-Universit\u00e4t Erlangen-N\u00fcrnberg, Medical Informatics, Erlangen, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"7437","container-title":["Studies in Health Technology and Informatics","dHealth 2025"],"original-title":[],"link":[{"URL":"https:\/\/ebooks.iospress.nl\/pdf\/doi\/10.3233\/SHTI250161","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,4,24]],"date-time":"2025-04-24T09:29:12Z","timestamp":1745486952000},"score":1,"resource":{"primary":{"URL":"https:\/\/ebooks.iospress.nl\/doi\/10.3233\/SHTI250161"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,4,24]]},"ISBN":["9781643685922"],"references-count":0,"URL":"https:\/\/doi.org\/10.3233\/shti250161","relation":{},"ISSN":["0926-9630","1879-8365"],"issn-type":[{"value":"0926-9630","type":"print"},{"value":"1879-8365","type":"electronic"}],"subject":[],"published":{"date-parts":[[2025,4,24]]}}}