# Capstone Project Day 1 Lecture

> In this lecture, Zach shares his experiences with replicating Heroku and working with Postgres, emphasizing the importance of maintaining data integrity while querying. He discusses the significance of starting with dimensions in your capstone projects and the challenges of handling sensitive infor…

- Web page: https://www.dataexpert.io/lesson/capstone-project-day-1-lecture-april2025-p735-l1051
- Program: [AnalyticsExpert](https://www.dataexpert.io/program/analytics-expert)
- Module: Week 8: End-to-End Project Hacking
- Access: Requires enrollment in AnalyticsExpert
- Length: 53 min video
- Skills: SQL, Data Modeling, ETL/ELT, Postgres, Kafka
- Academy: DataExpert.io Academy

## About this lesson

In this lecture, Zach shares his experiences with replicating Heroku and working with Postgres, emphasizing the importance of maintaining data integrity while querying. He discusses the significance of starting with dimensions in your capstone projects and the challenges of handling sensitive information in data models. He also touches on the need for real-time updates for student progress and the use of tools like DBT and Astronomer for data orchestration.

## Navigation

- Previous lesson: [Grouping sets and Window functions Lab](https://www.dataexpert.io/lesson/grouping-sets-and-window-functions-lab-p735-l581.md)
- Next lesson: [Capstone Project Day 1 Lab](https://www.dataexpert.io/lesson/capstone-project-day-1-lab-april2025-p735-l1052.md)