Restaurant Financial Controls & Operational Analytics Project
Build an analytics workflow by consolidating POS exports, bank statements, vendor records, and payroll data into Excel datasets, enabling revenue, cost, and cash-flow analysis through a repeatable Excel-to-CSV-to-MySQL pipeline Design MySQL tables and SQL queries using SELECT, GROUP BY, JOIN, and aggregation logic to analyze sales, expenses, and vendor activity, preparing structured datasets for Power BI dashboards and anomaly detection Identify a labor efficiency ratio of 48%, exceeding typical restaurant benchmarks, and surface a 15–20% menu price increase opportunity by benchmarking current pricing against market rates and portion analysis

