NYC Airbnb 2019 — Advanced Tableau Visualization & LOD Analytics Dashboard

Author: Billy Simba | IBM Advanced Data Visualization with Tableau Final Project (Tasks 1–16 Verified)
Download Packaged Workbook (.twbx)
Filtered Non-Null Listings (Task 4)
48,884
Price, Occupancy Rate, Min Nights NOT NULL
Avg Price per Night (Task 5)
$47.43
[Price] / [Minimum Nights]
Total Projected Revenue (Task 10)
$62.8M
SUM([Price] * [Minimum Nights])
Avg Occupancy Rate (Task 11)
30.9%
[Availability 365] / 365
LOD Price Difference (Task 9)
FIXED LOD
[Price] - { FIXED [Neighbourhood] : AVG([Price]) }
Task 15 & 16 Interactive Filter & Highlight Action (Neighbourhood Hierarchy):

Task 7 & 12: NYC Neighbourhood Hierarchy Map with Enhanced LOD Tooltips

Annotation (Task 14): Hover over any neighbourhood circle to inspect Calculated Host Listings Count, LOD Price Difference, Total Revenue, and Occupancy Rate.

Task 8: Average Price per Night across Neighbourhood Group

Annotation (Task 14): Click a bar or filter pill to trigger Task 15 Filter Action & Task 16 Highlight Action across all worksheets.

Task 6: Line Chart — Relationship Between Price and Reviews Per Month

Annotation (Task 14): Tracks mean listing Price across Reviews Per Month frequency cohorts by Neighbourhood Group.

Task 2 & Task 3: Room Type Hierarchy & Calculated Field (Room Category)

Formula: IF [Room Type] = "Entire home/apt" THEN "Entire Home/Apt" ELSEIF [Room Type] = "Private room" THEN "Private Room" ELSE "Shared Room" END

Neighbourhood GroupRoom Category (Hierarchy)ListingsAvg PriceAvg Price / Night