Skip to content

giridat/sales_analytics

Repository files navigation

📊 Superstore Sales Performance Dashboard

tableau_dashboard powerbi_dashboard

🔗 Google Sheets Dashboard: https://docs.google.com/spreadsheets/d/1mv2DZzlWOHcmcOrTriZeHcrsdxApss_uXFB7dR9nR6Y/edit?usp=sharing

🔗 Live Tableau Dashboard:
https://public.tableau.com/views/SuperstoreSalesPerformanceDashboard_17687388073650/SuperstoreSalesPerformanceDashboard?:language=en-US&publish=yes&:sid=&:redirect=auth&:display_count=n&:origin=viz_share_link


🧠 Project Overview

This project demonstrates an end-to-end Business Analytics workflow using real-world sales data.
The goal was to design a professional, recruiter-ready dashboard that provides clear business insights using modern BI tools.

The same analytics project was built across SQL → Python → Excel/Sheets → Power BI → Tableau, showing tool versatility and strong analytical foundations.


🔧 Tools & Technologies Used

Stage Tools
Data Storage PostgreSQL
Data Cleaning Python (Pandas)
Querying & Analysis SQL
Spreadsheet Analysis Google Sheets / Excel
BI Visualization Power BI, Tableau Public
Version Control GitHub

📌 KPIs Implemented

  • Total Sales
  • Total Profit
  • Profit Margin %

Formula:

Profit Margin % = Total Profit / Total Sales

📈 Visualizations Included

  • KPI Cards:
    • Total Sales
    • Total Profit
    • Profit Margin %
  • Sales by Region (Bar Chart)
  • Interactive Filters:
    • Region
    • Year
  • Clean dashboard layout using containers and responsive sizing

🎯 Key Features

  • Interactive dashboard filtering
  • Professionally structured KPI layout
  • Consistent analytics logic across Tableau and Power BI
  • Real business-style dashboard design
  • Portfolio-ready hosting on Tableau Public

🛠 Data Pipeline

  1. Raw CSV imported into PostgreSQL
  2. SQL used for exploration and aggregation
  3. Python used for:
    • Cleaning
    • Date formatting
    • Encoding fixes
    • Exporting clean CSV
  4. Excel/Google Sheets:
    • Pivot tables
    • Charts
  5. Power BI:
    • Dashboard replication
  6. Tableau:
    • Final professional dashboard deployment

📂 Suggested Repository Structure

superstore-sales-analytics/
│
├── data/
│   └── cleaned_superstore.csv
│
├── tableau/
│   └── superstore_dashboard.twbx
│
├── powerbi/
│   └── superstore_dashboard.pbix
│
├── screenshots/
│   ├── tableau_dashboard.png
│   ├── powerbi_dashboard.png
│
└── README.md

💼 Resume Bullet

Built an end-to-end Sales Analytics Dashboard using SQL, Python, Power BI, and Tableau. Designed KPI metrics (Total Sales, Total Profit, Profit Margin %) and interactive dashboards with filters by Region and Year. Published live dashboards on Tableau Public and replicated analytics logic across multiple BI tools.


🚀 Live Demo

🔗 Google Sheets Dashboard: https://docs.google.com/spreadsheets/d/1mv2DZzlWOHcmcOrTriZeHcrsdxApss_uXFB7dR9nR6Y/edit?usp=sharing

🔗 Tableau Public Dashboard:
https://public.tableau.com/views/SuperstoreSalesPerformanceDashboard_17687388073650/SuperstoreSalesPerformanceDashboard?:language=en-US&publish=yes&:sid=&:redirect=auth&:display_count=n&:origin=viz_share_link

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages