Skip to content

UdayMekaa/Retail-Sales-Analytics-using-Python-Tableau

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

5 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

πŸ›οΈ Retail Sales Analytics (2023) – EDA + Tableau Dashboard

This project showcases an end-to-end data analytics pipeline:

  • πŸ“₯ Data Cleaning with Python
  • πŸ” Exploratory Data Analysis (EDA)
  • πŸ“Š Interactive Dashboard using Tableau

πŸ“‚ Project Breakdown

1. Data Cleaning & EDA (Python)

  • Removed missing values, duplicates
  • Standardized column formats
  • Performed EDA on sales, profit, customers, region
  • Visualized using Seaborn and Matplotlib

πŸ“„ Notebook: Retail_Sales_Analytics_EDA.ipynb


2. Interactive Dashboard (Tableau)

  • Total Sales, Profit, Orders, and Customers
  • Sales by Category, Region, and Customer
  • Monthly sales & profit trends
  • Filters by Year and Region
  • Key insights generated with GenAI

πŸ“Š Tableau File: Retail Sales Dashboard - 2023.twbx
πŸ“Έ Preview:
![Dashboard](Dashboard Preview.png)


🧠 Key Insights

  • Technology segment had highest sales but low profit margin.
  • West region contributed the highest overall profit.
  • November and December were peak performing months.

πŸ› οΈ Tools & Tech

  • Python (Pandas, NumPy, Matplotlib, Seaborn)
  • Tableau Public
  • ChatGPT (for summarization & insight extraction)

πŸ“Œ Outcome

This project demonstrates an end-to-end business data analysis pipeline β€” useful for dashboards, business intelligence, and stakeholder storytelling.


πŸ‘€ Author: Madhu Sudhan
πŸ“« LinkedIn

About

This project showcases an end-to-end data analytics pipeline: πŸ“₯ Data Cleaning with Python πŸ” Exploratory Data Analysis (EDA) πŸ“Š Interactive Dashboard using Tableau

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors