Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
Data Quality: Analytics and Serving

Data Quality: Analytics and Serving

1h 2mAdvanced2025-06-27

Authors

Mark Freeman

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

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
Zarinpal
Zibal