# Hard Orchestration Lessons Day 2 Lecture

> In this lecture, Zach explores the complexities of Airbnb's PNA system, focusing on key issues and solutions. He discusses challenges related to availability definitions, backfilling historical data, and optimizing pipeline designs. Zach suggests actions around communication frequency, stakeholder…

- Web page: https://www.dataexpert.io/lesson/hard-orchestration-lessons-day-2-lecture-jan2025-p736-l725
- Program: [AnalyticsExpert](https://www.dataexpert.io/program/analytics-expert)
- Module: Week 6: Airflow & Pipeline Specs with Trino
- Access: Requires enrollment in AnalyticsExpert
- Length: 45 min video
- Skills: Data Modeling, ETL/ELT, Apache Spark, Data Warehousing
- Academy: DataExpert.io Academy

## About this lesson

In this lecture, Zach explores the complexities of Airbnb's PNA system, focusing on key issues and solutions. He discusses challenges related to availability definitions, backfilling historical data, and optimizing pipeline designs. Zach suggests actions around communication frequency, stakeholder engagement, and iterative design improvements.

## Navigation

- Previous lesson: [Orchestration and Airflow Fundamentals Day 1 Lab](https://www.dataexpert.io/lesson/orchestration-and-airflow-fundamentals-day-1-lab-jan2025-p736-l1826.md)
- Next lesson: [Hard Orchestration Lessons Day 2 Lab](https://www.dataexpert.io/lesson/hard-orchestration-lessons-day-2-lab-jan2025-p736-l726.md)