This project features an interactive Bike Sales Dashboard created in Microsoft Excel. The dashboard analyzes sales data from a dataset containing 1,027 rows and provides insights into sales trends, product performance, and regional analysis.
- Original Data and Working Sheet: The project includes an original data sheet alongside a working sheet for data manipulation and analysis.
- Pivot Tables: Utilized Pivot Tables to summarize and analyze sales data effectively.
- Visualizations: Created dynamic charts and graphs to visualize key metrics, including total sales, sales by product category, and sales by region.
- Slicers: Incorporated slicers for user-friendly filtering, allowing for quick access to specific data views.
- Microsoft Excel
- Data Analysis Techniques (PivotTables, Charts, Slicers)
The dashboard provides valuable insights into sales trends, enabling data-driven decision-making for marketing strategies and business operations.
- Download the Excel file.
- Open it in Microsoft Excel to explore the original dataset, working sheet, Pivot Tables, and the interactive dashboard.
- Use the slicers to filter data based on product categories or regions.
You can find logs (contains what I did after started working on this project) in the logs folder in the file named logs.md.
This Bike Sales Dashboard serves as a comprehensive tool for analyzing bike sales data, enhancing business strategies through data visualization and analysis.