The dashboard allows users to select a channel to view its performance details. Net sales of each channel is broken down by collections, by geographical locations and also by months for comparison purposes – in this case, the Basic collection stands out as the best-seller of all in all channels and B2C sales brought in by Amazon and eBay have been increasing steadily in the chosen period.
|Goals||Questions to ask||Dashboard views|
|Understand customer’s purchasing habits||What channels do B2C customers prefer to buy from the most? What regions from which B2B customers spend the most on our products?||B2C Channel – $ Net Sales B2B Channel – Avg Spend per month|
|Inventory and marketing planning||Which product has brought in most sales yesterday by units and values?||Top Product (Units)|
Top Product (Dollar)
|Assess collections’ popularity||What collections are the best sellers in each channel?||$ Net Sales by Collections|
|Track channels’ sales over periods||How have B2B and B2C net sales advanced in the last month, last 3 months and last 6 months?||Rolling Sales|
Rolling sales: Rolling sales over a period is the total sales amount in that period. As the sales of a period “rolls” forward each month, the amount from the latest month is added.