This repository holding a end-to-end dashboard report on Airbnb business in the HK market and providing recommendations on how to improve the services with analysis on 6,747 rows of listing records and 203,701 rows of customer review and rating which help to boost the revenue.
The dataset used in this project is from Inside Airbnb
Nicole Tang , Issac Lee , Kimberly Cheung
| Document | Progress | Version | Links | |
|---|---|---|---|---|
| 1 | Original Dataset from inside Airbnb | 1 | listings-gz.csv reviews.csv | |
| 2 | Checking Data and NLP on reviews | DONE | 1 | Data_checking_NLP.ipynb reviews_add_token.csv |
| 3 | Dashboard Report | DONE | 1 | BI - Project - 31 Aug.pbix |
| 4 | Format Design | DONE | 1 | Format |
1. Home Page with KPIs and buttons
2. Basic data of HK markets
3. Short-term Analysis from operation perspective
4. Mid-term Analysis from operation perspective
5. Customer Analysis
- Analysis on the keywords from customer reviews and having a sentiment analysis on the reviews.
6. Host Analysis on Ratings score
- As a filter for host relationship department to filter out the hosts who needs advice
7. Q & A
