Airbnb Data Analysis for Purchasing the Optimal Property to Rent

🔗 PROJECT LINKS

• 💻 PDF Report
• 💻 Excel Workbook

> Note: In case the linked files (PDF report and Excel workbook) cannot be viewed directly on GitHub, please download the files and open them in their respective applications for proper access.

Introduction

This Airbnb data analysis project is aimed at finding the optimal property to purchase and list for rental in the Airbnb marketplace. Along with this, I aim to forecast the potential earnings.

Tools Used

• Advanced Formulas & Functions
• Advanced Formatting
• Analytical Tools
• Pivot Tables
• Charts

Steps Followed

1. Structure of the Dataset
2. Cleaning and Processing
3. Analyzing and Sharing Analysis through Visualizations
4. Findings of the Analysis in Conclusion

---

Data Cleaning and Processing

• Cleaned and processed the data using advanced formulas and formatting tools like conditional functions, VLOOKUP, INDEX, MATCH, etc.

Data Analysis

• Analyzed the data using Pivot Tables and What-If Analysis (Goal Seek) to forecast profit and revenue.
• Created visualizations using Excel charts such as Sunburst, Box and Whisker, Treemap, etc.

---

Findings

• Optimal Property Selection: Identified the best property to invest in.
• Revenue and Profit Forecasting: Estimated potential earnings and ROI.

---