Case Study: British Airways calculates median ratings and benchmark values with Gigasheet

British Airways calculates median in 3 steps with Gigasheet

British Airways needed to calculate median star ratings from passenger reviews grouped by categories like country and seat type. This was a challenge because Microsoft Excel pivot tables, their go-to analysis tool, do not natively support median calculations, forcing them to use a complex and fragile formula workaround. To perform this analysis easily, they used Gigasheet, the big data spreadsheet platform.

Gigasheet provided a straightforward solution, allowing British Airways to upload their data and group it with just a few clicks. The vendor's platform enabled them to instantly calculate the median for any group without complex formulas or pivot table setups. This resulted in a faster, more reliable analytical process and empowered the airline to perform more complex analyses, such as viewing medians by both country and seat class simultaneously, which would have been impractical with their previous Excel method.

British Airways