This project is based on analysing hosts of property rental and understanding the features on what makes a host superhost, so that the number of superhosts can be increased in order to grow the business. This analysis shows,in what aspects hosts can work on so as to improve the rentyal business. Analyis is done on two of italy's city Venice and Rome So, this repository contains Exploratory Data Analysis of Hosts behaviour using SQL (Structured Query Language), The analysis part is done in SQL and Dashboard has been made using Excel.
| Files/Folder | Description |
|---|---|
| Data Folder | This folder provides you a .md file with link of the drive containing dataset of different countries in csv format. |
| Excel Files Folder | This folder contains Dasboard of the project and schema of dataset. |
| Powerpoint Presentation Folder | This folder contains project presentation and project overview file in ppt format. |
| Rome File | This file provides you .sql format file which you can download and work on analysis using MS-SQL platform. |
| Venice File | This file provides you .sql format file which you can download and work on analysis using MS-SQL platform. |
o Fetching count of hosts and superhosts.
o Fetching Average,Minimum and Maximum Response rate.
o Fetching the total number of hosts and superhosts with verified identity.
o Comments analysis to understand what comments hosts or superhosts get.
o Fetching Average,Minimum and Maximum Acceptance rate.
o Fetching Availability details and doing many more analysis.
Must browse through from each folder of this repository must start with:
1.Always start with creating Database in SQL platform.
2.Then Import csv file. Below procedure and screenshot shows how to **import CSV** dataset in SQL SERVER.
o First go to Explorer window section.
o Left click on database in Explorer window
o Then select Task option
o And in last go to Import Flat file section and select CSV files and import it.
FROM ABOVE ANALYSIS FOLLOWING CONCLUSIONS VAN BE MADE:
o FOR A HOST TO BECOME SUPERHOST CRUCIAL FACTORS ARE RESPONSE RATE, RESPONSE TIME, ACCEPTANCE RATE.
o Maximum number of Super hosts Responses to the customer in within an hour.
o Super Hosts has a large number of Acceptance rate than that of Normal hosts.
o Listing Price Of super hosts is less than normal Hosts.
o No of Comments is Greater for Super Host than that of Normal Host.
o Super hosts Instant booking rate is more than normal hosts.
o Super Hosts have their identify verified at a greater rate than that of Normal hosts.