Close

Trip Disruption & Change Dashboard

Trip Disruption & Change Dashboard analyzes air travel disruptions and changes, highlighting their financial impact, recovery rates, and key reasons behind modifications. It provides a breakdown of costs, recovered credits, and change drivers, with detailed traveler-level reporting to help organizations minimize disruption costs and improve travel policies.

Client: Cornerstone Information Systems, Inc. Date: 12-2025 Services: Data Science, Design, UI/UX.

Trip Disruption & Change dashboard showing air travel focus. KPIs include: 100% trips with changes (15 of 15 bookings), $254 average cost per change, $3,805 total financial impact, and Sarah as top traveler with 2 changes. Filters for date range, department, change type, reason, status, traveler, and airline. A pie chart displays average change cost by type: cancellations $207, schedule changes $158, ticket exchanges $431. A bar chart shows top change reasons, led by business changes and airline schedule adjustments. Additional metrics include $1,450 total lost spend, $18,600 recovered credits, and 92.8% net recovery rate.

Trip Disruption & Change dashboard with detailed table of air travel disruptions and changes. Table columns include traveler, department, destination, change type, change reason, original date, new date, change fee, fare difference, total impact, airline, and status. Rows include examples: Sarah Johnson (Sales) – schedule change London via British Airways, Michael Chen (Engineering) – cancellation Tokyo via United Airlines, Emily Rodriguez (Marketing) – ticket exchange São Paulo via American Airlines. Status indicators show processed or pending.