Performance Point，仪表板设计师
- 我对这个产品是全新的。 微软有一些不错的免费视频...但我正在寻找一个可以提出有关“如何做”的问题或发布问题的网站...有什么建议吗？
(http://www.microsoft.com/business/performancepoint/resources/training .aspx）
- 以防万一这是一个很好的网站...
我想将 sql 表引入仪表板设计器，并根据 12 个部门的 83 个运营指标生成记分卡...我有一个简单表架构：
key、metric_ID、value1、value2、value3、value4、value5、CalendarWeek、Year、Entered、Updated）
我有 sql 作业爬行到多个数据库并每周写回基础数据。 我的想法是让仪表板设计者根据指标需求生成实际指标。
例如。 对于热线性能，在第一次呼叫时关闭呼叫，在收到的呼叫中： (45, 16, 786, 1345,null,null,null,1,2009, 1/5/2009 6am, null)
786/1345 = 58%，运营目标为 50% .. 因此 kpi 将为绿色。
我的问题是；
当我使用表格向导创建记分卡时，我只是得到一个将字段列为行的记分卡（786、1345、空白、空白、空白）； 以 Actual 和 Target 作为列...我如何计算指标？...或者我是否需要扩展我的 sql 表以实际执行指标的数学运算？...
我不太清楚尚未了解维度的概念...维度是输入和更新日期...不完全是我需要的...我认为...
所以...我如何构建我的sql表以引入这些指标，以及如何为仪表板设计器“尺寸”连接器进行公制计算？
- I am brand new to this product. Microsoft has some good free videos...but I am looking for a site where I can ask question about 'how to', or post problems..any recommendations?
(http://www.microsoft.com/business/performancepoint/resources/training.aspx)
- Just in case this is a good site for that...
I want to bring in a sql table to dashboard designer, and produce a scorecard based on 83 operational metrics across 12 divisions... I have a simple table schema:
key, metric_ID, value1, value2, value3, value4, value5, CalendarWeek, Year, Entered, Updated)
I have sql jobs that crawl to multiple databases and write back the base data weekly. The idea is that I would let the dashboard designer produce the actual metric, based on the metric needs.
eg. for hotline performance closed calls on the first call, over calls received:
(45, 16, 786, 1345,null,null,null,1,2009, 1/5/2009 6am, null)
786/1345 = 58% against an operational target of 50% .. so the kpi would be green.
my problem is;
when I create a scorecard using the tabluar wizard, I just get a scorecard listing the fields as rows (786, 1345, blank, blank, blank); with Actual and Target as the columns... how do I do the calculation of the metric?..or do I need to expand my sql table to actually DO the math for the metric??...
I dont quite get the concept of dimensionality yet...the dimensions are the Entered and Updated dates...not quite what I need..i think...
soo...how do I structure my sql table to bring in these metrics, and how do I 'dimension' the connector for dashboard designer to do the metric calculation?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我会在你的数据库端进行计算。 然后很简单，只需将计算出的值拉入仪表板即可。 仪表板设计器并不擅长进行计算（除了总和、平均值等普通聚合之外）。
I would do the calculation on your database side. Then it's simple to just pull the caculated value into the dashboard. Dashboard Designer isn't the best at doing calculations (beyond normal aggregations like sum, average, etc).