SELECT
 DATEPART(MONTH, OrderDate) AS Month,
 SUM(TotalDue) AS TotalSales
FROM
 AdventureWorks2019.Sales.SalesOrderHeader
WHERE
 DATEPART(YEAR, OrderDate) = 2019
GROUP BY
 DATEPART(MONTH, OrderDate)
ORDER BY
 Month;

SELECT
 C.CustomerType,
 COUNT(O.SalesOrderID) AS OrderCount,
 SUM(O.TotalDue) AS TotalRevenue
FROM
 AdventureWorks2019.Sales.SalesOrderHeader O
JOIN
 AdventureWorks2019.Sales.Customer C
 ON O.CustomerID = C.CustomerID
GROUP BY
 C.CustomerType;

SELECT TOP 10
 P.Name AS ProductName,
 SUM(D.LineTotal) AS TotalRevenue,
 SUM(D.OrderQty) AS TotalQuantitySold
FROM
 AdventureWorks2019.Sales.SalesOrderDetail D
JOIN
 AdventureWorks2019.Production.Product P
 ON D.ProductID = P.ProductID
GROUP BY
 P.Name
ORDER BY
 TotalRevenue DESC;

SELECT
 P.Name AS ProductName,
 AVG(PR.Rating) AS AvgRating,
 COUNT(PR.ReviewID) AS TotalReviews
FROM
 AdventureWorks2019.Production.Product P
LEFT JOIN
 AdventureWorks2019.Production.ProductReview PR
 ON P.ProductID = PR.ProductID
GROUP BY
 P.Name;

SELECT
 C.FirstName + ‘ ‘ + C.LastName AS CustomerName,
 COUNT(O.SalesOrderID) AS TotalOrders,
 SUM(O.TotalDue) AS TotalSpent
FROM
 AdventureWorks2019.Sales.SalesOrderHeader O
JOIN
 AdventureWorks2019.Sales.Customer C
 ON O.CustomerID = C.CustomerID
GROUP BY
 C.FirstName, C.LastName
HAVING
 COUNT(O.SalesOrderID) > 1
ORDER BY
 TotalSpent DESC;

SELECT
 CASE
 WHEN Age >= 18 AND Age <= 30 THEN ‘18–30’
 WHEN Age > 30 AND Age <= 45 THEN ‘31–45’
 WHEN Age > 45 AND Age <= 60 THEN ‘46–60’
 ELSE ‘Above 60’
 END AS AgeGroup,
 COUNT(*) AS TotalCustomers,
 SUM(O.TotalDue) AS TotalRevenue
FROM
 (
 SELECT
 CustomerID,
 DATEDIFF(YEAR, BirthDate, GETDATE()) AS Age
 FROM
 AdventureWorks2019.Sales.Customer
 ) C
JOIN
 AdventureWorks2019.Sales.SalesOrderHeader O
 ON C.CustomerID = O.CustomerID
GROUP BY
 AgeGroup
ORDER BY
 AgeGroup;

Power BI Dashboard Analysis Summary