Suppose that you are working as a data analyst at Airbnb. For the past few months, Airbnb has seen a major decline in revenue. Now that the restrictions have started lifting and people have started to travel more, Airbnb wants to make sure that it is fully prepared for this change.

The different leaders at Airbnb want to understand some important insights based on various attributes in the dataset so as to increase the revenue such as - Which type of hosts to acquire more and where? The categorisation of customers based on their preferences. What are the neighbourhoods they need to target? What is the pricing ranges preferred by customers? The various kinds of properties that exist w.r.t. customer preferences. Adjustments in the existing properties to make it more customer-oriented. What are the most popular localities and properties in New York currently? How to get unpopular properties more traction? and so on... Note: These points are just to give you an initial understanding of how to proceed with the analysis and the kind of questions you need to ask. In addition to this, you would need to further understand the data (attached below in this page) and analyse important insights that you feel are required for the audiences mentioned for each of the two presentations.

To prepare for the next best steps that Airbnb needs to take as a business, you have been asked to analyse a dataset consisting of various Airbnb listings in New York. Based on this analysis, you need to give two presentations to the following groups.

Data Analysis Managers: These people manage the data analysts directly for processes and their technical expertise is basic. Lead Data Analyst: The lead data analyst looks after the entire team of data and business analysts and is technically sound.

Head of Acquisitions and Operations, NYC: This head looks after all the property and host acquisitions and operations. Acquisition of the best properties, price negotiation, and negotiating the services the properties offer falls under the purview of this role. Head of User Experience, NYC: The head of user experience looks after the customer preferences and also handles the properties listed on the website and the Airbnb app. Basically, the head of user experience tries to optimise the order of property listing in certain neighbourhoods and cities in order to get every property the optimal amount of traction.

Airbnb an online travel company that provides lodging, primarily vacation rental, homestays and experiences has shared the dataset for the city of New York from the period 2011 to 2019. It contains 48,895 rows and 16 columns. Each row represents a property listing along with its host and other details like the location, neighborhood, price and number of reviews. Region - New York Total count of Properties: 48895 Total number of Reviews(Bookings): 1138005

Download the dataset given below. This dataset contains information about different Airbnb listings along with their hosts, locations, prices and other attributes. AB_NYC_2019.csv

● The reviews are post-stay reviews responded within 1-2 days and hence one review can be considered as one booking. ● We assumed the data prior to the COVID – 19 period was achieving the desired revenue. ● We assumed the company does not want to expand yet to new territories in NYC. ● The company’s strategies are decided considering the travel will increase in the post COVID period.

● Excel ● Tableau