Skip to content
Welcome! Are you part of the community? Sign up now.
x

Posted over 8 years ago

Big Data in Real Estate

In today's post, I want to use experience I've had in two fields that I really love: databases and real estate. Specifically, with databases I want to go over new techniques using more data and varieties of data as it pertains to real estate. First of all, many companies store data using Excel spreadsheets, flat files, or Quickbooks and there's nothing wrong with these techniques, until there's something wrong with them. These tools suffer to scale very well, which means that as you grow your business you will find it increasingly difficult to manually input sales leads, employees, contractors, accounting, business processes, and so on. However, you have to start somewhere and you can migrate this data to more robust solutions later on. Deciding on what tool to use is important, whether to rent using SaaS or buy is another important decision, but deciding what kind of company you want to be is the most important question to ask yourself. 

What kind of data is important to store? Maybe what you think is important today won't be important tomorrow or vice versa. Not all the data you want to know or store are numbers that easily fit into spreadsheets. Are there competitive advantages that can be gained from crunching numbers in real estate? Yes. Does it tell the whole story or the most important part of the story? No. I argue that the numbers, or the "cash flow" is less important than most investors believe it is. With some effort, anyone can collect public available data like: listing prices, sold prices, square feet, year built, rent amount, taxes, etc. What kinds of data are less accessible? How about perspective tenants phone calls in that area? Their jobs? Their criminal records? Their rental history? How do you measure all of that? 

What about a home inspection report? I would argue that the condition of the home is far more important than the cash flow. Although, I disagree with the gloom and doom nature of many home inspection reports, i.e. the house is not falling over tomorrow, the condition of an individual home matters far more than the numbers you put into a software program. Mother nature and individual properties do not care about your numbers, nor do your tenants. All of whom, can and will alter those numbers and distort your cash flow. 

I just provided some examples of a variety of data that cannot be captured in Relational Databases, like Excel. Pictures, text files, videos have to be stored in NoSQL databases. Quantifying non-structured data is possible using metadata and analysts in order to make analysis easier and more meaningful for decision-makers. Why is any of this important? 

You can definitely do business without any of this and many do business without any of these tools. However, you are doing business without capturing a more complete picture of the surrounding landscape. Are you just guessing? For example, what if one company established a tenant call line and they could accept or deny the tenant just based on their voice? What if you could store video for every single property and never show the property to tenants or buyers? What if you could measure air temperature every 10 seconds to minimize heating and cooling costs? What if you could measure water use every 10 seconds and identify tenants that are abusing water? What if you could know the condition of the property without getting off your sofa? Aggregating structured and non-structured data and knowing what to do with it has been the same challenge we faced since the beginning of time. Now, it's just about harnessing our capabilities, tools, and the data to make great decisions. 

Data can choke you and drown you if you do not understand it, cause you to pay attention to wrong kind of data, or ignore the most important kinds of data. I think of each of us as investors as ships (some bigger, some smaller) sailing along in a sea of data with all of its variety, volume, and velocity and we have to make decisions along the way. Make the right decisions and you end up on a beautiful island drinking Pina Coladas (I'd prefer Scotch, actually) or make the wrong ones and end up in Davey Jones' locker. Happy Investing! 


Comments (2)

  1. Great post (I know i'ma bit lat to the party but...) thanks for sharing!
    Using SQL or other date analysis tools sounds like an amazing idea and it can help a lot with the amount of work you need to put in. I was wondering though how do you get the data? Do you create your own DB or do you use an already existing one somewhere online? 
      


  2. In addition to the data though is understanding how to properly interpret the data. As Mark Twain said...there are lies, there are damn lies, and there are statistics.  I see many investors and agents who are able to spot off statistics and data points, but they misinterpret those numbers incorrectly.  

    Good Read!