数据仓库与数据挖掘分析.doc
Adventure Works分销商销售数据分析-Womens Tights一、概述Womens Tights型号共三种产品,分别为“Womens Tights,L”、“omens Tights,M”和“omens Tights,S”。这三种商品在拿大、法国和英国均有销售。在Adventure WorksDW数据库中查询得知三种产品的总销售额如下:表 1 三种商品销量对比English Product NameSales AmountWomens Tights, L$93,554.46Womens Tights, M$17,727.64Womens Tights, S$90,550.91总计$201,833.01 查询命令为:SELECT DimProduct.EnglishProductName AS 产品, SUM(FactResellerSales.SalesAmount) AS 销售额FROM DimProduct INNER JOIN FactResellerSales ON DimProduct.ProductKey = FactResellerSales.ProductKeyGROUP BY DimProduct.EnglishProductName, DimProduct.ModelNameHAVING (DimP
《数据仓库与数据挖掘分析.doc》由会员分享,可在线阅读,更多相关《数据仓库与数据挖掘分析.doc(6页范文模板文档)》请在优智文库上查找。