Most aviation analysis is written by people who have read about the operation. I have worked it.
An airline gets thousands of survey responses and still can't answer the only question that matters: which part of the operation is costing us the score?
This dashboard makes that answerable in one click. Filter by flight number, cabin, gate, agent, aircraft type or issue category, and watch sentiment move against the operational facts behind it — delays, service touchpoints, check-in performance.
Everyone in operations knows bird strikes feel seasonal. This tested whether the pattern is real — and it is. Summer and fall carry significantly more strikes, at p < 0.001.
That turns a hunch into a staffing and mitigation schedule. If risk concentrates in two seasons, wildlife management and crew briefings should too.
Half a million sales records, one question: what should a dealership actually put on the lot?
Cleaning was most of the work — body type names standardised, sale dates parsed, mileage binned into ranges a buyer would recognise. What came out was a clear inventory and marketing signal.
The standard airline survey fires once, by email, after arrival, and asks for a 1–10 score and a wall of text. Passengers only remember the extremes.
So the data comes back with the middle of the journey missing. You learn the flight was bad. You don't learn it was the gate change, the bag drop queue, or the boarding call nobody heard.
The fix: replace one long survey with micro-surveys at each touchpoint — two questions and an optional comment, delivered where the moment actually happened.
Data cleaning · analysis · visualization · reporting