Data qualityData qualityThe degree to which data is fit for purpose: accurate, complete, consistent, timely, valid and unique. Poor quality data undermines analytics, reporting and AI.Voir la définition complète → failures have a geography: they almost always originate at the source.
A report shows wrong revenue numbers. The investigation traces back through the Data warehouseData warehouseA central repository that consolidates data from many source systems into a structured, query-optimized store designed for analytics, reporting, and business intelligence.Voir la définition complète →, the ETL pipeline, the staging database, the integration, and finally to a source system that started sending malformed data six weeks ago. Six weeks of bad data in production. Six weeks of decisions made on incorrect information.
The "shift-left" principle borrows from software engineering: catch defects as early as possible in the development process, because fixing a bug in production is 100x more expensive than catching it in code review. Applied to data: catch quality issues at the source, not after the fact.
At the source system: Validation rules built into the application that produces the data. If a field cannot be null, the application enforces it, the Data pipelineData pipelineETL (Extract, Transform, Load) is a data integration process that pulls data from sources, reshapes it into a consistent format, and writes it into a target system.Voir la définition complète → never sees null values because they never enter the system.
At the ingestion layer: Data qualityData qualityThe degree to which data is fit for purpose: accurate, complete, consistent, timely, valid and unique. Poor quality data undermines analytics, reporting and AI.Voir la définition complète → checks run immediately when data enters your infrastructure. If the schemaschemaA schema is the formal blueprint that defines how data is structured, named, typed, and related within a database, file, or message.Voir la définition complète → doesn't match the contract, the pipelinepipelineAll active sales opportunities across the stages of the sales process, together with their combined potential value and probability of closing.Voir la définition complète → stops. If completeness drops below the SLA, an alert fires. Great Expectations, Soda, and Monte Carlo all operate here.
At the transformation layer: dbt (data build tool) has built-in testing: not-null tests, unique tests, referential integrity tests, accepted-value tests, custom SQLSQLSales Qualified Lead: a prospect the sales team has validated as ready for direct outreach and a proposal, having passed clear qualification criteria.Voir la définition complète → tests. Every dbt model should have tests. A dbt run that includes failing tests should not deploy to production. Many organizations run their dbt tests in CI/CD pipelines, no untested transformation reaches the Data warehouseData warehouseA central repository that consolidates data from many source systems into a structured, query-optimized store designed for analytics, reporting, and business intelligence.Voir la définition complète →.
At the serving layer: Dashboards and reports that expose data to business users should include data qualitydata qualityThe degree to which data is fit for purpose: accurate, complete, consistent, timely, valid and unique. Poor quality data undermines analytics, reporting and AI.Voir la définition complète → indicators: "Last refreshed: 2 hours ago. Quality score: 94%. Known issues: 0."
Vérification des acquis
1. According to the lesson, fixing a bug in production compared to catching it in code review is approximately how much more expensive?
2. In the opening scenario about wrong revenue numbers, how long had the source system been sending malformed data before the issue was discovered?
3. Data contracts, mentioned in the lesson's video reference with Chad Sanderson, primarily serve to:
4. Select ALL of the following that are tools/frameworks mentioned in the lesson as operating at the ingestion or transformation layer for data quality:
Sélectionnez toutes les réponses correctes.
5. Select ALL correct statements about embedding data quality in CI/CD pipelines according to the lesson:
Sélectionnez toutes les réponses correctes.
The gold standard for shift-left data qualitydata qualityThe degree to which data is fit for purpose: accurate, complete, consistent, timely, valid and unique. Poor quality data undermines analytics, reporting and AI.Voir la définition complète →: data qualitydata qualityThe degree to which data is fit for purpose: accurate, complete, consistent, timely, valid and unique. Poor quality data undermines analytics, reporting and AI.Voir la définition complète → tests run in CI/CD pipelines, failing builds are blocked from deployment, and quality metrics are tracked in the same dashboard as engineering metrics.
This requires:
1. Test coverage for data: Every critical pipelinepipelineAll active sales opportunities across the stages of the sales process, together with their combined potential value and probability of closing.Voir la définition complète → has documented quality tests. Tracked as a metric: "Percentage of data assets with quality tests: 67%." The CDO should set a target, say, 90%, and track it quarterly.
2. Automated validation on merge: When a data engineer submits a pull request that changes a pipelinepipelineAll active sales opportunities across the stages of the sales process, together with their combined potential value and probability of closing.Voir la définition complète →, automated tests run against a sample of production data. SchemaSchemaA schema is the formal blueprint that defines how data is structured, named, typed, and related within a database, file, or message.Voir la définition complète → changes that would break downstream contracts fail the build before merge.
3. Quality gates for promotion: Data doesn't move from staging to production without passing quality checks. This is standard in software engineering (you don't deploy broken code). It should be standard in data engineering too.
Airbnb built an internal framework called Minerva to solve a specific problem: hundreds of analysts were defining the same metrics differently, creating inconsistency that undermined trust in data.
Minerva is a metrics layer, a central repository where business metrics are defined once (by the business, with the data team), and consumed consistently across all BIBITechnologies and processes that turn raw data into actionable insights via reporting, dashboards and analysis, so teams can decide based on facts rather than intuition.Voir la définition complète → tools, data science models, and experiments.
The key insight: Minerva shifts "what does this metric mean?" from ad hoc analyst judgment to a governed, version-controlled definition. When a business metric changes (new return policy changes how revenue is counted), the definition is updated in one place and flows to all consumers.
This is shift-left data qualitydata qualityThe degree to which data is fit for purpose: accurate, complete, consistent, timely, valid and unique. Poor quality data undermines analytics, reporting and AI.Voir la définition complète → applied to semantic consistency rather than technical quality. It's one of the highest-leverage data governancedata governanceData governance is the set of policies, roles, and processes that ensure data is accurate, secure, well-defined, and used responsibly across an organization.Voir la définition complète → investments Airbnb has made, and the pattern is being replicated by organizations using dbt Semantic Layer, Looker measures, and other metrics-layer approaches.
These four metrics, tracked monthly, tell you whether your shift-left program is working.