用于分析型 CRM 的数据仓库
从数据仓库中提取数据用于分析 CRM 应用程序是否有益，或者应该从源系统中提取数据而不需要数据仓库？？...请帮我回答...
Is it beneficial to pull the data from Datawarehouse for analytical CRM application or it should be pulled from the source systems without the need of Datawarehouse??....Please help me answering.....
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
对于 CRM，最好从数据仓库获取数据。使用各种 ETL 工具根据业务需求开发数据转换，使用此转换，您可以集成 CRM 分析来分析大量数据。
For CRM it is better to fetch the data from datawarehouse. Where a data transformations developed according to the buiness needs using various ETL tools, using this transofrmations you can integrate the CRM analytics for analysing the large chunk of data.
我想答案取决于几个因素：
如果您需要访问多个源系统的数据，那么您将必须进行加入他们之间的数据。从 DWH 获取数据的一大优势是，它们往往从多个源系统获取数据，并且在这些源系统之间建立良好的连接，并在这些系统之间一致应用业务规则。
数据仓库应该具有最低粒度的数据，但有时，出于实用原因，可能会做出部分汇总数据的决定，因此您可能没有适当的粒度。
DWH 的一大优点是它是一个简单的维度模型结构（无论如何对于 Kimball 星型模式），因此只要前两个为真，我总是会从 DWH 获取数据。
克/升！
I guess the answer will lie in a few factors
If you need data that you will need to access more than one source system, then you will have to do the joining of that data between them. One big strength of getting the data from a DWH, is that they tend to have data from a number of source systems and are well connected across these source systems with busienss rules being applied consistently across them.
A datawarehouse should have lowest granularity data, but sometimes, for pragmatic reasons, decisions may have been taken to partly summarise the data, thus you may not have the approproate granularity.
The big advantage of a DWH is that it is a simle dimensional model structure (for a kimball star schema any how), so as long as the first two are true, I would always get my data from the DWH.
g/l!
分享我对从数据仓库而不是直接从 CRM 系统提取的业务案例的想法是 -
与 CRM 这样的单一系统相比，DWH 可以在各种系统中保存更多用于企业级决策和分析的指标。因此，如果您想进一步分析 CRM 数据，您可以轻松合并来自其他系统的信息，以便从 DWH 执行更好的分析/BI。
如果您想实现跨系统的一致性，以便通过单一视图查看客户数据。例如，您可以从 CRM 获取管道和销售信息，然后在另一个系统中为同一客户执行收入计算。您可能希望将两组详细信息放在一个位置，并将相同的客户记录链接到这两个度量。然后您可能希望将外部源的风险（信用信息）添加到 DWH 中的同一记录中。它在报告和临时请求方面带来了真正的可扩展性。
删除非核心工作，并将 CRM 生产系统与 BI 和报告分离（不是谈论特定的 CRM 报告）。这在操作和便利性方面都具有多种优势。您可以更多地搜索这个主题以了解其好处。
目前我能想到的只有这些。稍后我会尝试添加更多想法。
PS：我很高兴得到纠正:-)
Sharing my thoughts on business case to pull from datawarehouse rather than directly from CRM system would be -
DWH can hold lot more indicators for Decision making and analysis at enterprise level across various systems than a single system like CRM. Therefore if you want to further your analysis on CRM data you can merge easily information from other system to perform better analytics/BI from DWH.
If you want to bring conformity across systems for seeing data of customer with single view. For example, you can have pipeline and sales information from CRM and then perform revenue calculation in another system for the same customer. Its possible that you want both sets of details in single place with same customer record linked to both measures.Then you might want to add Risk (Credit information) from external source into the same record in DWH. It brings true scability in terms of reporting and adhoc requests.
Remove the non-core work and dettach the CRM production system from BI and reporting (not talking of specific CRM reports). This has various advantages both terms of operations and convinence. You can google on this subject more to understand the benefits.
For now these are the only points that come to me. I will try adding more thoughts later.
P.S: I am more than happy to be corrected :-)