The provided CSV file contains logistics data from Delhivery, a logistics and supply chain company in India. The data includes various details about trips, routes, and delivery performance. Here’s a breakdown of the key columns and their potential use for analysis:

Dataset is available here : https://www.kaggle.com/datasets/devarajv88/delhivery-logistics-dataset

Key Columns:

1. data: Indicates whether the data is for training or testing purposes.
2. trip_creation_time: The timestamp when the trip was created.
3. route_schedule_uuid: A unique identifier for the route schedule.
4. route_type: The type of route (e.g., Carting, FTL).
5. trip_uuid: A unique identifier for the trip.
6. source_center: The source center code.
7. source_name: The name of the source center.
8. destination_center: The destination center code.
9. destination_name: The name of the destination center.
10. od_start_time: The start time of the origin-destination trip.
11. od_end_time: The end time of the origin-destination trip.
12. start_scan_to_end_scan: The duration (in minutes) from the start scan to the end scan.
13. is_cutoff: Indicates whether the trip was cut off (True/False).
14. cutoff_factor: A factor related to the cutoff.
15. cutoff_timestamp: The timestamp when the cutoff occurred.
16. actual_distance_to_destination: The actual distance to the destination.
17. actual_time: The actual time taken for the trip.
18. osrm_time: The time calculated by the Open Source Routing Machine (OSRM).
19. osrm_distance: The distance calculated by OSRM.
20. factor: A factor related to the trip.
21. segment_actual_time: The actual time taken for a segment of the trip.
22. segment_osrm_time: The OSRM-calculated time for a segment.
23. segment_osrm_distance: The OSRM-calculated distance for a segment.
24. segment_factor: A factor related to the segment.

Delayed Shipments (%) = 
DIVIDE(
    COUNTROWS(FILTER(delhivery, delhivery[is_cutoff] = FALSE)),
    [Total Shipments],
    0
) * 100
On-Time Deliveries (%) = 
DIVIDE(
    COUNTROWS(FILTER(delhivery, delhivery[is_cutoff] = TRUE)),
    [Total Shipments],
    0
) * 100