Project Goal:

​The goal of this project was to leverage the Superstore dataset (from Kaggle) to design an interactive Tableau dashboard that allows stakeholders to explore sales performance across regions, product categories, and customer segments. The objective was to improve visibility into revenue drivers, profit margins, and geographic trends, while creating a tool that could support decision-making for sales and inventory planning.

​​

Tools Used​​:

• Tableau

• Excel

​

Solution:

• Data Preparation:

  • Cleaned and structured the Superstore dataset for Tableau integration.

  • Ensured data types, hierarchies, and calculated fields (e.g., profit ratio, average order value) were properly defined.

• Dashboard Design:

  • Created a visually intuitive multi-sheet Tableau dashboard with filters for region, product category, and order date.

  • Incorporated KPIs for total sales, total profit, and average profit ratio.

  • Used trend lines and bar charts to highlight performance by state, category, and sub-category.

• Analytics:

  • Built interactive filters and drill-down capabilities to analyze customer segments.

  • Integrated calculated fields (e.g., YoY sales growth, profit ratio %).

  • Designed heat maps and geographic visualizations to surface regional patterns.

• Storytelling:

  • Structured the dashboard around executive-level insights first (KPIs), followed by detailed operational breakdowns for managers.

  • Prioritized usability with clear labels, consistent color schemes, and KPI callouts.

​

Results:

• Delivered a dynamic Tableau dashboard accessible through Tableau Public link.

• Enabled real-time exploration of sales and profit performance across multiple dimensions.

• Highlighted profitable product segments and low-margin categories, providing actionable insights for resource allocation.

• Enhanced my abilities in transforming raw data into valuable visualizations, analytics, and storytelling.​