Cleaning and Preparing Expedition's Final Daily Report

Cleaning and preparing an expedition's final daily report.

The administrator provides raw outbound consignment data containing customer name, pickup date, delivery time, receiver, and invoice number.

The data analyst must cleanse, normalize, and enrich records by deriving and appending fields such as ship departure time, load and reload durations, delivery due dates, AWB receipt status, and other operational attributes.

Deliver a consistent, validated dataset ready for reporting, with documented transformations and anomaly notes.