Overview
In looking for apartments over the years in New York City, I’ve found that it is difficult to prioritize some of the most important factors. There is always lots of competition for apartments in NYC, and often, I found myself going on tours where the apartment was far smaller than it looked in pictures, overpriced, or in an inconvenient location for moving about the city.
The goal of this project is to allow for users of the dashboard to be able to weigh features that matter most to them and be provided with a list of their best apartment matches, with direct links to listing for applying or scheduling tours.
The code repository for additional detail on the methodology of the end-to-end data pipeline can be found here: GitHub
Dashboard
User-assigned Weights
- Rent Price ($)
- Square Footage
- Distance to Nearest Subway
- Distance to Downtown Manhattan
- Neighborhood Safety
Interactive Filters
- # of Bedrooms
- # of Bathrooms
- Neighborhood
- Rent Price ($)
- Square Footage
- Distance to Nearest Subway
- Distance to Downtown Manhattan
- Neighborhood Safety
Visualize Results
- Borough/Neighborhood based breakdown of averages of price, square footage, and other key metrics
- Ranked Apartment Match Scores, with direct links to listings, apartment images, and apartment features
Tech Stack
Programming & Scripting:
- Python (data processing, scoring scripts)
- SQL (queries, transformations)
Data Integration & ETL:
- Airbyte (ingesting Realtor.com API data)
- dbt (data transformations in Snowflake)
- Python scripts (apartment scoring, data cleaning)
Data Warehousing / Storage:
- Snowflake (storing transformed data)
- CSVs (static subway and neighborhood safety data)
Visualization / Dashboard:
- Looker Studio (interactive dashboard with weighted scores)
DevOps / Automation:
- Git (version control)
Future Improvements
- Expand to allow user to enter zip code, enabling users in all areas of the United States
- Add amenity filters such as pet policy, dishwasher, washer/dryer, elevator/walk-up, in-building gym, outdoor space, etc.
- Allow user to add additional features for weighing, such as distance to grocery store or other key life conveniences