Welcome to the Sales Analysis Excel Project repository! This project focuses on analyzing sales data using Microsoft Excel. The dataset consists of various factors related to customers and their purchasing behavior.
The dataset is stored in an Excel file named Raw 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.
Feel free to customize the project according to your needs and use it as a reference for your own Excel-based analysis.
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!