Exploratory Data Analysis
Tableau
SQL
Python
- Querying in SSMS (SQL Server Management Studio) using self joins, CTEs, procedures, group by to view the data required
- Data Cleaning
- Data Analysis (Q/A)
- Data Transformation for dashboard visualization
- Overview: listings, accomodations available, average price($), average rating, and total reviews info per borough
- Filtering: Giving the options to find the desired location and attaching the links to the website for more details
- Key Insights: Displaying the insights on the boroughs, room types, prices, reviews, and hosts
- Superhosts v Non Superhosts: Figuring out the edge of superhosts
- Excel
- SQL (SQL Server Management Studio)
- Tableau
- Figma
- Mapbox
- Python (pandas, seaborn, matplotlib)