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.