Datacair EY Performance Report - Airway Bills

Summary

This table provides an overview of Air Waybill (AWB) status by highlighting pending and reopened AWBs along with their raised and resolved dates. It helps teams track outstanding issues, monitor resolution timelines, and identify delays in the AWB handling process to support timely follow-up and operational efficiency.

Filters

Filter	Description
Station	Filters the report to show data for a specific cargo station or location. Helps compare performance across stations
Date	Filters data by selected date range to analyze performance for a specific period (week, month, or custom range).

Data Transformation Applied

Query	Transformations
EY Performance Report	Cleaned the dataset by correcting column data types (dates, numbers, text) to ensure accurate calculations and filtering.
Pending AWBs	Standardized data types and prepared the table for relationship mapping with Stations.
Reopened AWBs	Corrected data types and validated station identifiers for consistent joins.
Stations	Used as a master reference table to provide station details for all operational datasets.
Calendar	Created and linked to date fields to support time-based analysis (weekly and monthly trends).

Calculations

Columns	Calculation	Description
TBC	TBC	TBC