Project #4: Tableau Dashboard Report

Project Overview

This report describes the Tableau dashboard and story points created for Project #4. The dashboard was built using the Sample Superstore dataset and focuses on sales, profit, product categories, customer segments, and geographic performance.

The purpose of the dashboard is to tell a clear business story about which parts of the Superstore business are performing well and which areas may need improvement. The final report embeds the Tableau Public dashboard and five Tableau Public story points so that readers can interact with the visualizations directly from the HTML report.

a. Narrative of the Story

The main story of this dashboard is that high sales do not always lead to high profit. A business can generate strong revenue while still losing money in certain product categories, sub-categories, customer segments, or geographic areas. Because of this, managers should evaluate both sales and profitability before making decisions.

The dashboard begins by showing sales performance across product categories and sub-categories. This helps identify which product groups generate the most revenue. However, by also comparing those product groups by profit, the dashboard shows whether revenue is actually creating business value.

The scatter plot expands the story by showing the relationship between sales and profit. This chart helps identify outliers, especially product groups or customer segments with high sales but low or negative profit. These cases may point to problems such as excessive discounting, high shipping costs, or inefficient pricing strategies.

The histogram shows the distribution of order-level sales. This helps explain whether total revenue is driven by many small transactions or by a smaller number of large orders. Understanding the distribution of sales is useful because extreme values can influence overall business results.

The map adds a geographic perspective by showing sales or profit by state and region. This makes it easier to identify areas where the company performs well and areas where profit may be weaker. Regional differences may reflect customer demand, shipping costs, product preferences, or discounting patterns.

Finally, the customer segment chart shows which customer groups contribute the largest share of sales. This helps managers understand whether Consumer, Corporate, or Home Office customers are driving business performance.

Overall, the dashboard tells a practical business story: Superstore should not focus only on increasing sales. It should focus on profitable growth by identifying strong product groups, improving weak regions, and managing customer segments more strategically.

b. Data Sources and Description

The data source used for this dashboard is the Sample Superstore dataset. This dataset contains retail order information, including product details, customer segments, geographic information, sales, profit, discounts, and shipping information.

The dataset is appropriate for this project because it contains both numerical and categorical variables. This allows the dashboard to include the required chart types, including histograms, scatter plots, bar charts, maps, and pie or bubble charts.

Numerical Variables

The main numerical variables used in the dashboard include:

• Sales: Revenue generated from each order.
• Profit: Profit or loss associated with each order.
• Quantity: Number of items purchased.
• Discount: Discount applied to the order.

Categorical Variables

The main categorical variables used in the dashboard include:

• Category: Broad product group, such as Furniture, Office Supplies, or Technology.
• Sub-Category: More specific product grouping within each category.
• Region: Geographic region where the order occurred.
• State: State where the customer is located.
• Segment: Customer segment, such as Consumer, Corporate, or Home Office.
• Ship Mode: Shipping method used for the order.

Dashboard Charts

Chart 1: Sales by Category and Sub-Category

Chart type: Bar chart
Variables used: Category, Sub-Category, Sales, Profit

This chart identifies which product groups generate the highest sales and whether those product groups are also profitable. It helps show that high sales do not always guarantee high profit.

Chart 2: Profit vs. Sales Scatter Plot

Chart type: Scatter plot
Variables used: Sales, Profit, Category, Segment

This chart shows the relationship between revenue and profitability. It is useful for identifying outliers, especially areas with high sales but low or negative profit.

Chart 3: Sales Distribution Histogram

Chart type: Histogram
Variables used: Sales

This chart shows the distribution of order-level sales. It helps explain whether most purchases are small, medium, or large.

Chart 4: Sales or Profit by Region

Chart type: Map or filled map
Variables used: State, Region, Sales, Profit

This chart shows geographic performance patterns and helps identify which states or regions generate strong profit and which areas may need improvement.

Chart 5: Segment Share of Sales

Chart type: Pie chart or packed bubble chart
Variables used: Segment, Sales

This chart shows which customer segments contribute the largest share of sales.

Interactivity and Filters

The dashboard includes interactive filters that allow users to explore the data more deeply. The filters include:

• Region
• Category
• Segment
• Order Date
• Ship Mode

The most important global filter is Region, because it allows users to compare performance across geographic markets. The dashboard applies filters across the connected worksheets so that changing one filter updates the charts together. This creates a reactive dashboard where users can explore product, customer, and geographic patterns together.

c. Embedding Tableau Dashboard and Story Points to the Report

Embedded Tableau Public Dashboard

Open the Tableau Public Dashboard

Embedded Tableau Public Story Points

Story Point 1: Overall Business Performance

This story point introduces the overall purpose of the dashboard. It provides a high-level view of Superstore performance and frames the central business question: which parts of the company are generating strong sales and which areas are producing weaker profitability?

Open Story Point 1

Story Point 2: Product Performance

This story point focuses on product category and sub-category performance. It explains which product groups generate the most sales and whether those products are also profitable.

Open Story Point 2

Story Point 3: Sales vs. Profit Relationship

This story point examines the relationship between sales and profit. The scatter plot helps identify whether higher sales generally lead to higher profit and highlights possible outliers.

Open Story Point 3

Story Point 4: Geographic Performance

This story point adds a regional perspective to the dashboard. By comparing sales and profit across states or regions, the viewer can see where Superstore performs strongest and where profitability may be weaker.

Open Story Point 4

Story Point 5: Customer Segment Insights and Recommendations

This final story point summarizes the dashboard findings and connects them to business recommendations. It focuses on customer segments and explains how Superstore can use the dashboard to make better decisions.

Open Story Point 5

Recommendations

Based on the dashboard and story points, Superstore managers should consider the following actions:

1. Focus on product sub-categories that generate both strong sales and strong profit.
2. Investigate sub-categories with high sales but weak or negative profit.
3. Review discounting practices in low-profit product groups.
4. Compare regional performance to identify markets that need improvement.
5. Use customer segment insights to target the most valuable customer groups.
6. Monitor profit ratio alongside total sales to avoid pursuing revenue growth that does not improve profitability.

Conclusion

The Tableau dashboard provides a clear and interactive view of Superstore performance. It shows that sales, profit, product category, region, and customer segment must be analyzed together to make strong business decisions. The dashboard supports the project goal by combining multiple chart types into one interconnected visual story.

The most important conclusion is that profitable growth matters more than sales growth alone. By using filters, dashboards, and story points, viewers can identify where Superstore is performing well, where it is losing profit, and where management should focus future improvement efforts.