Shopping Center Management Data Warehouse
2023
Course
Data Warehouses (ISEP PG Big Data & Decision Making)
- PostgreSQL
- Python
- Jupyter
- Faker
- SQLAlchemy
Star-schema warehouse for rental operations with synthetic data generation and analytics queries.
RepoCollaborators: Ana Fernandes, Daniel Osório, Marina Teixeira, Pedro Gomes
Star-schema warehouse for rental operations with synthetic data generation and analytics queries.
Purpose Model shopping center rental operations in a warehouse designed for occupancy analytics.
Approach Designed a star schema, generated realistic synthetic data with Faker, and delivered SQL scripts for schema creation and analysis.
Constraints Used synthetic data to keep the project reproducible without sensitive inputs.
Tech stack PostgreSQL · Python · Jupyter · Faker · SQLAlchemy