Comprehensive real estate data analysis, submarket division, and property evaluation

Actions Taken

Created a streamlined data set that can help clientele understand the actual property value in today’s time. These are the actions taken to carry out this process smoothly -

1. Data Enrichment

• Cleaned and aligned submarket boundaries, resolving gaps and overlaps
• Created 10-15 metadata fields for better insights into submarkets
• Downloaded US Census spatial data for intersection with submarkets
• Assigned Opportunity Zone boundaries through the spatial intersection
• Documented data dictionary for best practices

2. Relational Data Creation

• Developed ETL processes for FHA multifamily, nursing home, LIHTC, and EnergyStar data
• Extracted relevant fields, geocoded data, and assigned submarkets
• Established quarterly update procedures for data maintenance

3. Market-Level Analysis

• Compiled aggregated statistics including count, average, and median at submarket and CBSA levels
• Developed a data dictionary for the market-level data table
• Generated a Microsoft Excel file containing tables and charts for easy query and visualization

4. Data Governance and Security

• Ensured secure data transfer using SFTP or shared drives
• Implemented GIS best practices for data rendering and accuracy
• Designed the project to adhere to data destruction requirements for compliance

5. Proof of Concept

• Designed and developed a sample real estate dashboard illustrating the benefits of submarket-based analysis
• Demonstrated the use of spatial data and relational datasets for insightful market-level analytics