Analyzed the Tableau Sample Superstore dataset to evaluate sales performance, profitability, discount impact, and customer segmentation. Performed data preprocessing in Excel and built interactive dashboards in Tableau to generate actionable business insights.
~Microsoft Excel (Data Cleaning, Pivot Tables, Preprocessing, Dashboard)
~Tableau (Dashboard Development & Data Visualization)
~Calculated Fields
~Filters, Parameters & Drill-down Analysis
~KPI Metrics Design
~Regional Sales & Profit Analysis
~Category and Sub-Category Performance
~Segment-wise Revenue Comparison
~Discount vs Profit Impact Analysis
~Time-Series Trend Analysis (Monthly & Yearly)
~High discount rates significantly reduce profit margins
~Some sub-categories generate high revenue but low profitability
~Consumer segment contributes the highest overall sales
~Regional performance shows variation in profit ratios
Data Analysis | Tableau | Excel | Data Cleaning | Pivot Tables | Dashboard Design | Business Intelligence | KPI Development | Analytical Thinking