Fleet Performance Analysis with Excel

Link to code: https://github.com/Chauloroches/Fleet_Performance_Analysis_Excel

Analyze fleet performance data to identify cost optimization opportunities, assess vehicle utilization, and improve overall efficiency in the transportation industry.

File used was:

Fleet_performance_analysis.csv

Cleaning Data:

1. Remove duplicates

2. Format date to YYYY/MM/DD

3. Check for blank null cells

4. Reduce numerical columns to 2 decimal places

5. Check for outliers

Perform Analysis:

Added 3 columns:

1. Fuel_Efficiency = Distance_Travellled(Km)/Consumed(L)

2. Revenue_per_Trip = Revenue(USD)/Distance_Travellled(Km)

3. Maintenance_cost_per_Km = Maintence_Cost(USD)/Distance_Travelled(Km)

Pivot Table:

Sum of Revenue by Region

Rank vehicles by total revenue

Visualize Insights:

Revenue by Region - Pie Chart

Maintenance Cost Over Time - Line Chart

Fuel Efficiency vs Distance - Scatter Plot

Building Dashboard

Build a dashboard including Slicers, Timeline, and KPIs

Insights :

1. Revenue pick-ups is in January

2. The west region has the highest revenue

3. Ethan is the driver with the highest revenue per trip

4. Vehicle V9756 is the most profitable

Recommendation:

1. Increase operations in the West Region to capitalize on the revenue potential.

2. Assign vehicles with better fuel efficiency to longer routes.

3. Ensure maximum fleet availability during January to handle increased demand