Summary
This report provides a weekly overview of operational performance by tracking AWBs, execution status, pending workload, customer issues (CAMS), and closure rates. Using simple metrics, filters by station and date, and clear percentage changes, it helps teams quickly identify performance trends, growth areas, and operational risks to support timely and data-driven decisions.
Filters
| Filter
|
Description
|
| Station
|
Filters the report to show data for a specific operational station
|
| Status
|
Filters records based on issue resolution status:
Resolved (issues that have been closed) and Unresolved (issues still open and pending action).
|
| Date
|
Filters the data to a selected date range for time-based analysis
|
Data Transformation Applied
| Query
|
Transformations
|
| 1. EY Performance Report
|
Cleaned the dataset by correcting column data types (dates, numbers, text) to ensure accurate calculations and filtering.
|
| 2.Pending AWBs
|
Standardized data types and prepared the table for relationship mapping with Stations.
|
| 3.Reopened AWBs
|
Corrected data types and validated station identifiers for consistent joins.
|
| 4.Stations
|
Used as a master reference table to provide station details for all operational datasets.
|
| 5.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
|
