数据仓库：订单，销售和收入事实 [英] Data warehouse: Orders, Sales and Revenue facts

问题描述

我需要有关如何从多个事实表中呈现或报告的帮助：



1.订单（已订购所有商品）

1.销售（已售出所有商品，跨越多年）

2.收入（来自当年销售商品的收入）



如您所见，销售额<>收入金额。

我们已将事实分开，因为它们针对不同的部门，但也有不同的尺寸和其他原因。


I我被问到这样的问题：我们想知道订购了多少，销售了多少，以及支付了多少销售额（收入）......



所以我不确定是否应该根据事实创建一个视图？

是这类场景的累积事实？

这类问题的最佳解决方案是什么？



我正在使用Microsoft BI堆栈。所以我想在表格模型中建模。



谢谢，

Bin Sheikh

I need help on how to present or report from multiple fact tables:

1. Orders (has all items that were ordered)
1. Sales (has all sold items, spanning multiple years)
2. Revenue (has revenue from items sold in current year)

As you can see Sales amount <> Revenue amount.
We have separated the facts because they are for different departments but also they have different dimensions, and other reasons.

I am being asked questions like "... we want to know how much was ordered, how much sold, and how much of the sales were paid (revenue)..."

So I am not sure if I should create a view on top of the facts?
is the accumulating fact for this type of scenario?
what is the best solution to this type of question?

I am using Microsoft BI stack. So I would like to model in tabular model.

Thank you,
Bin Sheikh

推荐答案

根据你的数据量，你可以决定。



如果它更少，你可以在此基础上创建视图并获得总和与维度相对应的订单，销售和收入。



或者，您可以创建表格模型。

Based on your data volume, you can decide.

if it is less, you can create view on top of this and have the total sum of order, sale and revenue corresponding to dimensions.

or, you can create tabular model.

这篇关于数据仓库：订单，销售和收入事实的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！