Exercise: Data profiling, part 1

Contents

• Introduction Introduction

  • Analytics and service lessons in data quality

    37s
• 1. Project Introduction 1. Project Introduction

  • (Locked)
    Project scenario

    2m 14s
  • (Locked)
    Codespaces and repository overview

    3m 30s
  • (Locked)
    CLI and dbt docs

    2m 19s
  • (Locked)
    Data infrastructure and reports

    1m 30s
  • (Locked)
    The downstream data quality resolution process

    1m 46s
• 2. Bring on the Chaos 2. Bring on the Chaos

  • (Locked)
    Challenge: Bring on the chaos

    1m 51s
  • (Locked)
    Solution: Bring on the chaos

    1m 46s
• 3. Issue Scoping 3. Issue Scoping

  • Exercise: Issue scoping

    2m 25s
  • (Locked)
    Exercise: Documenting the scope

    57s
• 4. Issue Replication 4. Issue Replication

  • (Locked)
    Exercise: Issue replication

    2m 8s
  • (Locked)
    Exercise: Documenting the replication

    4m 9s
• 5. Data Profiling 5. Data Profiling

  • (Locked)
    Exercise: Data profiling, part 1

    1m 24s
  • Exercise: Using lineage for profiling

    2m 49s
  • (Locked)
    Exercise: Documenting the profiling plan

    41s
• 6. Data Profiling Queries 6. Data Profiling Queries

  • (Locked)
    Exercise: Data profiling with queries, part 2

    4m 22s
  • (Locked)
    Exercise: Querying for discrepancies

    2m 40s
  • (Locked)
    Exercise: Analyzing county data

    2m 11s
  • (Locked)
    Exercise: Analyzing issuing agency data

    2m 37s
  • (Locked)
    Exercise: Summarizing profiling findings

    1m 32s
• 7. Downstream Pipeline Investigation 7. Downstream Pipeline Investigation

  • (Locked)
    Exercise: Downstream pipeline investigation

    1m
  • (Locked)
    Exercise: Identifying problematic business logic

    2m 53s
• 8. Implement the Fix (Tests) 8. Implement the Fix (Tests)

  • (Locked)
    Exercise: Implementing DQ fix tests, part 1

    3m 5s
  • (Locked)
    Exercise: Creating and running DQ tests

    3m 2s
• 9. Implement the Fix (Code) 9. Implement the Fix (Code)

  • (Locked)
    Exercise: Implementing the DQ fix, part 2

    1m 3s
  • (Locked)
    Exercise: Applying the final code fix

    4m 22s
• 10. Stakeholder Communications 10. Stakeholder Communications

  • (Locked)
    Stakeholder communications

    49s
  • (Locked)
    Summarizing findings with the SBAR method

    1m 38s
• Conclusion Conclusion

  • (Locked)
    Next steps

    29s