The dataset represents freight operations and includes details such as truck IDs, driver IDs, shipment dates, distances traveled (KM Traveled), fuel consumption (Liters), fuel costs, fixed costs, and maintenance costs.
It provides insights into transportation efficiency, cost management, and operational performance for trucks and drivers.
Tools and Techniques Used Microsoft Excel:
Power Query: Cleaned and prepared the data for analysis.
Established relationships between different tables to create a unified data model.
Performed calculations within Power Pivot for advanced metrics.
Built Pivot Tables for in-depth data analysis.
Created reports and visualizations to showcase efficiency and cost trends.