CitiBike Use Case

Link to Polish version

 

Problem:
Determining the level of interest and potential profits from short-term rental of single-track vehicles.

Description:
The application presents an analysis of bike rentals for Jersey City over the past 12 months.

On the first page of the dossier, key metrics for the studied topic are presented, including total revenue, number of rides, and total ride time expressed in hours.

On the following pages of the application, more detailed analyses are made, such as:

  • Comparison of revenue divided into electric bikes and classic bikes,
  • Revenue analysis over time (broken down by months),
  • Weather analysis – how certain weather factors affected revenue and bike rentals,
  • Identification of the most profitable stations and stations that turned out to have the least impact on the company’s revenue growth.
 

The recipients of the application are the single-track vehicle rental industry, the fitness industry, advertisers, and city authorities.

Data sources:
Bike rental data for the analyzed area (Jersey City): https://s3.amazonaws.com/tripdata/index.html
Weather data for the analyzed area: www.visualcrossing.com/weather-api

Technology:
SQL Server Management Studio – Construction of the project database.

MicroStrategy – Construction of the data model, metrics, visualizations.

Python – Automation of data retrieval, so the application remains “up to date.”

KNIME – Processing of new data – extraction, transformation, loading of project data in an automated manner.

Leave a comment