The Census Bureau's vacancy rate is the gold standard, but it is published annually and lags reality. USPS publishes vacancy counts quarterly for every ZIP code. Can the faster source stand in for the slower one?
Knowing which neighborhoods have rising vacancy is core to how a local economic development office decides where to invest. The Census estimate is the gold standard but comes out once a year and can lag reality. USPS already tracks which addresses stop receiving mail, every quarter, for free. If it reliably tracked the Census number, it would be a much faster early-warning signal between official releases.
The U.S. Postal Service publishes a vacancy count for every ZIP code in the country, every quarter. This project asks whether that data is good enough to stand in for the Census Bureau's official, but slow and annual, vacancy rate, and answers it with a live Microsoft Fabric and Power BI pipeline instead of a guess.
It tests the idea against six real U.S. counties and 14 years of government data (2010–2024 without 2020, 84 county-year observations) and gives a three-part answer: do the sources move together, does USPS call the direction of change correctly, and how far off is it on average.
Every headline number is reproducible from the 84-row comparison table in the repository with plain arithmetic, and the Power Query M and report definition are exported from the real Fabric workspace rather than described from memory.