Exploratory Analysis of Geolocational Data

Subhradip Roy

Data Scientist
Data Visualizer
Data Analyst
ggplot2
GitHub
R

Project Description

The project centered around a comprehensive case study of a Bike Rental Company in Chicago, focusing on understanding the usage patterns of casual riders and annual members. The primary objective was to extract actionable insights that would inform the design of a new marketing strategy to convert casual riders into annual members.
The recommendations had to be supported by compelling data insights and presented through professional data visualizations.
The entire process from summary to data cleaning steps to data analysis and to final report is hosted on a standalone website using GitHub Pages. This approach allowed for easy access, navigation, and presentation of the project for stakeholders.

Client's Goal for the Project

The client aimed to leverage data-driven insights to develop an effective marketing strategy for converting casual riders into annual members. The project required a deep dive into user behavior, highlighting key distinctions between casual riders and annual members, and presenting findings in a visually compelling manner to secure executive approval.

Details about My Contribution

● Data Extraction and Cleaning : Extracted relevant data from the company's website and other sources, ensuring accuracy and completeness. Conducted thorough data cleaning to address inconsistencies and discrepancies, laying the foundation for robust analysis.
● Exploratory Data Analysis ( EDA ) : Employed R and various libraries such as ggplot, dply, plotly, tidyr, shiny etc to perform an in-depth exploratory data analysis. Utilized statistical techniques to uncover meaningful patterns and trends in user behavior, emphasizing the differences between casual riders and annual members.
Folium Map
Circular Bar Chart
Circular Bar Chart
● Data Visualization : Created visually appealing and easy-to-understand data visualizations, including heatmaps and Folium Maps, to effectively communicate key insights. Ensured that the visualizations supported the narrative of user behavior and provided a clear basis for marketing strategy recommendations.
Histogram
Histogram
Heat Map
Heat Map

Summary of Project Success

● The project successfully delivered on its goals by providing the client with a nuanced understanding of user behavior, backed by compelling data insights and professional data visualizations.
● The hosted website on GitHub Pages served as a centralized platform for executives to review the project seamlessly. The recommendations for the new marketing strategy were supported by solid data evidence, enhancing the likelihood of executive approval.
● Overall, the project demonstrated the power of data-driven decision-making and showcased the potential for informed marketing strategies based on thorough exploratory data analysis.
Partner With Subhradip
View Services

More Projects by Subhradip