This Looker dashboard aims to analyze the performance of purchase orders from 2019 to 2023 and provide insights into order costs across different stages (completed, shipped, and processing) and locations.
The interactive dashboard allows users to:
1. Visualize order cost trends: Utilize an area chart to visualize order costs across the selected date range, helping to identify periods of high or low spending
2. Analyze geographic distribution: Explore a geo map displaying the cost of shipped orders arriving at US Distribution Centers. This enables users to identify regional trends and potential cost variations
3. Monitor order costs: Utilize a scorecard to quickly monitor the total cost of completed, shipped, and processing orders
These findings can be used to:
1. Identify areas for process optimization to reduce processing times and associated costs
2. Optimize resource allocation: Allocate resources strategically based on regional cost variations and order completion rates
3. Utilize cost data to leverage negotiation power with suppliers