Operations Dashboard & Report Creation

I need a savvy Excel professional to turn our raw operational data into an insightful business-operations report and an easy-to-read dashboard. The goal is to give senior management a clear view of day-to-day performance at a glance. Scope • Import and clean the data I will supply (orders, inventory, fulfilment, and service KPIs). • Build dynamic PivotTables and charts that allow quick filtering by date, product line, or region. • Design an uncluttered dashboard that highlights trends, exceptions, and key metrics such as on-time delivery, stock turns, and cost per order. • Summarise the main findings in a concise PowerPoint slide (optional but appreciated). What I’m looking for Accuracy, attention to detail, and solid experience creating reports and dashboards in Microsoft Excel. VBA isn’t required, but if you genuinely know it, feel free to suggest automation ideas. When you apply, please focus on your Kinh nghiệm—examples of similar dashboards, industries you’ve reported on, and any measurable results you helped achieve. A short outline of how you would approach the data will help me understand your style. Timeline & format Once we agree on the structure, I’d like the first draft within a week, followed by one round of refinements. Final files should be delivered in .xlsx (no external add-ins) and .pptx for the summary slide. I’m open to extending this into recurring work if we work well together, so show me what you can do!