Skip to content

ggiss3272/Beginner-Data-Analysis-Python

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

20 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

🧾 Beginner Friendly Sales Data Analysis Project (Python)

πŸ“Œ Project Overview

This project is beginner-friendly data analysis project using Python & Pandas. The goal was to analyze a small sales dataset, clean it, perform basic data analysis. and visualize trends.

It's a great starter project to practice Python, Pandas, and data analysis workflows before moving on to SQL and Tableau.


🧰 Tools & Libraries Used

  • Python 3
  • Pandas (data cleaning and analysis)
  • Matplotlib (visualization)
  • Jupyter Notebook

πŸ”Ž Steps in the Project

  1. Load & Explore Dataset

    • Import dataset, check info/statistics, & preview rows
  2. Data Cleaning

    • Checked for duplicates/missing values
    • Verified data types
    • Validated the total sales calculations (Revenue = Quantity x Unit Price)
  3. Analyize

    • Total Revenue
    • Revenue by product & category
    • Monthly sales trend
  4. Visualizations

    • Line chart for monthly sales
    • Bar chart for distribution of order sizes
  5. Extra Insights

    • Average Order Value
    • Average items per order
    • Distribution of order sizes

πŸ“Š Key Insights

- **Top Product:** Laptops
- **Top Category:** Electronics
- **Monthly Trend:** Sales peaked in November, October, July
- **Customer Behavior:**
    - Avg order value ~$1,106
    - Avg items per order ~2.5

πŸ“ Project Structure

πŸ“ Beginner Python/Pandas Analysis Project - πŸ“„ sales_data.csv - πŸ“„ beginner_python_code.ipynb - πŸ“„ README.md


πŸ™Œ Acknowledgements

This is a practice project I did to learn basic Python & Pandas for Data Analysis!! πŸ€“πŸ€ͺπŸ’»πŸ“Š