top of page
logo

Tableau Sales Performance Dashboard

Tableau.png

1. Business Problem

The business needed a centralized dashboard to analyze sales, profit, customer behavior, shipping performance, and regional trends across multiple years.

This project was important because leadership lacked a unified view of performance across product categories, regions, segments, and shipping modes.

Requested by: Sales Leadership, Operations, and Finance

Supported decisions:

  • Regional sales strategy

  • Inventory planning

  • Shipping optimization

  • Customer segmentation

  • Profitability improvement

Document evidence: “Sales By Category — Technology 836,154; Furniture 742,000; Office Supplies 719,047.”

2. Objectives

Goals:

  • Build an interactive Tableau dashboard for sales and profit analysis

  • Improve visibility into category, region, and segment performance

  • Identify shipping inefficiencies

  • Support strategic planning with multi-year trends

KPIs Measured:

  • Sales

  • Profit

  • Quantity

  • Number of Customers

  • Number of Orders

  • Delivery Days

  • Segment Sales

  • Regional Sales

Success Definition:

  • Stakeholders can quickly identify trends and performance gaps

  • Reduced manual reporting

  • Improved decision-making speed

3. Stakeholders

  • Executive Leadership

  • Sales Managers

  • Regional Managers

  • Operations & Logistics

  • Finance Team

  • Marketing Team

4. Data Sources

Based on the dashboard structure, the project likely used:

  • Sales transaction data (SQL, Excel, or CSV)

  • Customer master data

  • Product category data

  • Shipping mode data

  • Order date tables

Document evidence: “Average Delivery Days By Ship Mode — Standard Class 4 days, First Class 2 days.”

5. Data Volume

From the dashboard:

  • 37,873 total quantity sold

  • 2,297,201 total sales

  • 286,397 total profit

  • 793 customers

  • 5,009 orders

6. Data Cleaning

Issues likely addressed:

  • Missing customer IDs

  • Incorrect or inconsistent ship mode labels

  • Standardizing product categories

  • Removing invalid dates

  • Ensuring accurate profit calculations

7. Data Transformation

Transformations performed:

  • Aggregated sales and profit by category, region, segment

  • Built calculated fields for delivery days

  • Created date hierarchies (Year → Quarter → Month)

  • Merged customer, product, and shipping datasets

  • Built KPI summary table

Document evidence: “Sales By Years and Quarters — 2017 Q4: 280,054; 2016 Q4: 236,099.”

8. Data Model

Likely a star schema:

  • Fact Table: Orders (Sales, Profit, Quantity, Date, Customer, Ship Mode, Segment, Region)

  • Dimensions: Product Category, Customer, Region, Ship Mode, Date

  • Relationships based on customer ID, product category, region, and date.

9. Analysis

Key insights discovered:

  • Technology was the top-performing category (836,154 sales).

  • West Region generated the highest sales (725,458).

  • Standard Class dominated shipping volume (1,358,216 sales).

  • Consumer Segment likely led sales (based on typical Superstore patterns).

  • Delivery time varied significantly by ship mode (Standard Class: 4 days; Same Day: 0 days).

  • Sales showed seasonal patterns across quarters and years.

10. Visualization Choices

  • Bar Charts for category and region sales → easy comparison

  • KPI Summary Table for quantity, sales, profit, customers, orders → executive overview

  • Stacked Bars for ship mode performance → channel comparison

  • Line Charts for quarterly sales → trend analysis

  • Segment charts for customer segmentation → marketing insights

  • Delivery days chart for logistics optimization

Each visual was chosen to make insights intuitive and actionable.

11. Automation

  • Tableau data refresh scheduling

  • Dynamic filters (Year, Quarter, Category, Region)

  • Real-time updates from connected data sources

  • Automated KPI calculations

12. Challenges & Solutions

Challenges:

  • Multiple segments and categories

  • Inconsistent ship mode naming

  • Multi-year data alignment

  • Need for fast, interactive visuals

Solutions:

  • Standardized product and ship mode fields

  • Built clear hierarchies for date analysis

  • Used Tableau extracts to improve performance

  • Designed intuitive dashboards for executives

13. Business Impact

  • Improved visibility into sales and profit drivers

  • Enabled regional managers to optimize strategy

  • Highlighted shipping inefficiencies

  • Supported inventory and logistics planning

  • Reduced manual reporting time

  • Improved forecasting accuracy

14. KPIs

  • Sales

  • Profit

  • Quantity

  • Number of Customers

  • Number of Orders

  • Delivery Days

  • Segment Sales

  • Regional Sales

  • Category Sales

15. Tools Used

  • Tableau

  • Excel / CSV

  • SQL (likely for source data)

  • Tableau Extracts

  • Data connectors

  • Date hierarchy tools

16. Technical Skills Demonstrated

  • Data Cleaning

  • ETL

  • Dashboard Design

  • KPI Development

  • Trend Analysis

  • Segmentation Analysis

  • Shipping Performance Analysis

  • Data Modeling

  • Visualization Best Practices

17. Lessons Learned

  • Importance of consistent category and ship mode data

  • Value of quarterly trend analysis

  • Designing dashboards for executive clarity

  • Importance of performance optimization

  • Need for clear KPI definitions

18. What Would You Improve?

  • Add forecasting for sales and profit

  • Add drill-downs for product-level insights

  • Implement row-level security for regional managers

  • Add customer lifetime value metrics

  • Enhance mobile layout

bottom of page