This project demonstrates an end-to-end data pipeline:
- Extract data from CoinGecko API
- Transform using Python
- Load into PostgreSQL
- Build a data warehouse (star schema)
- Python
- PostgreSQL
- SQL
- ETL pipeline
- Data warehouse design
- Analytical queries
- Install dependencies
- Set environment variables
- Run ETL script
- Run warehouse loader