Introduction

Case Study: Data Analysis in Databricks

Elliot Zhu

Data Scientist

Overview

Role

  • You are a Data Analyst Consultant at Data X, working closely with Airbnb

Focus location: New York City

  • A key market for Airbnb, known for its diverse neighborhoods, price ranges, and property types
  • Provides a rich dataset for insights into customer behaviors and host performance

Airbnb distribution map of NYC boroughs (2010-2013), showing listings, hosts, reservations, and payouts. Manhattan leads in all metrics, followed by Brooklyn, with other boroughs trailing. Darker shades indicate higher revenues.

Case Study: Data Analysis in Databricks

Goal of the case study

  • Understand Airbnb dataset structure
  • Analyze listings and reviews to identify trends
  • Provide insights for pricing, customer experience, and operational strategies

The image for Airbnb logo.

Case Study: Data Analysis in Databricks

Dataset overview

  • Property listings: Price, location, host details, room type etc. information across all five boroughs: Manhattan, Brooklyn, Queens, the Bronx, and Staten Island

Table example for the listing dataset.

  • Customer reviews: Scores, dates, review rate

Table example for the review dataset.

Case Study: Data Analysis in Databricks

Get started!

Case Study: Data Analysis in Databricks

Preparing Video For Download...