Skip to content

UdayMekaa/Sentiment_Sales_Forecasting_Amazon---Walmart

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

🧠 Sentiment-Driven Sales Forecasting (2023)

Combining Amazon Customer Sentiment with Walmart Sales using Python & GenAI

Dashboard

📌 Overview

This project explores the power of Natural Language Processing (NLP) and GenAI to enhance traditional sales forecasting. By analyzing customer sentiment from Amazon product reviews and aligning it with Walmart's historical sales data, we aim to uncover how public sentiment can influence purchasing behavior.


🧰 Tech Stack

  • Python (Pandas, NumPy, Seaborn, Matplotlib)
  • TextBlob for sentiment analysis
  • Jupyter Notebooks for EDA & modeling
  • Tableau Public for dashboarding
  • Amazon Fine Food Reviews Dataset
  • Walmart Sales Forecasting Dataset (M5)

📂 Project Structure

Sentiment-Driven-Sales-Forecasting/ │ ├── data/ │ └── raw/ │ ├── reviews/ # Amazon Fine Food Reviews CSV │ └── walmart/ # Walmart sales data CSV │ ├── notebooks/ │ ├── 01_clean_reviews.ipynb # Preprocess & analyze sentiments │ ├── 02_clean_sales.ipynb # Clean & transform Walmart sales │ └── 03_merge_analyze.ipynb # Merge, aggregate & insights │ ├── visualizations/ │ └── sentiment_sales_trends.png # Plots & graphs │ ├── dashboard/ │ └── Sentiment-Driven_Sales.twbx # Tableau workbook file │ ├── insights.txt # Final findings & conclusions └── README.md


📈 Key Insights

  • 📉 July sales dropped despite high positive sentiment → potential external disruptions
  • 📊 Negative sentiment spike in November correlated with a decline in sales
  • 🔁 Sentiment ratios can be early indicators for future sales behavior
  • 💬 Average positive sentiment: 75.5%
  • 💰 Total sales: ₹6.7B (₹6,737,218,987)
  • 🧾 Total reviews analyzed: 441,779

📊 Tableau Dashboard

Explore the interactive dashboard below:

🔗 View on Tableau Public


💡 How This Project Stands Out

  • 🔍 Applied GenAI NLP models to large-scale customer feedback
  • 🔄 Bridged unstructured reviews with structured sales data
  • 📊 Created a professional-grade Tableau dashboard
  • 🧪 Demonstrated real-world data storytelling with actionable insights

🤝 Let's Connect

If you found this project interesting or want to collaborate, feel free to connect:


📁 Datasets


📌 Future Improvements

  • Integrate LLM-based sentiment analysis (like GPT or BERT)
  • Add seasonality and promotions data
  • Improve forecasting using time-series models (ARIMA, Prophet, LSTM)

About

This project explores the power of Natural Language Processing (NLP) and GenAI to enhance traditional sales forecasting. By analyzing customer sentiment from Amazon product reviews and aligning it with Walmart's historical sales data, we aim to uncover how public sentiment can influence purchasing behavior.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors