Restaurant Analytics
End-to-end Power BI business intelligence solution for a multi-branch restaurant. Wrote SQL against the client's live sales database to extract per-shop data, exported to CSV for modelling, then audited and cleaned 10 raw tables into a star-schema model with 14 relationships. Features 18+ DAX measures, a custom punctuality KPI comparing rostered shift starts against clock-in times, and a What-If wage-cost model. Client data and visuals are confidential at the client's request.
Core Features
Data Quality Audit
Profiled all 10 files for row counts, duplicate keys, referential integrity, and logic checks before building.
Power Query & Transformation
Removed irrelevant columns, standardized formats, and built derived columns.
Data Modeling
Built a strictly directional 1-to-Many Star Schema with a central DimDate and 14 single-direction relationships.
DAX Engineering (18+ Measures)
Authored base measures, time intelligence, a punctuality KPI, and a dynamic What-If wage slider.
Data Privacy & Anonymization
Client data and visuals are confidential at the client's request.
Technical Deep Dive
Data Quality Audit & Power Query
Profiled all 10 files for row counts, duplicate keys, and referential integrity. Removed irrelevant columns to shrink model size, promoted headers, and standardized date/time formats.
Data Modeling (Star Schema)
Built a strictly directional 1-to-Many Star Schema. Created a central `DimDate` table using DAX `CALENDARAUTO()` for time-intelligence. Connected dimensions to facts with 14 established relationships, all single-direction filtering down to the facts to ensure performance and avoid ambiguity.
DAX Engineering & What-If Parameters
Authored 18+ DAX measures, including a punctuality KPI engineered from scratch to compare scheduled shift starts against actual clock-in times. Built a What-If wage-cost model letting owners test the profit impact of pay-rate changes before committing to them.
Confidentiality
Client data and visuals are confidential at the client's request.
Performance Benchmark
"Built an end-to-end Power BI solution for a multi-branch restaurant, transforming 10 raw operational CSVs into a robust star-schema data model with 14 relationships and 18+ DAX measures. Client data and visuals are confidential at the client's request."