Overview
This project showcases data visualization, business intelligence, and storytelling with Tableau. Using a dataset of 13,047 store sales records, the dashboards and stories provide actionable insights into sales performance, customer demographics, and geographic distribution.
The repository demonstrates skills in Tableau dashboarding, data analysis, and BI reporting — valuable for roles in data analytics, business intelligence, and visualization engineering.
📂** Repository Contents**
- TableauSalesMini_Project.twbx – Interactive Tableau workbook with dashboards and stories.
- TableauMiniProject_Dashboard.pdf – Exported dashboard summarizing KPIs.
- TableauMiniProject_Story.pdf – Narrative visualization highlighting trends and insights.
- TableauMiniProject.pdf – Detailed report with charts and explanations.
- Store_data.xlsx – Raw dataset for analysis.
- Tableau_Mini_Project_Documentation.Docx - Documentation on this Tableau mini project.
- README.md – Documentation for the project.
🔑** Key Insights**
- Sales Trend: Peak in March–April 2022, showing seasonal demand.
- Top Channel: Amazon dominates sales, followed by Flipkart and Myntra.
- Geographic Distribution:
- Maharashtra leads in sales, with Karnataka and Uttar Pradesh close behind.
- India is the primary contributor compared to neighboring regions.
- Customer Demographics:
- Adults are the largest buying group.
- Both Men and Women contribute significantly to revenue.
- Order Status: Majority of orders are Delivered, with smaller shares of Cancelled, Refunded, and Returned.
📈 Dashboards & Stories
- Sales by Channel – Compare Ajio, Amazon, Flipkart, Meesho, Myntra, Nalli, and Others.
- Monthly Sales Trend – Track fluctuations across months.
- Orders by Status – Delivered vs. Cancelled, Refunded, Returned.
- Top 10 States – Geographic sales distribution.
- Gender & Age Group Analysis – Demographic segmentation.
- Sales Story – Narrative combining trends, channels, and geography.
🚀 How to Use
- Clone the repository:
bash git clone https://github.com/swanacoop456/Tableau-Store-sales-dashboard.git - Open TableauSalesMini_Project.twbx in Tableau Desktop.
- Explore interactive dashboards and stories.
- Review PDFs for static insights.
- Use Store_data.xlsx for further BI analysis.
🛠** Tools & Technologies**
- Tableau Desktop – Dashboarding & storytelling.
- Excel – Data preprocessing.
- GitHub – Version control & hosting.
📌** Applications**
- Business Intelligence (BI) for e‑commerce platforms.
- Identifying top‑performing channels and regions.
- Understanding customer demographics and buying behavior.
- Supporting marketing, inventory, and strategic decision‑making.
👨💻 Author Developed by **Swaroop Kumar Vathada **
- 📍 Visakhapatnam, Andhra Pradesh, India
