p/data-mining-adventureworksdw/

[giscus[bot]]

p/data-mining-adventureworksdw/

准备工作 AdventureWork各种版本下载链接：\n此操作数据库版本为：2014版本。\n切片操作 进行切片操作切片。选择地点维、产品维和时间维查看2012年3月份的销售额\n1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 SELECT DimProduct.EnglishProductName AS 产品名称, DimSalesTerritory.SalesTerritoryRegion AS 产品地区, MONTH(FactInternetSales.OrderDate) AS 月份, SUM(FactInternetSales.SalesAmount) AS 销售额 FROM DimProduct, DimSalesTerritory, FactInternetSales WHERE DimProduct.ProductKey = FactInternetSales.ProductKey AND DimSalesTerritory.SalesTerritoryKey = FactInternetSales.SalesTerritoryKey AND MONTH(FactInternetSales.OrderDate) = 3 AND YEAR(FactInternetSales.OrderDate) = 2012 GROUP BY DimProduct.EnglishProductName, DimSalesTerritory.SalesTerritoryRegion, MONTH(FactInternetSales.OrderDate);

https://blog.debuginn.com/p/data-mining-adventureworksdw/