提供如何准备 BI 报告信息的方法/现有系统/研究工作是什么?
我正在寻找信息,哪些方法或现有系统可以让 BI 系统的最终用户了解报告中的数据是如何准备/处理的。就我而言,高级 BI 用户希望了解哪些数据库集成在 ETL 流程中(可能遗漏了某些内容)或应用了信息质量过滤器(可能导致丢失重要数据)。我的目标是了解在现实世界场景中部署的最佳解决方案。
I am looking for information what are approaches or existing systems that let an end user of a BI system to have insight how data in the report was prepared/processed. In my case, an advanced BI user would like to know, e.g., an insight which databases were integrated in a ETL process (maybe something was missed) or Information Quality filter applied (could cause loosing important data). My aim is to learn about solutions -- the best -- deployed in a real world scenario.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
我将您的问题理解为“我们如何向用户展示我们显示的数字背后的故事/业务规则”。
如果我是对的,您也许可以允许用户使用构建的摘要数据来深入了解详细数据。在大多数情况下,这可能非常困难,因为当时是数据+业务逻辑。因此,最好的选择是开始在报告中显示业务规则(报告规范?)。对于汇总信息的关键业务报告,您也可以将详细报告作为子报告(并尽可能提及应用的任何业务规则)
I read your question as "How can we show the users the story / business rules behind the numbers we show".
If I am right, you may be able to allow the users to drill down the detail data using which summary data is built. It can be very difficult in most cases since it is data + business logic at that point in time. So the best bet would be start showing the business rules in the reports (the report specifications?). For business critical reports which summarise information, you can have detail reports as a subreport as well (and also mention any business rules applied as much as possible)