Turn your data into clear decisions, 365 days a year.

Revenue vs. target

Customer growth by region

Top product categories

Behind the visuals

SELECT  FORMAT(o.OrderDate, 'yyyy-MM') AS [Month],
        SUM(o.TotalDue)               AS Revenue,
        MAX(t.TargetAmount)           AS Target
FROM    Sales.Orders AS o
JOIN    Sales.MonthlyTargets AS t
        ON t.MonthStart = DATEFROMPARTS(YEAR(o.OrderDate), MONTH(o.OrderDate), 1)
WHERE   o.OrderDate >= DATEADD(MONTH, -12, GETDATE())
GROUP BY FORMAT(o.OrderDate, 'yyyy-MM')
ORDER BY [Month];