Item Sales
The Item Sales data model tracks sales performance at the item and product line level. It includes measures like dollars sold, cost of goods sold, quantity shipped, and quantity returned. Use it to evaluate product profitability, identify top selling items, and compare performance across product lines.
How to use this data model
- Compare sales and costs by product line to see which lines are the most profitable and which have thin margins.
- Identify top selling items by revenue or by quantity shipped to understand what sells the most.
- Track quantity returned alongside sales to spot items with high return rates.
Available views
| View | Type | What it shows |
|---|---|---|
| Top Items | Worksheet / Vertical Bar | Shows best selling items by sales volume or revenue in both worksheet and chart format. |
| Sales by Product Line | Worksheet / Vertical Bar | Breaks down sales data by product line with dollars sold, COGS, and quantities. |
| Top 10 Items by Dollars Sold | Horizontal Bar | Ranks the top 10 items by total revenue. |
| Sales by Product Line | Combination | Shows sales by product line with multiple measures overlaid for comparison. |
| Top 10 Items by Quantity Shipped | Horizontal Bar | Ranks the top 10 items by quantity shipped, showing which items have the highest demand. |
| Sales / COGS by Product Line | Combination | Compares revenue against cost of goods sold by product line to show profitability per line. |