The dataset is stored in an Excel file named Original Data.xlsx. It includes the following columns:
- ID
- Marital Status
- Gender
- Income
- Children
- Education
- Occupation
- Home Owner
- Cars
- Commute Distance
- Region
- Age
- Age Bracket
- Purchased Bike
This project involves the following steps and components:
- Data Cleaning and Preprocessing: The dataset underwent thorough cleaning and preprocessing within Excel to ensure data quality and consistency.
- Pivot Tables and Charts: Utilizing Excel's pivot tables and charting features, we've created visualizations to uncover trends and insights related to different aspects of the dataset.
- Sales Analysis Dashboard: The project culminates in a visual dashboard created entirely within Excel. This interactive dashboard provides an overview of the sales data and allows users to explore key metrics and trends.
To explore the project:
- Download the Raw Data.xlsx file from this repository.
- Open the Excel file using Microsoft Excel or an equivalent spreadsheet software.
- Navigate through the different sheets to view the data, pivot tables, charts, and the interactive dashboard.
- This project is licensed under the MIT License.
- Feel free to use, share, and adapt the content. If you have any feedback or suggestions, please let us know. Enjoy your sales analysis journey!