Datacair EY Performance Report - Detail

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
TBC	TBC	TBC