/Host-Behavior-Analysis-using-SQL

In this work, I have compared hosts based on several criteria and discovering insights about hosts by analysing the Property Rental Dataset of two Canadian cities TORONTO and VANCOUVER using SQL

🏨Host Behavior Analysis using SQL

In this work, I have compared hosts based on several criteria and discovering insights about hosts by analysing the Property Rental Dataset of two Canadian cities TORONTO and VANCOUVER using SQL (Structured Query Language).


User's Manual

Files/Folder Description
Data Folder This folder provides you a google drive link where you can find the Property Rental Dataset of two Canadian cities TORONTO and VANCOUVER.
All Key Points Folder This folder contains a PDF file of all the key points which I have to find out.
Excel Analysis Folder This folder contains an Excel file where I have done different kinds of analysis and created different kinds of charts using the data which I have drawn from the database using SQL.
Presentation Folder You can view all the insights I discovered after doing my task in a PDF file that is contained in this folder.
SQL Query for Host Behavior Analysis file You can find all the necessary queries in this file, along with all the information I retrieved from the database using SQL.

Analysis

  • Analysis on the distinction between SUPER HOST and NORMAL HOST on different dimensions like:

    • Acceptance rate
    • Response rate
    • Instant booking
    • Profile picture
    • Identity verification
    • Review scores
    • Average number of bookings per month, etc.

  • Analysis on how the comments of reviewers vary for listings of SUPER HOST vs. NORMAL HOST (by extracting words from the comments provided by the reviewers).

  • Analysis on the average price and availability of the listings for the upcoming year between SUPER HOST and NORMAL HOST.

  • Comparison between SUPER HOST vs NORMAL HOST for Large Property Listings.

  • Comparing how the aforementioned tendencies differ between hosts who live close to their listed property and hosts who live elsewhere. 

  • Obtaining meaningful insights through the use of Excel charts.


Prior Knowledge

language-sql microsoft-sql-server

Quick Start

Must browse through each folder of this repository and start with:

1.Always start with creating Database in SQL platform.

2.Then Import csv file. The procedure and screenshot below demonstrate how to import a CSV dataset into SQL SERVER. 

     o First go to Object Explorer 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.


📃Database schema

For More Information on Database Schema : Click Here


Google Drive Link :

  • All the necessary data in one folder: Click here

➡️ LinkedIN Profile

linkedin