Comprehensive F&B Power BI Dashboard

Our F&B startup wants a single, interactive Power BI workspace that brings together three streams of information—store sales, inventory, and people data—so our C-level team can spot issues and opportunities at a glance.

Data landscape
• All raw numbers now sit in source systems, Google-based sheets; there is a cloud-based POS and HR systems. Should a CSV, direct POS, SQL connections, and Google Analytics be required, the model must allow an easy switch without a full rebuild.

Core sales & operations insights
The finished report should expose, in real time:
• Total sales and revenue
• Sales per product category
• Daily transactions & customer count
• Profit & Loss
• Same-Store Sales Growth %
• Speed of Service %
• Customer review ratings (/5★)
• Flash People Digest
• Marketing total transactions (#)
• Marketing customer lifetime value (RM)

Critical HR lenses
• Employee turnover rate
• Attendance and leave records

Technical expectations
Power Query for clean ETL, well-documented DAX measures, a star-schema data model, role-level security for store managers vs. executives, and responsive layout that works on both desktop and the Power BI mobile app.

Deliverables
1. PBIX file with all queries, model, and visuals
2. One slicer-driven executive dashboard page, plus drill-through pages for Sales, Operations, Marketing, and HR
3. Data refresh gateway instructions (or scheduled Cloud refresh via OneDrive/SharePoint)
4. Loom or Teams walkthrough video (≈15 min) and concise hand-over notes

Acceptance criteria
• All metrics above calculate correctly for any date range filter
• Refresh completes without error on the agreed schedule
• CPU and memory footprints stay within standard Pro workspace limits (no Premium needed for now)
• Executives can load the report on mobile and reach each KPI in ≤3 taps

If you have recent experience marrying Google Sheets with Power BI and can build a robust yet extensible model, this assignment should be straightforward and rewarding.