Order Distribution & LT Analysis

I need someone to help with two tasks using my Excel/CSV files.

1. Order Distribution Scatter Plot:
- Visualize order distribution.
- Scatter plot by due date.
- Parameters:
- Include all data points.
- Highlight specific date ranges.
- Use different colors for various categories.

2. Lead Time (LT) Analysis:
- Analyze last 6 months of data.
- Key metrics:
- Average lead time.
- Lead time variability.
- Lead time trends over time.

Ideal Skills & Experience:
- Proficiency in Excel/CSV and data visualization tools.
- Strong analytical skills for lead time metrics.
- Attention to detail for accurate representation.