Skip to main content

BIKE SALES ANALYSIS WITH MS EXCEL

By

Introduction

This project was an analysis of a Bike Selling Company`s dataset of its potential customers. This project was undertaken as a challenge by my mentor,  Alex the Analyst. The purpose of this project was to, among others;
  • Find the correlation between income of citizens and their ownership of bikes.
  • The relationship between marital status and owning a bike.
  • If the distance people commute to work affect their bike purchase.
  • How the education level of people influence their willingness to buy bikes.
  • The relationship between different age groups and their purchase of bikes.
  • Any other insight that may arise from the analysis.

Data Gathering and Transformation

The dataset was downloaded from Github. The link to the dataset was provided by Alex the Analyst, a mentor in the data community. To get the data, I simply clicked the link provided under his Youtube video and was taken to his Github Repository. The dataset was downloaded and converted to excel sheet.

Cleaning the Data


  • The dataset cleaning was done with MS Excel. First, the duplicates values was removed. I deleted 26 duplicated values in total leaving only unique values.
  • Next, the Marital Status and Gender column values were replaced as follows; M=Married, S=Single, F=Female, M=Male.  This was done by pressing CTRL +H  which opens the Replace Menu that allows all values to be replaced at a go.
  • Then the data type of the Income column was changed from general to currency.
  • A new column (Age Bracket) was created to group the ages in ranges, Adolescent, Middle Age and Old. This was down using Nested IF function.



Data Analysis

The data analysis was done using pivot tables and pivot charts. Three pivot tables were created ( Purchase per Gender by Income, Customer Commute, Bike Purchase per Customer Age bracket). These charts will later be used for the dashboard.

Report Design

A simple dashboard report was created using the pivot charts. 















Insights

  • People with higher income purchase more bikes than those whose incomes are lower.
  • Married people purchase 7% more bikes than singles people. 
  • People who commute within 1 mile own more bikes.
  • People who have Bachelors Degree purchase more bikes than people with lower education.
  • Middle age people between 31 to 54 own significantly more bikes than other age groups.



Labels:

Comments

Post a Comment

Popular posts from this blog

WHAT IS DATA ECOSYSTEM

By
An ecosystem, to put it simply, is a collection of components that communicate with one another. The jungle in a tropical rainforest or the amazon rain forest are examples of vast ecosystems. The germs on your skin may also be small, like tadpoles in a puddle. Additionally, data has its own ecology, just like the kangaroos and koala bears that reside in the Australian desert. Data is produced, managed, stored, organized, analyzed, and shared through the interaction of many different parts that make up data ecosystems. These components include the people who use the tools, as well as the technology and software. The cloud is another place where data can be found. Instead of storing data on a computer hard disk, you can use the cloud. So, data is accessed through the internet rather than being stored somewhere inside your company's network. As a data analyst, it is your responsibility to make the most of the cloud's role in the data ecosystem, locate the pertinent data, and offer...
Post a Comment
Read more

The Benefits of Supply Chain Analytics for Company Revenue

By
Businesses have several difficulties with supply chain management (SCM), including a need for more transparency, production scheduling, and team synchronization. Intelligent data analytics are used by businesses in the manufacturing, retail, and fast-moving consumer goods (FMCG) industries to address these issues. Supply chain analytics is the phrase for this. Companies can use it to determine consumer preferences and forecast future product or service demand. Let's examine supply chain analytics in more detail. Supply Chain Analytics: What Is It? It alludes to the improvement of supply chain procedures through the application of big data analytics. Simply put, it refers to using various tools to analyze the data gathered during the SCM process and extract real-time insights to enhance logistics and the SCM environment. Three main elements make up supply chain analytics: a software platform, data analytics, and data visualization. Data analytics makes it easier to get insightful ma...
Post a Comment
Read more

WILL ARTIFICIAL INTELLIGENCE RENDER DATA ANALYSTS USELESS?

By
  Introduction Artificial Intelligence (AI) has rapidly evolved and permeated numerous aspects of our lives, revolutionizing industries such as healthcare, finance, and transportation. With its ability to process vast amounts of data, draw insights, and make predictions, it is natural to wonder if AI will render human data analysts obsolete. In this blog post, we will explore the role of AI in data analysis and examine whether it will make data analysts useless or create new opportunities for collaboration. The Rise of AI in Data Analysis AI has significantly enhanced the capabilities of data analysis by automating repetitive tasks, accelerating data processing, and uncovering patterns that humans may overlook. Machine learning algorithms can quickly analyze large datasets, identify correlations, and generate accurate predictions. Additionally, AI-powered tools can handle complex statistical analyses, perform sentiment analysis on text, and even generate natural language summaries ...
Post a Comment
Read more