关于商业智能系统原型的建议
我们的组织缺乏任何数据挖掘或分析工具，因此我试图说服他们使用 Microsoft SQL Server 2008 R2 实施商业智能解决方案。他们要求提供一个原型，以便更好地了解商业智能可以为他们做什么。
我假设原型将包含 -
- 来自关键应用程序
- 集成服务 (SSIS) 的数据子集：用于清理数据子集？
- 分析服务 (SSAS)：用于创建和维护基于该数据子集的维度模型？数据挖掘？
- 报告服务 (SSRS)：用于创建、维护和更新报告“仪表板”。
我想展示具有数据挖掘和分析功能的商业智能解决方案如何帮助他们的组织提高绩效。
由于这是我第一次这样做，因此我很重视其他人关于这个原型是否现实的建议。有人知道我可以向他们展示任何易于理解的现实生活例子吗？
Our organisation lacks any data mining or analytical tools, so I'm trying to persuade them to implement a Business Intelligence solution using Microsoft SQL Server 2008 R2. They've asked for a prototype, so they can get a better idea of what Business Intelligence can do for them.
I'm assuming that the prototype will consist of -
- A subset of data from a critical application
- Integration Services (SSIS): Used to clean the data subset?
- Analysis Services (SSAS): Used to create and maintain a dimensional model based on that data subset? Data Mining?
- Reporting Services (SSRS): Used to create, maintain and update a 'dashboard' of reports.
I want to show how a Business Intelligence solution with data mining and analytic capabilities can help their organisation perform better.
As this is the first time I've done this, I'd value advice from other people on whether this prototype is realistic or not. And does anyone know of any easily-accessible real-life examples that I can show them?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我的想法……
我们在新的 DWH 项目/试点方面遇到的最大问题（我们是一家 DWH 咨询公司，因此拥有许多客户）是获得管理支持。通常，DWH 将由 IT 人员赞助，并且没有真正的董事会级别支持，因此该项目需要很长时间才能进展，并且很难为其获取资源。
我们发现的最好的项目是在三个领域提供支持的项目：管理（董事会级别）、IT 和业务（最好是对所涉及的业务规则有深入了解的人员）。
查看Ralph Kimball 的数据仓库工具包 针对不同行业进行不同风格的 DWH 设计。这是非常好！
我希望你会使用的工具（我在这里添加了一些技术）
就技术而言，这是一个很好的原型范围（如果您来自 MS 背景），但技术的传播范围非常大，对于一个对其不感兴趣的人来说，这可能是不现实的。
最关键的是让 DWH 星型模式设计正确（并且对于任何数据集都会有许多“正确”的解决方案），否则你的 OLAP 多维数据集设计将存在缺陷并且非常难以构建。
在您建造之前，我会聘请当地的 DWH 顾问来验证您的设计。确保你给他们一个非常严格的范围，不要做太多改变，否则大多数顾问会“修补”一些东西，让他们“更好”。
祝你好运！
my thoughts …
The biggest problem we have had with new DWH projects/pilots (we are a DWH consultancy so have a number of clients) is getting management support of it. Often the DWH will be sponsored by someone in IT and there is no real board level support, so the project takes a long time to progress and it is difficult to get resources for it.
The best projects we have found are ones that have levels of support in three areas: Management (board level), IT and Business (preferably someone with good understanding of the business rules involved).
Have a look at Ralph Kimball’s Data Warehouse Toolkit which goes through different styles of DWH design for different industries. It is very good!
The tools I expect you would use (I’ve added a couple of technologies here)
This is a good prototype scope in terms of technologies (if you are from the MS background), but the spread of technologies is very large and for one person coming in cold to them, this is perhaps unrealistic.
The most critical thing is to get the DWH star schema design correct (and there will be a number of solutions that are “correct” for any set of data), otherwise your OLAP cube design will be flawed and very difficult to build.
I would get a local DWH consultant to validate your design before you have built it. Make sure you give them a very tight scope of not changing much otherwise most consultants will “tinker” with things to make them “better”.
Good Luck!
问题发布已经过去两年了，当然，商业智能领域也不断有更新。现在，我们在 Microsoft 商业智能领域拥有几个用于原型设计的出色工具：
- 电源查询（自助ETL）
- 动力枢轴。
希望这可以帮助刚刚开始构建原型的人。
It's been 2 years since the question was posted and of course, there has been updates in the world of business Intelligence. We now have couple of great tools for prototyping in the Microsoft Business Intelligence World:
- Power Query (Self Service ETL)
- Power Pivot.
Hope this helps someone just getting started w/ building prototypes.