Skip to content

This repository showcases Superstore Analytics report developed with Tableau, demonstrating expertise in data visualization.

Notifications You must be signed in to change notification settings

ASHARANI-MG/Superstore-Analytics-Report

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

20 Commits
Β 
Β 
Β 
Β 

Repository files navigation

Superstore Analytics report - Tableau

This project is an interactive Superstore Analytics report built using Tableau, designed to analyze and visualize the sales performance of a retail business using the Sample Superstore dataset.

πŸš€ Project Overview

The dashboard provides insights into key business metrics such as Sales, Profit Margin, and Return Rate. It allows users to interactively explore the data by selecting different metrics, regions, and years.

🎯 Key Features

  • βœ… Dynamic KPI Cards β€” Display Sales, Profit Margin, and Return Rate with customized number formatting.
  • βœ… Metric Parameter Selector β€” Switch between Sales, Profit, and Number of Orders dynamically across all charts.
  • βœ… Interactive Filter Panel β€” Includes Region and Year filters with a Show/Hide Toggle Button for a cleaner user experience.
  • βœ… Top 5 Products Table β€” Automatically updates based on the selected metric using Rank functions.
  • βœ… Filter Actions β€” Clicking on the Category chart dynamically filters all other charts and KPI cards.
  • βœ… Clean and Consistent UI β€” Custom color palettes, background themes, and proper alignment for a professional look.

πŸ“Š Visualizations Included

  • πŸ“ˆ Sales Trend Line Chart (with average and trend lines)
  • πŸ—ΊοΈ Sales by State Map (colored based on metric)
  • πŸ† Top 5 Products Table
  • πŸ“¦ Sales by Category (with filter actions)
  • πŸͺ‘ Sales by Sub-Category
  • 🎯 Sales by Segment (Donut Chart)

🧠 Metrics Calculated

  • Sales: Total revenue generated from orders.
  • Profit Margin: (Total Profit / Total Sales) * 100
  • Return Rate: (Number of Returned Orders / Total Orders) * 100

πŸ”— Dataset

  • Sample Superstore Dataset (default dataset provided by Tableau)

πŸ› οΈ Tools Used

  • Tableau Desktop

πŸ“₯ Installation / Usage

  1. Download or clone this repository.
  2. Open the .twbx Tableau workbook file using Tableau Desktop.
  3. Ensure the Sample Superstore dataset is correctly connected.
  4. Explore the dashboard and interact with filters and metrics.

πŸ“Έ Dashboard

Dashboard Screenshot

πŸ“œ License

This project is for educational and portfolio purposes only.


✨ Created By

Asharani M G
πŸ”— GitHub Profile
πŸ“§ ashaa12gowda@gmail.com
πŸ’Ό LinkedIn

About

This repository showcases Superstore Analytics report developed with Tableau, demonstrating expertise in data visualization.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published