Bike Rental Data Management

Created a comprehensive database management system with analytics-ready views for a project that integrated Citi Bike and weather datasets

About Project

Successfully created a flexible and efficient relational database to store bike rental data, using datasets from Citi Bike and NOAA

Project was executed in following stages

Data Cleaning, Exploring and Inspection
Developing a relational database structure (RDBMS)
Implementing the database in PostgreSQL
Data Insertion in Database (using SQLAlchemy and Pandas)
Developing flexible analytics-ready views on top of the relational database
Executing SQL Queries on the implemented database

Project was executed in following stages

Data Cleaning, Exploring and Inspection
Developing a relational database structure (RDBMS)
Implementing the database in PostgreSQL
Data Insertion in Database (using SQLAlchemy and Pandas)
Developing flexible analytics-ready views on top of the relational database
Executing SQL Queries on the implemented database

Project was executed in following stages

Data Cleaning, Exploring and Inspection
Developing a relational database structure (RDBMS)
Implementing the database in PostgreSQL
Data Insertion in Database (using SQLAlchemy and Pandas)
Developing flexible analytics-ready views on top of the relational database
Executing SQL Queries on the implemented database

Project was executed in following stages

Data Cleaning, Exploring and Inspection
Developing a relational database structure (RDBMS)
Implementing the database in PostgreSQL
Data Insertion in Database (using SQLAlchemy and Pandas)
Developing flexible analytics-ready views on top of the relational database
Executing SQL Queries on the implemented database

Project Stack

Python, SQL, RDBMS

Project Stack

Python, SQL, RDBMS

Role

Data Analyst, Database developer

Role

Data Analyst, Database developer

Services

EDA, Data Viz, Datbases, Query

Services

EDA, Data Viz, Datbases, Query

CodeBase

GitHub Repo

CodeBase

GitHub Repo

Jupyter Notebook

Nbviewer

Jupyter Notebook

Nbviewer

"The project's codebase is readily accessible on GitHub, and you can explore its implementation through the Nbviewer for Jupyter Notebook"

Waqas Ahmad – Data Analyst

Take me back home