Data Analytics Project Using Excel on Bike Buyers Dataset

Excited to share the latest project I’ve been working on! 🚀

Dataset Link: https://github.com/avnish22/Data-Analytics-Project-with-Excel-on-Bike-Buyers-Dataset/blob/main/Bike%20Buyers%20-%20Raw%20Data.xlsx

In the world of data analytics, the project is centered on the Bike Buyers dataset, executed exclusively in Microsoft Excel. This project unfolds in three strategic stages, demonstrating the versatility of Excel in transforming raw data into actionable insights.

● Data Cleaning: Employ Excel’s powerful features to clean, standardize, and enhance the Bike Buyers dataset, ensuring the integrity and accuracy of the information.

● Pivot Table Creation: Leverage Excel’s pivot functionality to succinctly summarize and analyze vast volumes of data, providing clarity on trends, patterns, and key metrics related to bike purchases.

Pivot Table 1.0

Pivot Table 1.1

● Dashboard Development for Bike Sales: Utilize Excel’s visualization tools to craft an intuitive, visually appealing dashboard that encapsulates critical insights, empowering stakeholders to make informed decision.

Dashboard 2.0 Bike Sales

Thank You