🔗 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
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.
| 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 |
- Total Sales
- Total Profit
- Profit Margin %
Formula:
Profit Margin % = Total Profit / Total Sales
- 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
- 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
- Raw CSV imported into PostgreSQL
- SQL used for exploration and aggregation
- Python used for:
- Cleaning
- Date formatting
- Encoding fixes
- Exporting clean CSV
- Excel/Google Sheets:
- Pivot tables
- Charts
- Power BI:
- Dashboard replication
- Tableau:
- Final professional dashboard deployment
superstore-sales-analytics/
│
├── data/
│ └── cleaned_superstore.csv
│
├── tableau/
│ └── superstore_dashboard.twbx
│
├── powerbi/
│ └── superstore_dashboard.pbix
│
├── screenshots/
│ ├── tableau_dashboard.png
│ ├── powerbi_dashboard.png
│
└── README.md
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.
🔗 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