SQL Project

In 2022, Cyclistic, a bike-share company in Chicago, gathered data on bike usage by casual riders and annual members.

 

The marketing analyst team aims to analyze this data to identify differences in usage patterns between the two groups and design strategies to convert casual riders into annual members.

​

Here's a basic overview of the dataset following four steps:

• ​Data combining

• Data exploration

• Data cleaning

• Data analysis

​

Data source:  divvy-tripdata