Skip to content

SQL-python-Tableau-Data analysis dashboard

bigjosher/superstore-dashboard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Superstore Sales Dashboard

This project visualizes retail sales performance using Tableau. Data is analyzed using PostgreSQL, and insights are presented via an interactive dashboard.


Tools Used

  • PostgreSQL (SQL analysis)
  • Tableau (visualization)
  • Python (CSV cleaning, optional)(skip this step as the csv file in the folder is already cleaned.)

Live Dashboard

View it here → Superstore Dashboard on Tableau Public


Key Business Questions Answered

  1. What are the monthly sales trends?
  2. Who are the top 10 customers by revenue?
  3. Which product categories are most/least profitable?
  4. How do discount levels impact profit?
  5. What are the regional performance differences?

Insights

  • Profit decreases drastically when discounts exceed 30%
  • Technology category leads in both revenue and profit
  • The West region dominates in total sales
  • Top 10 customers contribute over 20% of total revenue
  • Optimal discount ranges: 0.1–0.2, beyond that losses increase

SQL Queries

All queries are in /sql/analysis_queries.sql.

About

SQL-python-Tableau-Data analysis dashboard

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages