Help Build a Supply Chain Dashboard in Power BI (3-Day Timeline)

Help Build a Supply Chain Dashboard in Power BI (3-Day Timeline)

Objective:
Need hands-on help to build a Supply Chain Management Dashboard in Power BI using KPIs and insights derived from a PostgreSQL database. The dashboard should be functional, optimized, and ready within 3 days.

⸻

Tasks Involved:
1. Connect Power BI to PostgreSQL DB
• Data resides in a PostgreSQL database
• Help with setting up efficient queries and data import
2. Data Modeling
• Design and optimize a star-schema model suitable for supply chain analytics
• Use DAX and Power Query M language for data transformation and calculated columns/measures
3. Build Key KPIs & Visuals (examples may include):
• Inventory Turnover Ratio
• Days of Supply
• Stockout %
• Supplier Lead Time
• Fulfillment Rate
• Order Cycle Time
• Inbound vs Outbound Volumes
• Top Delayed SKUs or Shipments
4. Dashboard Layout
• Clean, executive-friendly design
• Separate views for: Warehouse Ops, Supplier Performance, Order Flow, and Inventory Overview

⸻

Timeline:

Complete within 3 working days. Must be responsive and available for quick syncs during development.

⸻

Skills Needed:
• Power BI (Advanced)
• DAX & M Language (Power Query)
• PostgreSQL (Intermediate – for writing and optimizing queries)
• Supply Chain domain understanding (Preferred)