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.
What I built
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.
How it works
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.
Result
10 raw tables modelled into a 14 relationship star schema with 18+ DAX measures
"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."