An end-to-end data project using real LAPD NIBRS crime data from 2024–2025. The goal was to build a proper SQL pipeline — cleaning, schema design, loading, views — and connect it to a Power BI ...
WHEN DATEDIFF(DAY, Invoice_Date, GETDATE()) <= 30 THEN '0-30 Days' WHEN DATEDIFF(DAY, Invoice_Date, GETDATE()) <= 60 THEN '31-60 Days' WHEN DATEDIFF(DAY, Invoice_Date ...