Data Quality: Analytics and Serving
1h 2mAdvanced2025-06-27
Authors

Mark Freeman
Course details
Dive into the practical aspects of data quality in this hands-on course that equips you with hands-on coding skills in a sandbox environment. Data engineer Mark Freeman shows you how to identify, analyze, and resolve data quality issues using robust approaches like root cause analysis and chaos engineering. Discover how to use SQL queries and DBT tests to safeguard data pipelines and ensure the reliability of your datasets. Learn about downstream pipeline investigations and uncover the business logic that affects data quality. Find out how to apply SBAR strategies to convey your insights to stakeholders. Whether you're a data scientist, analyst, or simply enthusiastic about improving data workflows, this course helps you unlock your potential to solve complex data quality problems while making a significant impact in data-driven environments.
Concepts
Introduction
- Analytics and service lessons in data quality
Project Introduction
- Project scenario
- Codespaces and repository overview
- CLI and dbt docs
- Data infrastructure and reports
- The downstream data quality resolution process
Bring on the Chaos
- Challenge - Bring on the chaos
- Solution - Bring on the chaos
Issue Scoping
- Exercise - Issue scoping
- Exercise - Documenting the scope
Issue Replication
- Exercise - Issue replication
- Exercise - Documenting the replication
Data Profiling
- Exercise - Data profiling, part 1
- Exercise - Using lineage for profiling
- Exercise - Documenting the profiling plan
Data Profiling Queries
- Exercise - Data profiling with queries, part 2
- Exercise - Querying for discrepancies
- Exercise - Analyzing county data
- Exercise - Analyzing issuing agency data
- Exercise - Summarizing profiling findings
Downstream Pipeline Investigation
- Exercise - Downstream pipeline investigation
- Exercise - Identifying problematic business logic
Implement the Fix (Tests)
- Exercise - Implementing DQ fix tests, part 1
- Exercise - Creating and running DQ tests
Implement the Fix (Code)
- Exercise - Implementing the DQ fix, part 2
- Exercise - Applying the final code fix
Stakeholder Communications
- Stakeholder communications
- Summarizing findings with the SBAR method
Conclusion
- Next steps