📊 Sales Data Analysis & Forecasting
Welcome to the Sales Data Analysis & Forecasting project! 🚀 This repository showcases my data analysis skills through exploratory data analysis (EDA), data cleaning, and visualization of sales and customer feedback data. The goal is to extract actionable insights to drive business decisions.
📝 Project Highlights
🔍 Overview
- 📈 Exploratory Data Analysis (EDA): Detecting patterns and trends in sales data.
- 🛠 Data Cleaning & Transformation: Ensuring the quality and reliability of the dataset.
- 📊 Visualizations: Creating engaging and informative charts for decision-makers.
🛠 Tools & Technologies Used
- 🖥 Programming Language: Python
-
📚 Libraries:
- 🐼 Pandas – for data manipulation and cleaning
- 🧮 NumPy – for numerical computations
- 🎨 Matplotlib and Seaborn – for visualization
- IDE: PyCharm
📁 Dataset Overview
The dataset includes the following columns:
- 🆔 product_id: Unique identifier for each product
- 🏷️ product_name: Name of the product
- 📦 category: Product category
- 💰 discounted_price and actual_price: Pricing details
- 🔢 discount_percentage: Discount percentage offered
- ⭐ rating and rating_count: Product rating and number of ratings
- 🗒️ about_product: Short description of the product
🔑 Key Insights Extracted
-
🎯 Product Ratings Distribution: Analyzed how customers rate products across various categories. Insight: Certain categories consistently outperform others in average ratings.
-
📊 Category-Wise Discount Analysis: Average discount percentages by category to identify pricing strategies. Insight: Categories with optimal discounts tend to have better sales performance.
-
💹 Sales and Ratings Trends: Identified correlations between ratings, rating counts, and sales trends to understand customer preferences.
📊 Visualizations
Histogram: Distribution of Product Ratings
Bar Chart: Average Discount Percentage Across Categories
Average Rating Counts by Product Category
🛠️ How to Run This Project
- Clone the repository:
git clone https://github.com/your-repo/sales-data-analysis.git
- Install the required Python libraries:
pip install -r requirements.txt
- Run the project:
python main.py
=======
📊 Sales Data Analysis & Forecasting
Welcome to the Sales Data Analysis & Forecasting project! 🚀 This repository showcases my data analysis skills through exploratory data analysis (EDA), data cleaning, and visualization of sales and customer feedback data. The goal is to extract actionable insights to drive business decisions.
📝 Project Highlights
🔍 Overview
- 📈 Exploratory Data Analysis (EDA): Detecting patterns and trends in sales data.
- 🛠 Data Cleaning & Transformation: Ensuring the quality and reliability of the dataset.
- 📊 Visualizations: Creating engaging and informative charts for decision-makers.
🛠 Tools & Technologies Used
- 🖥 Programming Language: Python
-
📚 Libraries:
- 🐼 Pandas – for data manipulation and cleaning
- 🧮 NumPy – for numerical computations
- 🎨 Matplotlib and Seaborn – for visualization
- IDE: PyCharm
📁 Dataset Overview
The dataset includes the following columns:
- 🆔 product_id: Unique identifier for each product
- 🏷️ product_name: Name of the product
- 📦 category: Product category
- 💰 discounted_price and actual_price: Pricing details
- 🔢 discount_percentage: Discount percentage offered
- ⭐ rating and rating_count: Product rating and number of ratings
- 🗒️ about_product: Short description of the product
🔑 Key Insights Extracted
-
🎯 Product Ratings Distribution: Analyzed how customers rate products across various categories. Insight: Certain categories consistently outperform others in average ratings.
-
📊 Category-Wise Discount Analysis: Average discount percentages by category to identify pricing strategies. Insight: Categories with optimal discounts tend to have better sales performance.
-
💹 Sales and Ratings Trends: Identified correlations between ratings, rating counts, and sales trends to understand customer preferences.
📊 Visualizations
Histogram: Distribution of Product Ratings
Bar Chart: Average Discount Percentage Across Categories
Average Rating Counts by Product Category
🛠️ How to Run This Project
- Clone the repository:
git clone https://github.com/your-repo/sales-data-analysis.git
- Install the required Python libraries:
pip install -r requirements.txt
- Run the project:
python main.py
>>>>>>> 552158a9e6fbd8f0c15295d40a14472fadba09df