This project demonstrates a comprehensive data warehousing and analytics solution using PostgreSQL, from building a data warehouse to generating actionable insights. Designed as a portfolio project, it highlights industry best practices in data engineering and analytics with a medallion architecture.
Data Warehouse: PostgreSQL-based with Bronze, Silver, and Gold layers. ETL Pipelines: Automated data extraction, transformation, and loading using Python and SQL. Analytics: Actionable insights derived via SQL queries and visualizations. Best Practices: Data quality checks, modular design, and documentation.