Welcome to the Data Analysis with Excel project! This repository demonstrates how to leverage Excel for data cleaning, analysis, and visualization, providing actionable insights.
- Introduction
- Features
- Installation
- Usage
- Examples
- Key Insights
- Final Recommendations
- Contributing
- License
- Contact
This project showcases the use of Excel for comprehensive data analysis, from cleaning raw data to creating dynamic dashboards. Excel's versatile functions and visualization tools are ideal for both beginners and experienced analysts.
- Data Cleaning: Techniques for preprocessing and refining raw data.
- Data Visualization: Create interactive dashboards and charts using pivot tables, charts, and slicers.
- Step-by-Step Guides: Detailed instructions for replicating analyses.
- Real-World Datasets: Analysis examples with various datasets.
No specific installation is required—just ensure you have Microsoft Excel installed. You can download the latest version of Excel here.
-
Clone the repository:
git clone https://github.com/tanviparmarrajput/data-analysis-with-excel.git
Open the Excel files from the datasets or examples folders.
Follow the guides provided in the documentation or within the Excel files.
Explore and interact with the dashboards to gain insights.
- Sales Dashboard: Analyze and visualize sales performance trends throughout the year.
- Customer Segmentation: Segment customers based on demographics and purchasing behavior.
- Financial Analysis: Perform financial evaluations and create summary reports.
- Customer Demographics: Women account for 65% of total sales.
- Top Sales Month: Identified the month with the highest sales and orders.
- Order Status: Overview of completed, pending, and canceled orders.
- Top States: Maharashtra, Karnataka, and Uttar Pradesh are the top contributors to sales.
- Age Group: The 30-49 age group is the leading contributor to sales.
- Sales Channels: Amazon, Flipkart, and Myntra are key sales platforms.
- Top Categories: Pinpointed the highest-selling product categories.
Contributions are welcome! To contribute:
- Fork the repository.
- Create a new branch:
git checkout -b feature-name - Commit your changes:
git commit -m 'Add some feature' - Push to the branch:
git push origin feature-name - Open a pull request. License This project is licensed under the MIT License. See the LICENSE file for details.
Contact For questions or feedback, please reach out:
For questions or feedback, please reach out:
- Tanvi Parmar: parmarrajputtanvi@gmail.com
- GitHub: tanviparmarrajput