问题描述
当前,我的一位客户使用powerbi仪表板直接连接源SQL(从erp复制为单独的表),当前的仪表板不友好,不能满足业务需求,并且包含多个仪表板用于内部与 外部客户.
currently one of my client uses the powerbi dashboard which directly connect source SQL (copied from erp as individual tables) and current dashboards are not user friendly, not self serving to business needs and contains multiple dashboard for internal vs external customer.
要克服上述问题,并具有自助服务仪表板.我已将数据模型层作为目标,即Azure分析服务和Powerbi(仅用于可视化目的).在AAS中,我们将使用核心业务数据和子数据构建中央模型 型号用于衡量KPI指标的每个业务领域.
To overcome above issues & and to have Self Serving dashboard. i've purpose the Data model layer i.e Azure Analysis Service and Powerbi (just visualisation purpose). In AAS, we will built the central model with core business data and child data model for serving each business area with measure, KPI.
建议的解决方案正确吗?如果有任何改进,请提出建议?
is it right solution which have advised? if any improvements, please advise?
推荐答案
https://docs.microsoft.com/en-us/azure /analysis-services/analysis-services-datasource
这篇关于用于自助式仪表板的Azure Analysis Service架构设计?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!