Skip to content

Sales analysis of 8,500+ records using SQL, Excel & Power BI to track KPIs, store performance, and top product trends.

Notifications You must be signed in to change notification settings

analystfuzail/SalesDataProject

Repository files navigation

πŸ“Š Sales Data Analysis

This project analyzes historical sales data for a global company. It includes cleaning, exploration, and visualization of sales trends, top products, customer insights, and deal size breakdown.

πŸ“ Folder Structure

SalesDataProject/ β”œβ”€β”€ data/ β†’ Contains the raw CSV β”œβ”€β”€ analysis/ β†’ Jupyter notebook analysis β”œβ”€β”€ visuals/ β†’ Generated graphs & charts └── README.md

markdown Copy Edit

πŸš€ Tools Used

  • Python (Pandas, Matplotlib)
  • Jupyter Notebook
  • Git & GitHub

πŸ“ˆ Key Insights

  • The top product line by revenue was Classic Cars
  • USA generated the highest sales among all countries
  • Medium deal sizes contributed the most revenue
  • Clear monthly seasonality observed in sales

🧠 Future Enhancements

  • Interactive dashboard with Power BI or Streamlit
  • Predictive modeling based on historical trends

βœ… How to Run

  1. Clone the repo
  2. Open analysis/sales_analysis.ipynb
  3. Install dependencies (pip install pandas matplotlib)
  4. Run the cells step by step

About

Sales analysis of 8,500+ records using SQL, Excel & Power BI to track KPIs, store performance, and top product trends.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published