Power BI dashboard for a national retail chain

Our regional managers currently receive eleven separate spreadsheets every Monday. We want one Power BI dashboard that answers the questions they actually ask. What we need: • Ingest sales, stock and staffing exports from 42 stores (CSV drops to SharePoint) • A star-schema data model — the current flat tables cannot support the slicers we need • Executive page: revenue vs target, like-for-like growth, top and bottom ten stores • Regional drill-down by province and store cluster • Stock-out alerting with a threshold our ops team can adjust themselves • Scheduled weekly refresh plus documentation so we can maintain it Experience with retail data and DAX is essential. We will provide six months of historical exports up front.