Agoda Senior Data Analyst interview questions

Below was the Case Study I received: Most of the time, the primary goal of launching a new feature on Agoda website is to increase the number of bookings. One way to increase the number of bookings and conversion rate is to encourage users to complete their bookings as fast as possible. The call-to-action message that helps us achieve that is internally known as an ‘urgency message’. Examples of urgency messages are: * “Prices have been rising. Book now to lock in your rates!” * “Your check-in is fast approaching. Book now to lock in your rates!” For this case imagine you will be presenting to two people: one is our head of analytics who is most interested in the math, and one is our head of strategy who is most interested in how your proposal will be implemented and end up being successful. Ensure your presentation addresses both. The team would like to understand the movement of the price as booking date approaches check-in date and hear your suggestion on business opportunity. Attached is a randomly sampled booking data from five different cities with check-in between 10/10/2016 – 12/31/2016. Please analyze the data and prepare a presentation in any format of preference (i.e. PowerPoint, keynote, or pdf). You will have about 30 minutes to present your findings and proposal to the management as well as answering any questions they may have. Our management team is highly analytical and data driven hence you should include any detailed analysis or data findings you have done for this project.