表格的维度建模 [英] Dimensional Modelling for Tabular

问题描述

大家好

目前为银行工作，我们使用Power BI和SSAS，以便有效地向利益相关方提供报告。

Currently work for a Bank and we using Power BI and SSAS in order to deliver reporting efficiently to stakeholders.

我的表格式设计方法是介绍Ralph Kimball的方法，并希望你分享一下这个最佳实践的想法吗？

My approach for tabular design was to introduce to Ralph Kimball methodology and would like you to share your thoughts around this being best practice?

有一些要求可能是非常少量的数据要处理，一个简单的sql视图就足够了吗？

Also there are some requirements that might be very small amount data to process, would a simple sql view suffice?

谢谢

推荐答案

嗨  VilenVmo，

Hi  VilenVmo,

对于Tabular，它没有维度，它使用表及其关系。您可以参考表格建模
详细信息。

For Tabular , there is no dimension in it, it use table and its relationship. You could refer to Tabular Modeling for details.

如果您想提高效果，可以尝试参考  Microsoft SQL Server Analysis Services（SSAS）表格最佳实践了解详细信息。

And if you want to improve performance , you could try to refer to Microsoft SQL Server Analysis Services (SSAS) Tabular Best Practices for details.

最诚挚的问候，

Zoe Zhi

这篇关于表格的维度建模的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！