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

Let’s get started

Image annotation




Computer Software

Client Profile

The client, a real estate data company, aimed to showcase their expertise in submarket-based real estate analysis by building a comprehensive data set for market analytics. This involved creating submarket boundaries within metropolitan areas, aggregating property data for various property types, and conducting spatial analysis to demonstrate the value of their data-driven approach. The ultimate goal was to attract a prospective client and, upon success, expand the project scope by partnering with an offshore team.

Business Objectives

  • Data Enrichment: Enhance existing submarket boundary definitions, derive metadata fields, and link boundary data to geographic entities (CBSA, County, Zip Codes, Opportunity Zones).
  • Relational Data Creation: Extract and aggregate property data from publicly available sources for different property types (FHA multifamily, nursing homes, LIHTC, EnergyStar).
  • Market Level Analysis: Develop a market-level data table with aggregated statistics for submarkets and CBSAs.
  • Data Governance and Security: Ensure secure data handling, adherence to data development standards, and compliance with data destruction requirements.
  • Proof of Concept: Present a sample real estate dashboard showcasing the power of spatial analysis and data aggregation.


  • Cleaning and aligning hand-drawn submarket boundaries for accuracy.
  • Extracting, transforming, and loading data from disparate sources with different formats.
  • Ensuring the security of data during transfer and development.
  • Adapting the project to accommodate potential client requests for specific data slices or APIs in the future.

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

Do you want real estate data analysis at competitive rates?


1. Successfully showcased the client's real estate expertise through a comprehensive case study

2. Created a prototype dashboard highlighting the power of spatial analysis and data aggregation

3. Demonstrated the potential value of the submarket approach for prospective clients

4. Positioned the client for further development phases and potential expansion

Our Carefully Considered Pricing Structure For our Services

Hourly Rates

Starting from: $4 Per Hour

Contact Us