← Festus Udealor · portfolio

— brings in — of revenue in this view, and the business keeps — of every sales dollar as profit.

Revenue
Profit
Profit margin
Orders
Customers
Avg order value

Pick a year to compare it with the year before. Sparklines show each month in view.

How are sales moving month by month?

RevenueProfit

Which categories make the money?

Revenue by category. Click a bar to filter the page.

Where are our customers?

Revenue by customer country. Click a bar to filter.

Who buys from us?

Revenue by age group

Revenue by gender

Top 10 products by profit

Click a row to focus the whole page on that product.

#ProductCategoryRevenueProfitMargin
What the numbers mean

Revenue is quantity times net price, converted to US dollars at each order's exchange rate. Profit is revenue minus product cost (quantity times unit cost), so it is gross profit before staff, rent and other running costs. Margin is profit divided by revenue. Orders and customers are counted once each, however many lines they hold. Average order value is revenue divided by orders. Data runs to 20 April 2024, so 2024 is a part year.

FODesigned by Festus Onyeka Data: Contoso sample database (PostgreSQL)