October challenge board
Dirty Data Lab™ · Challenge 07
Hard
Thursday, October 22 · 25–30 minutesProperty Roster Audit
A property roster has duplicate leases, inconsistent units, messy rent strings and ended leases mixed into active occupancy.
The assignment
Cleanup rules
There is one finished state. Use the rules to get the board there.
- Normalize lease_id, property, unit, tenant name and tenant email.
- Normalize move_in to YYYY-MM-DD and monthly_rent to a decimal amount.
- Normalize status to Active or Ended.
- Remove duplicate lease_id records after trimming.
- Sort by property then unit.
- Calculate Active lease count and total Active monthly rent.
Loading the puzzle board…
Loading your Lab profile…
Pass the puzzle
Send this one to a friend.
The friend link carries Dirty Data Lab™ referral attribution, so referred signups can be measured separately from newsletter and ad traffic.
Take the habit into Google Sheets
Practice here. Preflight real sheets with CTS Guard.
Clean That Sheet Guard checks the active Google Sheet for duplicates, missing data, formatting issues and other handoff problems before you share or import it.