Introduction

Case Study: Data Analysis in Databricks

Elliot Zhu

Data Scientist

What is Databricks?

$$

Cloud-based data analytics platform

  • Combines big-data processing with querying and visualization
  • Analyze large datasets efficiently
  • Collaborate on data projects in one shared workspace
  • Build dashboards - all in one place

$$

The Databricks logo.

Case Study: Data Analysis in Databricks

Overview

$$

Role: Consultant Data Analyst at Data X

  • Specialists in advanced data analytics solutions

Client: Airbnb

Focus location: New York City

  • A rich, diverse market: neighborhoods, price ranges, and property types

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...