City Food Inspections Analysis – Dallas & Chicago

Tech Stack: Power BI, Alteryx, Snowflake, ADF, Databricks, SQL, Power Query

Processed 500K+ records using backend SQL and Power Query optimizing data ingestion, improving data quality and readiness for compliance reporting and reliable downstream analysis
Crafted a Snowflake data warehouse using the 3-level medallion architecture, transforming raw to refined tables with Databricks and ADF; modelled dimensional schemas and populated 7+ fact/dimension tables for analytics
Designed multi-page UX Power BI dashboards integrating 11+ compliance KPIs, inspection metrics, and heatmaps; implemented 25 DAX formulas for calculated measures, table-to-table relationships for dynamic filtering, and slicers for interactive stakeholder exploration