Excel Project Database on Bike Purchase

I used a raw Database which is a dataset on Bike purchases in different regions of the Continent. I imported the Dataset into Excel, removed duplicates, and used Find and Replace to make some sort of forms more meaningful. I created an Excel Formula using a nested IF statement to group Ages in Age brackets. I created 3 Pivot tables. The first shows the Relationship between Gender and Average Income. The second shows the Relationship between Age and the Purchase of Bikes. The last shows the Relationship between the Occupation of the Bike Purchases and their Marital Status. I created a visualization for each Pivot table and made a dashboard with the visualizations. Excel is so much underestimated. It can be used to tell stories that can be understood. with just a glance. #dataanlytics #excel #visualization