Skip to content

Latest commit

 

History

4 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Retail-Sales-Tableau-Dashboard-ITI

Retail Sales Analysis — Tableau Project

An interactive Tableau dashboard project analyzing retail sales data across products, customers, and regions. Built as a final project for the Tableau CoursePower BI Development Track at ITI (Information Technology Institute).

🔗 View Live Dashboard on Tableau Public


📊 Dashboards Overview

1. Sales Summary Dashboard

A high-level overview of overall business performance.

  • KPIs: Total Profit ($1,166,209.31) | Total Quantity (33,769)
  • Profit by Category — 5 categories: Home Appliances, Electronics, Hardware, Office Supplies, Accessories
  • Profit by Region & Gender — Stacked bar across 5 US regions
  • Profit Trend by Month — Line chart with trend line
  • Profit by Supplier — 10 suppliers comparison
  • Geographic Map — Profit distribution across US states
  • Gender Split — Pie chart (Male 52.89% / Female 47.11%)

2. Products Analysis Dashboard

Deep dive into product and supplier performance.

  • KPIs: Number of Suppliers (10) | Number of Products (53)
  • Top N Profit Products — Dynamic horizontal bar chart (controlled by parameter)
  • Products Info by Supplier — Interactive text table with drill-down
  • Supplier Profit vs Cost — Grouped bar chart

3. Customer Analysis Dashboard

Understanding customer behavior and purchasing patterns.

  • KPIs: Number of Customers (150)
  • Top N Customers by Profit — Dynamic horizontal bar chart
  • Customer Detail Table — Name, Gender, Age, Products per Customer, Sales Count, Quantity — with drill-down
  • Profit by Age Category — Young / Adult / Mid Age / Old / Very Old
  • Profit by Weekday — Sales distribution across days of the week

⚙️ Technical Features

Feature Details
Parameters Date Level grouping, Top N filter (Products & Customers), Age Range slider
Only Relevant Values Applied on all dropdown filters for cleaner UX
Calculated Fields Age Categories, Weekday extraction, Percentage calculations
Trend Line Applied on Profit by Month chart
Dashboard Actions — Navigation Buttons to navigate between all 3 dashboards
Dashboard Actions — Drill-down Click on Supplier → shows its products with full details
Dashboard Actions — Drill-down Click on Customer → shows purchased products with full details
Hierarchy in Text Tables Supplier → Products / Customer → Purchased Products
Filled Map Geographic profit visualization by US state
Consistent Design Unified green color theme across all dashboards

📁 Dataset

  • File: Retail Data.xlsx
  • Source: Educational dataset used for learning purposes
  • Scope: Retail transactions including sales, profit, products, customers, suppliers, and regions

🛠️ Tools Used

  • Tableau Desktop / Tableau Public
  • Microsoft Excel (data source)

👤 Author

LinkedIn

Ali Elsabaa 📌 ITI Graduate — Power BI Development Track 🔗 Tableau Public Profile

About

Tableau project for retail data

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors