Adding Data Quality - Kimball Data Warehouse
Explore a 50-minute conference talk from the PASS Data Community Summit that introduces a design architecture for capturing and measuring data quality issues in small to mid-size Kimball data warehouses. Learn how to relate these issues to existing fact and dimension tables. Dive into topics such as data quality definitions, mandated reporting, organizational commitment, metadata, master data, data profiling, and design implementation. Discover the secrets of sequence IDs, data quality rules execution, and the structure of data quality schemas. Examine case studies, reporting requirements, data flow, and mandatory reporting workflows. Gain insights into improving data warehouse quality and efficiency through this comprehensive presentation by Robert Hart, an Architect at the 2018 PASS Marathon event.