Bike Store Sales Analysis 

This project involved the creation of an interactive Excel dashboard to analyze sales data from bike stores across the globe.​The objective was to clean, process, and visualize the sales data to uncover key insights, trends, and performance metrics.

 

The final deliverable was a user-friendly dashboard that provided stakeholders with a clear and concise overview of sales performance across various dimensions such as average income per purchase , product categories, customer commute and customer segments.​​

​

Skills and Techniques Applied : Data Cleaning and Preparation, Data Processing, Data Analysis, Dashboard Creation, Pivot Tables, Power Query, Data Validation, Array Formulas, Descriptive Statistics, Dynamic Charts, Slicers, Conditional Formatting, etc. 

​​

NB: For the interactive dashboard, kindly contact for link.