NORTHSTAR GOODS Sales & Return Analysis

An interactive Tableau dashboard analyzing sales performance, customer segments, marketing channels, discounts, and product returns to inform a $2,500 fall marketing budget.

Deliverables
Interactive dashboard, sales analysis, responsive data visualization

Role
Data Visualization Designer & Analyst

BUSINESS QUESTION

“How should Northstar Goods allocate its $2,500 fall marketing budget to increase net sales while avoiding channels, offers, or customer groups with high return rates?”

DATA & APPROACH

180 synthetic sales records, April–September 2026, cleaned/prepared in Excel and analyzed in Tableau. Measures included net revenue, AOV, units/order, and return rate; dimensions included channel, product, age group, customer type, region, and offer type.

INTERACTIVE DASHBOARD

Explore on Tableau Public →

Key FINDINGS

Farmers Market led channels at $1,901.80 net revenue, $52.83 AOV, and 1.50 units/order, while Instagram Ads had the highest return rate at 11.1%.

RECOMMENDATION

Based on April–September performance, prioritize Farmers Market, target the strongest-performing customer segments, reduce investment in Instagram Ads, and test more selective discounting.

Process / Technical Implementation

Excel → calculated fields → parameters → dynamic Tableau views → desktop/mobile layouts → publishing.

↑Back to Top