Tenants Review

Tenants Table Structure

Column Data Type Description
tenant_id number unique id assigned to each tenant record
company_name string name of the tenant's company
industry string categorical description of the industry of the tenant's company
num_employees number number of employees at the tenant's company

Tenants Data Profiling

1. Row Level & Structure Checks

  • 61 total tenant records.

Null / Blanks summary

1
2
3
4
No Results

2. Primary key uniqueness validation

Uniqueness of primary key

61 total property records with 60 unique tenant_id values.

3. Foreign key integrity checks

No foreign keys in tenants table

Data Consistency Checks

4. Date Field Validation

No date fields in tenants table

5. Numeric Field Validation

1
No Results

num_employees

Loading...

6. Text Field Validation

1
2
No Results
1
2
3
4
5
6
7
8
9
No Results

industry

No Results

Business Logic & Reasonableness Check

7. Logical Checks

Logical Duplicates

2 records for company_name harrell llc

2 records for company_name jones inc

Harrell LLC

No Results

Jones LLC

No Results

8. Reasonableness Checks

extremely large companies

Loading...

industry alignment with property_type

No Results