The data spans from September 2023 to September 2024, offering a comprehensive look at how Italy’s rental landscape is evolving. Perfect for data analysts, real estate enthusiasts, and anyone curious about the vacation rental market.

In this project will will create 5 Dashboards Using Power BI and Tableau. Purpose of these dashboards will be to teach students how to understand the questions and answer accordingly. It will also help students in gaining problem solving and data analysis skills.

The Dataset can be downloaded from: https://www.kaggle.com/datasets/salvatoremarcello/italian-airbnb-dataset

🏠 1. Listings Overview

Total Listings: What is the total number of listings available across all cities?
Listings by Property Type: How many listings exist for each property type?
Listings by Neighborhood: Which neighborhoods have the highest number of listings?
Listings by City (Seasonal): What is the seasonal distribution of listings across different cities?

💰 2. Pricing Insights

Average Price: What is the average listing price for each property type?
Price Range: How are prices distributed across all listings?
Price vs. Rating: Is there a relationship between listing prices and their rating scores?
Top Expensive Listings: Who are the hosts of the top 5 highest-priced listings?

⭐ 3. Host Insights

Host Type: What proportion of listings are owned by Superhosts compared to Regular Hosts?
Host Listings Count: How many listings does each host have?
Top Hosts: Which 5 hosts have the highest number of listings?
Superhost Impact: How do Superhost listings compare to Regular Host listings in terms of price and rating?

⭐ 4. Rating & Review Analysis

Average Rating: What is the average rating of all listings?
Rating by Property Type: How does average rating vary by property type?
Review Frequency: What is the average number of reviews listings receive monthly?
Rating Breakdown: How do ratings differ across cleanliness, value, and location?
High-Rating Budget Listings: Which listings have a rating above 4.8 and are priced below the median?

🛁 5. Amenities & Property Features

Bedrooms & Beds: What is the count of listings with 1, 2, or 3+ bedrooms?
Bathroom Type: What is the proportion of private versus shared bathrooms in listings?
Max Allowed Guests: How many listings can host more than 4 guests?
Entire Home vs. Private Room: What are the price and rating differences between entire homes and private rooms?
Property Type by Neighborhood: Which property types are most common in each neighborhood?