• UpdatedJan 29, 2024
• SQL

An end-to-end data pipeline which extracts divvy bikeshare data from web loads it into data lake and datawarehouse transforms it using dbt and finally , a dashboard to visualize the data using looker studio, the pipeline is orchestrated using prefect

• UpdatedApr 29, 2023
• Python

Scripts to combine various Chicago transit data feeds

• UpdatedAug 14, 2023
• Jupyter Notebook

A Python utility to scrape and export your Divvy bike data to .csv

• UpdatedApr 20, 2023
• Python

Portfolio

• UpdatedMar 9, 2022
• Jupyter Notebook

Data analysis performed on Divvy Bikes' database to convert more users of their bike rental service into subscribers.

• UpdatedJul 25, 2024
• HTML

Regression and Decision Tree Analysis of Divvy bike dataset to estimate bike demand based on weather conditions

• UpdatedJan 22, 2021
• Jupyter Notebook

• UpdatedSep 2, 2022

A case study on the fictional bike-share company Cyclistic's trip data, based on Chicago Divvy public dataset.

• UpdatedJun 29, 2023
• HTML

This project is to use Tableau to visualize the usage patterns of Divvy bikes in Chicago. By analyzing the trip data provided, we can gain insights into when, where, and how bikes are being used. This information can be useful for Divvy and the City of Chicago in planning future bike infrastructure and promoting sustainable transportation options.

• UpdatedMay 2, 2023

Developed a relational database that will enable quick response and analysis on the current state of Divvy’s operations in regard to ridership, station locations, other factors affecting them. Then built a scoring model to optimize the number of stations and bikes allocated by zip codes

• UpdatedMar 25, 2020

• UpdatedFeb 27, 2024

Analysis of Chicago's rideshare biking service, Divvy, in Q3 of 2019.

• UpdatedApr 19, 2021
• Jupyter Notebook

• UpdatedJun 1, 2024
• TSQL

Interactive visualization of available bikes and e-bikes at Divvy stations across Chicago.

• UpdatedOct 21, 2021
• HTML

Several classifier models to predict non-member vs member rider status based off of ride data for Divvy Bikes users. Trained off of 13 months of past ride data.

• UpdatedJul 19, 2024
• Jupyter Notebook

This is a repository of my work on data analysis as a part of the Google Data Analytics Capstone

• UpdatedAug 18, 2024

Interactive visualization of available bikes and e-bikes at Divvy stations across Chicago via Flask application. Must be run locally to use.

• UpdatedMay 19, 2021
• HTML

A comprehensive analysis and insights derived from the Google Data Analytics Capstone Project focused on Cyclistic, a bike-share program.

• UpdatedDec 19, 2023
• TSQL

This case study is about a fictitious company, Cyclistic. Where I will answer business questions, following the steps of the data analysis process: Ask, Prepare, Process, Analyze, Share and Act.

• UpdatedFeb 16, 2024
• Jupyter Notebook