Skip to content

tyagi-mansi11/Bike_Buyers

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 

Repository files navigation

Bike Buyers

Built a Dashboard in Excel by following a YouTube tutorial

Skills Learnt

● Data Cleaning
● Nested IF statement
● Pivot Tables
● Adding Pivot Charts
● Building Dashboard
● Insert Slicers

Dashboard

Excel File

Insights

● Bike purchases are notably higher in North America with purchases of 49%.
● Single individuals are more likely to purchase bikes.
● Both Single and married males have a higher average income per purchase.
● Very few customers in all the 3 regions commute long distances (over 10+ miles).
● For customers in Europe and the Pacific, commutes are often short, typically within (0-1 miles). This may be due to factors like denser urban areas or well-developed public transportation and in North America, commutes are typically longer, averaging between 2-5 miles.

About

Guided Project

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published