This Excel-based dashboard was created to explore and visualize key supply chain KPIs. While the data is synthetic, the metrics and layout reflect real-world logistics reporting — from carrier performance to sales trends.
Beyond showcasing my Excel and dashboarding skills, this project highlights how my background in logistics shapes how I interpret and communicate operational data.
With over 10 years of experience in container ship planning and a few years in automotive logistics, I’ve seen firsthand the challenges of tracking and interpreting performance data. Many reports I worked with were dense and hard to translate into action.
I built this dashboard as a clear and actionable way to monitor supply chain performance — blending what I’ve learned from my career with my current studies in data analytics and business intelligence through the Google BI Analyst course.
This project helped me practice:
- Pulling actionable insights from operational data
- Presenting findings in a clean, user-friendly dashboard
- Thinking like a logistics manager or operations lead
- Microsoft Excel — primary tool for the dashboard
- PivotTables & Charts — for data summarization and visualization
- Interactive Slicers — for filtering by customer, product, and region
- Conditional Formatting — highlights trends and exceptions (e.g., Top 5 customers, days with lowest revenue)
- Total Revenue (overall and by region)
- Units Ordered
- Average Delivery Time (Days)
- On-Time Delivery %
- Most Shipped Product Category
- Data cleaning and preparation
- Dashboard design focused on business users
- Building dynamic, interactive reports
- Communicating insights clearly through layout and visuals
Craig_Supply_Chain_Dashboard.xlsx
├─ Data (raw input & calculated fields)
├─ KPI (aggregated metrics & pivots)
└─ Dashboard (final visuals, charts & summary)
- Rebuild in Power BI for live filtering and enhanced scalability
- Expand dataset to 1,000+ records for scalability and performance testing
All data used in this project is synthetic and created for educational purposes only.