Analyzing 2.7M U.S. flood-insurance claims with SQL
A case study using FEMA's public NFIP claims data: loading 2.7 million records into SQL Server, then using window functions and conditional aggregation to map where losses concentrate, how they trend, and where the data itself will mislead you if you don't profile it first.
Read the full breakdown →