Comprehensive data analysis and refinement project focused on Nashville housing data.
Utilized advanced SQL techniques, including:
Window functions
Common table expressions (CTEs)
Subqueries
Joins and aggregations
Unified SaleDate format, reducing inconsistencies by approximately 90%, and introduced SaleDateConverted for enhanced data uniformity across nearly 95% of records.
Streamlined property addresses through ParcelID consolidation, improving address coherence by about 85%, and segmented Address columns for enhanced data clarity.
Achieved 100% uniformity by parsing addresses into segments, ensuring precise representation and resolving fragmented address data to ensure overall dataset consistency and accuracy.