Summary
This table presents a weekly snapshot of cargo operations performance, displaying Current Week, Previous Week, and Week-over-Week (WoW) changes for key metrics including AWBs, Executed AWBs, Pending AWBs, CAMS Raised, Completion Rate (CR), and Completion Rate (CR-EY).
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
|
| 1. Total AWBs
|
Sum of all AWBs
|
Total number of Air Waybills created in the selected period
|
| 2. Total Executed AWBs
|
Sum of executed AWBs
|
Number of AWBs that were successfully processed or completed
|
| 3.Total Pending AWBs
|
Sum of pending AWBs
|
Number of AWBs still awaiting execution
|
| 4.Total CAMS Raised
|
Sum of CAMS cases
|
Total number of customer or operational issues raised
|
| 5.Total CR
|
Average of Completion Rate
|
Overall closure rate showing operational efficiency
|
| 6.Total CR (EY)
|
Average of Completion Rate EY Fault Removed
|
Closure rate based on EY-specific business rules
|
