Here are 4 ways dirty data can disrupt real estate reporting
We need to talk about dirty data.
This provocative couplet – referring to data that is inaccurate, incomplete, or out-of-date – represents a significant liability for real estate investment firms, regardless of property type.
When dirty data enters the asset lifecycle, particularly in the early stages like acquisition and underwriting, it is passed from stage-to-stage, all the way to the investor. Siloed processes and non-integrated software enable and exacerbate its spread, particularly spreadsheet software like Microsoft Excel. Considering that roughly three in every four commercial real estate firms rely on spreadsheets to store critical data – meaning they have no single source of truth – this is not a small problem.
In this post, we’re going to highlight four ways that dirty data can negatively impact real estate reporting, and then share a solution that can help eliminate your data integrity issues for good.
1. Time is Money
Monthly and other regular reporting chores are painful enough for real estate firms – just imagine what a pain reporting can be when you have Dirty Data? Having to reconcile faulty numbers takes time – by some client estimates, we’re talking upwards of 300 to 400 hours per quarter.
2. Rising Headcounts
Not only does dirty data cost you in terms of time spent reporting, but there can also be significant personnel costs, as well. Bad data takes a lot of time and many hands to sort through – and as assets under management grow, firms with bad data invariably see a rise in headcount to deal with the influx of even more data. That vicious cycle cuts into profit margins and stretches staff resources.
3. Risky Business
Dirty Data increases operational risk, as more and more staff are looped into proprietary, siloed processes. If a critical data trove is siloed within the underwriting team and a key member of that team quits, that’s – well, that’s really bad.
4. Sorry, Wrong Number(s)
There’s another type of risk that is exacerbated by Dirty Data – reputational risk. If your swollen headcount and excess hours spent on reporting still can’t scrub away all of your corrupt data – there’s a good chance that data will trickle all the way down to the investor. And investors aren’t keen on receiving incomplete and/or wrong data. And you know who else isn’t keen on bad data? The government.
So, how do you solve a problem like Dirty Data?
It depends on your current data strategy, as well as the sources of your data. In general, preventing Dirty Data involves establishing a single source of truth, eliminating siloed process, and integrating disparate software systems.
The team at Saxony Partners can help you solve your issues around data integrity. Lack a data governance strategy? Our consulting team can help you create and establish one. Dealing with unwieldy processes and unintegrated software? We can provide customized solutions to streamline the way you do business.
Interested in a plan for eliminating and preventing Dirty Data? Reach out to the Saxony consulting team for a chat.
For more on different types of Dirty Data, read Kirbie Pillette’s post, Don't Be Caught With Dirty Data!. Propmodo’s post on data transparency also includes information on how dirty and siloed data can impact market efficiency.