SELECT
    product_category,
    SUM(total_price) as total_sales
FROM analytics.fact_sales
GROUP BY product_category
ORDER BY total_sales DESC

SELECT
    order_day,
    SUM(total_price) as total_sales
FROM analytics.fact_sales
GROUP BY order_day
ORDER BY order_day

SELECT
    product_name,
    SUM(total_price) as total_sales
FROM analytics.fact_sales
GROUP BY product_name
ORDER BY total_sales DESC
LIMIT 10

Sales Dashboard

Sales Overview

<BigValue data={sales_by_category} value={”$” + d3.format(”,”)(d3.sum(sales_by_category, d ⇒ d.total_sales))} title=“Total Sales” />

Sales by Category

Daily Sales Trend

Top Products by Sales