BIKES SALES (EXCEL)
About this project
Project Overview:
In this project, I undertook the task of analyzing demographic data and bike purchase
behavior using
Excel. Starting with raw data containing various attributes such as marital status, gender, income, education,
and more,
I transformed and structured the data to derive actionable insights. My objective was to gain a comprehensive
understanding of customer demographics and their purchasing patterns to inform strategic business decisions.
Data Transformation:
To enhance clarity and consistency, I meticulously refined the raw data. Notably, I
modified
marital status and gender labels for improved readability and understanding. For instance, "Married" and
"Single"
replaced "M" and "S" respectively, while "Female" and "Male" represented gender. These changes facilitated
easier
interpretation and analysis of the dataset.
Additionally, I standardized the income figures to a consistent format (£) and introduced age group
categorization based
on predefined thresholds. The age group categorization formula ensured accurate classification of individuals
into
"Old," "Middle Age," and "Adolescent" categories.
Insights Derived:
Upon structuring the data, I utilized pivot tables and charts to analyze key metrics such as average
income by gender and bike sales, distribution of bike purchases by age group, and commute distance preferences.
These
analyses provided valuable insights into customer segments' preferences and behaviors, helping identify
potential target
demographics for bike sales initiatives.
Key Findings:
Middle-aged individuals constituted the majority of bike purchasers, indicating a potential focus area for
marketing
efforts..
Customers with higher incomes demonstrated a greater propensity to purchase bikes, highlighting the importance
of income
level in driving purchasing decisions.
Commute distance also influenced bike purchase behavior, with shorter commute distances correlating with
higher purchase
rates.
Dashboard with different slicers:
Conclusion:
By leveraging Excel's capabilities for data analysis and visualization, I successfully transformed raw
demographic data
into actionable insights for strategic decision-making. This project exemplifies my proficiency in data
manipulation,
analysis, and interpretation, essential skills for driving business growth and innovation.
