Projects using Tableau in BhiwandiProjects using Tableau in BhiwandiRetail Store Sales Analysis (SQL + Tableau)
I built a sales analytics project for a fictional retail chain, OmegaEnterprise, to analyze revenue performance, customer behavior, and inventory trends using SQL and Tableau.
Project Goals
Identify top customers and best-selling products
Analyze monthly sales trends and city-wise performance
Monitor inventory levels to support stock decisions
What I Did
Joined Customers, Products, Sales, and Inventory tables using SQL
Used aggregations, subqueries, and CTEs to generate insights
Prepared datasets and created Tableau dashboards
Key Insights
Identified top revenue-contributing customers
Highlighted high-demand products with inventory shortages
Tools used:
SQL, Tableau 🚀 SQL & Tableau Project | Sales Analytics Dashboard
To practice real-world analytics, I built an interactive Sales Analytics Dashboard using SQL & Tableau to analyze sales performance and customer behavior.
🔹 Dataset Highlights
OrderID, CustomerID, Product, Category, Sales, Quantity, Discount, Profit, Region, OrderDate
🔹 Dashboard Coverage
• Sales overview: Total Sales, Profit & Orders
• Product performance: Top-selling products & category insights
• Monthly sales trends
🔹 Tools Used
• SQL
• Tableau
🔹 Key Insights
• A small customer segment drives most revenue
• Certain product categories consistently outperform others
• Clear seasonal sales patterns
🔹 What I Learned
• Writing efficient SQL queries for analysis
• Translating numbers into business-friendly visuals
• Designing dashboards that support data-driven decisions
