Power BI Dashboard Development – Supply Chain & Vendor Replenishment

Project Overview We are looking for an experienced Power BI developer to build a modern, interactive dashboard for our supply chain consulting business, Zenith Supply Chain Solutions (Australia). Our business specializes in Vendor Replenishment Planning (VRP). The dashboard will be used by supply chain planners, account managers and business leaders to monitor inventory performance, service levels and working capital. This project has the potential to lead to ongoing dashboard development and reporting work. Scope of Work The successful freelancer will: * Design a clean, executive-level Power BI dashboard. * Connect multiple Excel data sources. * Build a robust data model. * Perform data transformation using Power Query. * Create efficient DAX measures. * Develop interactive reports with drill-down capability. * Optimize dashboard performance. * Deliver a well-documented Power BI (.pbix) file. Dashboard Pages 1. Executive Dashboard High-level KPI summary including: * DIF / DIFOT * Service Level * Weeks Cover * Working Capital * Inventory Value * Out of Stocks * Rationed SKUs * Inventory Health Score * Supply Chain Health Score 1. DIF / DIFOT Performance * DIF Trend * DIFOT Trend * Cases Ordered vs Supplied * Lost Sales * Fill Rate * Top Performing SKUs * Lowest Performing SKUs * Performance by Distribution Centre 1. Rationing Dashboard * Number of Rationed SKUs * Rationed Orders * Lost Sales * Cases Lost * Duration of Rationing * Rationing Trend * Products Under Rationing * Distribution Centre Analysis 1. Inventory & Weeks Cover * Average Weeks Cover * Days Cover * Understocked SKUs * Overstocked SKUs * Slow Moving Inventory * Inventory Value 1. Working Capital Dashboard * Inventory Value * Working Capital * Excess Inventory * Working Capital Trend * Capital by Supplier 1. Service Level Dashboard * Service Level % * Fill Rate * Case Fill * Perfect Orders * Service Trend * Supplier Performance 1. Action Centre A priority table highlighting: * Critical Stock Risks * Low Weeks Cover * High Weeks Cover * Rationed Products * Poor Service Levels * Recommended Actions Required Skills * Microsoft Power BI * Power Query * DAX * Data Modelling * Excel * Dashboard Design * Strong understanding of KPI reporting and data visualization Highly Desirable Experience with: * Supply Chain * Inventory Management * Demand Planning * Vendor Replenishment * Logistics * Business Intelligence Reporting Deliverables * Fully functional Power BI dashboard (.pbix) * Source files * DAX measures * Power Query transformations * Documentation explaining the data model * Dashboard user guide * One round of revisions after testing