I love good data. Taking huge chunks of information and trying to distill trends, patterns and links has always been interesting to me. And so I find myself wondering this afternoon just what to do with a massive batch of data related to airline award searches. See, for about the past year (probably longer, actually) I’ve had a tool available online to allow people to search for awards on Star Alliance carriers. And those searches each return some collection of data. Over time the data collected added up and I now realize that I have more than 5 million rows of search results available.
And now I cannot help but wonder what I should do with it. Also, I’m not entirely sure I know how to tease the data out into something useful.
Are there trends in when seats are released or booked? Are certain months or routes really more likely to have seats available? More likely to be searched on?
What else? What types of information do you want me to try to pull out of the data?
No promises, as I’m not entirely sure I know where to begin with the analysis, but I’m definitely willing to give it a shot if anyone has a suggestion of something that seems like a useful query to run.
Never miss another post: Sign up for email alerts and get only the content you want direct to your inbox.