Florida Airbnb Analytics
Unlocking what drives profitability in Florida's short-term rentals
01
Business Question
Explores how location, amenities, property type, and seasonality affect revenue and occupancy in Florida's Airbnb market. Broward County (Fort Lauderdale) is used as a representative South Florida region because Miami's dataset was unavailable.
Florida's Airbnb market is highly seasonal and competitive. Stakeholders need clarity on which factors most affect profitability — including how pricing, amenities, and neighborhood dynamics drive occupancy and revenue.
Business task
Analyze Airbnb data from Broward County (proxy for Miami–Fort Lauderdale) to identify key drivers of pricing, occupancy, and revenue.
Stakeholders
- Hosts & property managers
- Real estate investors
- City / tourism planners
Key performance indicators
- Average Daily Rate (ADR)
- Occupancy Rate (%)
- Revenue per Available Listing (RevPAL)
- Amenity Impact Score
- Neighborhood Performance Index
Guiding questions
- How do pricing and occupancy vary by neighborhood?
- Which amenities add the most value?
- How does property type affect revenue?
- What seasonal patterns shape demand?
02
Data Sources
Inside Airbnb · Broward County, FL · snapshot 2025-06-24
| File | Contents | Size | Source |
|---|---|---|---|
| listings.csv.gz | Property details | ~12,000 rows · 82 columns | Google Drive |
| calendar.csv.gz | Daily pricing | ~2M rows | Google Drive |
| reviews.csv.gz | Guest feedback | ~1M rows | Google Drive |
Validation summary
- Verified datasets open correctly in Google Sheets.
- listings.csv → ~12,000 rows (82 columns).
- calendar.csv → partial sample loaded (~2M total rows).
- No missing headers or corrupted data found.
- Metadata and snapshot details recorded in the Data Summary tab.
- Data dictionary (metadata log) — in progress.
Limitations
Broward County is used as a proxy for the Miami–Fort Lauderdale market because Miami's dataset was unavailable at the time of collection. Data reflects a single snapshot date.
03
Preparation & Cleaning
04
Methodology
The Google Data Analytics workflow. Select a phase to see its status.
05
Analysis
06
Dashboards
07
Findings
08
Recommendations
09