online test Traveloka untuk data insight

analisa data terhadap travel business

1. What is the best time to give a promo code in Airbnb ? By: Rizka Rahmatie

2. Introduction Sometimes, A company give a promo code to increase customer's demand and caused increase income and profit . Customer's demand usually being down in particular pattern period, which is called low season . When is the low season occurred? And when is the high season occurred? To analyze it, we must prepare the data. We use calendar table that is contain of daily list available room to determine low or high season.

3. Profiling Data Analyze data Analyze what will we do and design to give a new insight business. In that case, I count available / non available room to determine low/high season demand. Check start and end period to determine the sample of research Check unique key of table. Check whether is there any listing room who has two condition (available and non available ) in the same day Check each of variable, control variable, response variable, and influence factor . In that case, we must check whether is there any change of total quantity listing room in the sample period.

4. Sample Data Check range period Is there any listing room who has two condition in the same day? Is there any change of total quantity listing room in the sample period? Profiling Data

5. Processing Data Data Preparation Select the data that has available = f. It means the room has been booking Prepare data to design analytical visualization Source Data Summary Data

6. Design Visualization Build three variant plot, there are: Plot a whole data, to see a whole pattern data Plot based on day of month to determine date for monthly profiling Plot based on name of day in weekend when weekly profiling Chart of Count non available Listing_id based on date in range period 2016-01-04 till 2017-01-02 I II III

7. Weekly Analysis Processing Data Lowest value

8. Processing Data Monthly Analysis Outlayer data Filtering

9. In 2016, number of guest in Airbnb has decreasing until December Based on the chart, low season is occurred in the range date 16-24, in particularly on Wednesday. If you want to increase number of guest using give a discount, such as promo code gift, choose the date on 16 – 24 , particularly on Wednesday Interpretation Data & Conclusion

10. Thank you For more information about the processing data, you can open in bellow link https://www.kaggle.com/rizkaputri16/kernel4e044ad443