Design a Executive Unit Economics & Commercial Profitability Dashboard

We operate a specialty commodity wholesale distribution business and need an experienced developer to transform our Q1 transactional data into an interactive, high-performance Unit Economics & Margin Performance Dashboard. We want a clean, responsive, executive-facing dashboard that gives our leadership team instant visibility into our per-unit profitability, product tier contribution margins, and client order velocity—without clunky enterprise software overhead. Key Requirements & Scope of Work • Transform data from platforms like shopify, amazon, meta ads into single view. • Calculate and display core unit economics: Total Revenue, Product Costs, Gross Profit, and Gross Margin %. • Build an executive overview with high-level KPI cards and weekly performance trend charts with switchable metrics. • Include a product-level profitability breakdown comparing selling prices, costs, and margins across all product tiers. • Provide a client accounts view displaying order frequency, revenue concentration, and customer activity. • Track supply logistics and fulfillment operations, including total volume shipped and batch status. • Add an interactive orders ledger featuring instant search, status filtering, and one-click CSV export. • Deliver a modern, minimalist design aesthetic. • Ensure the dashboard is fully responsive on desktop and tablet, and runs smoothly in any standard web browser without complex setup. Deliverables • A fully functional, interactive dashboard viewable directly in any web browser. • 100% verified mathematical parity matching our raw Excel numbers (total revenue: ₹9.34L, gross margin: 63.7%).