Sales Performance & Operations Dashboard (Tableau)

Project Overview

This Tableau project analyzes company sales, profitability, sales-team performance, discounting, and shipping operations through a series of interactive business dashboards.

The dashboards were designed to provide an at-a-glance view of overall company performance while allowing users to explore results by geography, time period, store, sales team, sales channel, and product category.

Business Objectives

The analysis focuses on several key business questions:

• How are sales and profit margins performing across geographic regions?

• How does performance change over time?

• Which sales channels are driving results?

• Are sales teams meeting established sales goals?

• What relationship exists between discounting and sales performance?

• Where are delays occurring in the shipping and delivery process?

• Are longer shipping times associated with particular warehouses or product categories?

Dashboard Analysis

The Tableau workbook includes analysis of:

Sales & Profitability

Sales and profit performance are evaluated across the United States, regions, states, stores, and time periods. Profit-margin calculations provide additional context beyond total sales alone.

Sales Team Performance

Sales-team results are compared with yearly sales goals to identify goal achievement and evaluate performance across teams. The analysis also examines discount activity alongside sales results.

Sales Channels

Sales are analyzed across available sales channels to identify differences in performance and trends over time.

Shipping & Delivery

Calculated shipping and delivery times are used to evaluate operational performance. Additional views examine whether shipping delays appear to be associated with particular warehouses or product categories.

Key Findings

The dashboard analysis identified several notable patterns:

• Overall company performance remained strong, with healthy annual sales and profit margins across regions.

• Sales-goal achievement improved, while also raising questions about whether established goals were appropriately calibrated.

• Sales channels demonstrated mixed performance trends.

• Higher discount levels did not necessarily correspond with higher sales.

• Sales performance remained relatively steady with limited variability.

• Shipping times were comparatively long and contributed to longer overall delivery times.

• Shipping delays did not appear to be driven by individual warehouse performance.

• Longer shipping times were not concentrated within specific product categories.

Tableau Features & Techniques

This project demonstrates the use of:

• Interactive dashboards and filters

• User-controlled parameters

• Calculated fields

• Level of Detail (LOD) expressions

• Date calculations and dynamic time-period filtering

• Geographic analysis

• Sales and profitability calculations

• Sales-goal performance metrics

• Shipping and delivery duration calculations

• Multi-dimensional business analysis across stores, regions, teams, channels, and product categories

Examples of calculated metrics developed for the project include:

• Sales

• Profit

• Profit Margin

• Shipping Days

• Delivery Days

• Sales by Team

• Profit by Team

• Sales Goal Achievement

• Discount Amount by Team

Tools

Tableau Desktop

The workbook combines sales-order data with supporting information for store locations, sales teams, and product categories to create an integrated view of company performance.

Interactive Dashboard

https://public.tableau.com/app/profile/jennifer.moore3200/viz/Jennifer_Moore_Company_9/Dashboard