ANALYZING REAL ESTATE TRANSACTIONS
This presentation is the property of its rightful owner.
Sponsored Links
1 / 19

A presentation by W H Inmon PowerPoint PPT Presentation


  • 67 Views
  • Uploaded on
  • Presentation posted in: General

ANALYZING REAL ESTATE TRANSACTIONS. A presentation by W H Inmon. There’s a lot going on in real estate today. And there’s a pot of gold to be made by understanding the marketplace. The secret to understanding the market place is understanding transactions. Sales Financial transactions

Download Presentation

A presentation by W H Inmon

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


A presentation by w h inmon

ANALYZING REAL ESTATE TRANSACTIONS

A presentation by

W H Inmon


A presentation by w h inmon

There’s a lot going on in real estate today


A presentation by w h inmon

And there’s a pot of gold to be made by understanding the

marketplace


A presentation by w h inmon

The secret to understanding the market place is understanding

transactions

Sales

Financial transactions

Loans, loan rates

Consumers


A presentation by w h inmon

Recording by county of a deed of trust


A presentation by w h inmon

County recording of a loan


A presentation by w h inmon

Inline contextualization

Taxonomy/ontology

resolution

Custom variable formatting

The three primary types of transformations done

In order to turn raw text into a standard data base


A presentation by w h inmon

textual

ETL

unstructured

data

taxonomy

Standard

data base

real estate

transactions

Oracle

DB2

Hadoop

SQL Server

Teradata

Netezza

visualization

50,000,000,000 records

Tableau

SAS

Qlikview

Cognos

Excel

Many others

The general architecture


A presentation by w h inmon

The output is a

data base

in a normalized

structure


A presentation by w h inmon

Record id

Context descriptor

Value of interest


A presentation by w h inmon

recorder

residence

lien filed

city state


A presentation by w h inmon

recorder

residence

lien filed

city state


A presentation by w h inmon

Query -

Find all sales in Arizona for month of May

Find all commercial sales less than $500,000 for 1st quarter

Find all loans granted in June where rate is less than 3.75%

You are only limited by your imagination


A presentation by w h inmon

textual

ETL

unstructured

data

taxonomy

customer

response

visualization

statistical

analysis

Tableau

Once you have your data in a data base and in a relational

structure, you can analyze it any way you want


A presentation by w h inmon

textual

ETL

unstructured

data

taxonomy

With a data base in a normalized

structure, you can ask all sorts of

questions -

Real estate

transactions

How many sales were made in Arizona this month?

How many sales were between $250,000 and $1,000,000?

How many commercial sales were there?

What is the loan to equity ratio?

And many, many more questions


A presentation by w h inmon

textual

ETL

unstructured

data

unstructured

data

taxonomy

Two approaches to

doing the same thing

automated

manual

manually


A presentation by w h inmon

Textual

ETL

Cheap

Fast

Accurate

automated

Expensive

Slow

Error prone

manual


A presentation by w h inmon

textual

ETL

unstructured

data

taxonomy

visualization

statistical

analysis

Tableau

Now you can go from textual data to

meaningful analysis


A presentation by w h inmon

textual

ETL

unstructured

data

taxonomy

visualization

Now you are set for the

“AHA” moment!!


  • Login