Who's got the hottest market?

Uses commercial real estate data from 2017 to define the top commercial real estate markets.

Comment

What it does

Uses commercial real estate data from 2017 to determine the real estate markets with most buying power.

How we built it

Used a software called Tableau to analyze and visualize the data. Excel file contained the data.

Challenges we ran into

Many zip codes had few data points, thus the meaning extracted for those localities may not accurately reflect that status of those localities.

What's next for Who's got the hottest market?

Use data extracting technology to scrape data from web pages

Built With

Share this project:

Updates

posted an update —

The data we had was for the commercial real estate data for the year of 2017.

1st Approach: The Standard Deviation Approach with regard to the price per square feet

  • Trying to look for zip codes with potential for commercial real estate valuation expansion.

  • Issues: Many zip codes had very few data points, with quite a few have less or equal to three which yielded highly biased standard deviation values. Because of that, the value of standard deviation could not give an accurate representation of the real estate market.

    https://public.tableau.com/profile/daqi.chen#!/vizhome/HackNC2019/Dashboard1

2nd Approach: Given a city, the total sales in commercial real estate in the year of 2017.

  • Identifying the market with the most buying power, or getting sold out.
  • With the limited data we have on broker firms, who are the largest players in the year 2017.
  • Issue: Only addressed the volume of real estate transaction, but doesn't necessarily take into account the quality or the total square footage sold in 2017. With more time and resources, maybe using data extracting from web pages.

https://public.tableau.com/profile/daqi.chen#!/vizhome/2017RecordsSoldHackNC2019/Broker?publish=yes

But Not Yet,

Bringing in population data from Government Census:

  • Took the top 10 most populated metropolitan cities.
  • Calculated the revenue of 2017 for each city.
  • Purpose: wanted to see if there is a correlation between population and total transaction values of commercial real estate in 2017

https://public.tableau.com/profile/daqi.chen#!/vizhome/2017RecordsSoldHackNC2019/Broker?publish=yes

Conclusion:
- Who's got the hottest market? - Las Vegas - There is a somewhat weak correlation between the population and the market for commercial real estate. - It's EXPENSIVE to live in New York.

Log in or sign up for Devpost to join the conversation.