Vacancy History Review

vacancy_history Table Structure

vacancy_history Data Profiling

1. Row Level Checks

Total number of vacancy_history records

• 2,150 from vacancy_history records.

Null / Blanks summary

2. Primary Key Uniqueness Validation

Uniqueness of primary key

• No real primary key
  • records are uniquely identified by composite primary key made up of columns property_id, month and vacancy_rate

Duplicate property-month composite values have different vacancy rates

• indicates that all 3 columns are required to uniquely identify a record

3. Foreign key integrity checks

property_id check against properties.csv

Data Consistency Checks

4. Date Field Validation

Earliest & Latest date values

vacancy_history

Check for future months

0 vacancy_history records with future month

Earliest & Latest month for each property_id

5. Numeric Field Validation

vacancy_rate

6. Text Field Profiling

No text fields

Business Logic & Reasonableness Check

7. Logical Checks

• 0% records with vacancy_rate greater than 100%
• 0% records with vacancy_rate less than 0%

8. Reasonableness Checks

see interactive chart above for vacancy_history trend as leases become active