数据仓库示例??? [英] DATA WAREHOUSE EXAMPLES???

问题描述

嘿，有人可以帮我，我正在做一个关于数据仓库的大学工作。

hey someone can help me, im doing a university work about data warehouse.

你能给出数据仓库的例子吗？ ？

can you give examples of data warehouse?

推荐答案

数据仓库旨在帮助您分析数据。

Data Warehouse are designed to help you analyze data.

示例：要了解您公司的销售数据，您可以建立一个专注于销售的仓库。使用此仓库，您可以回答诸如"去年该项目的最佳客户是谁"等问题。

Examples: To learn about your company sales data you can build a warehouse that concentrates on sales. Using this warehouse, you can answer questions like "Who was our best customer for this item last year"

另一个例子可能是："查找上个月所有客户的总销售额/年，检索任何特定月份的销售额"

Another eaample could be: "Find the total sales for all customers last month/year, Retrieve any perticular months sale"

此外，销售交易可以分解为事实，例如订购的产品数量和产品支付的价格，以及订单等维度日期，客户名称，产品编号等。

Also, a sales transaction can be broken up into facts such as number of products ordered and the price paid for the products, and into demensions such as order date, customer name, product number etc.

这篇关于数据仓库示例???的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！