Microsoft Office 集成 - 在某些情况下，会使用 BI 平台 作为中间层来管理、保护和 执行 BI 任务，但 Microsoft Office （特别是 Excel）充当 BI 客户。 在这些情况下，至关重要 BI 供应商提供的 与微软Office集成， 包括对文档的支持 格式、公式、数据“刷新”和 数据透视表。 高级集成 包括单元锁定和写回。
BI != Reporting. BI platforms enable users to build applications that help organizations learn and understand their business. Gartner defines a BI platform as a software platform that delivers the following 12 capabilities:
Integration
BI infrastructure — All tools in the platform should use the same security, metadata, administration, portal integration, object model and query engine, and should share the same look and feel.
Metadata management — This is arguably the most important of the 12 capabilities. Not only should all tools leverage the same metadata, but the offering should provide a robust way to search, capture, store, reuse and publish metadata objects such as dimensions, hierarchies, measures, performance metrics and report layout objects.
Development — The BI platform should provide a set of programmatic development tools — coupled with a software developer's kit for creating BI applications — that can be integrated into a business process, and/or embedded in another application. The BI platform should also enable developers to build BI applications without coding by using wizard-like components for a graphical assembly process. The development environment should also support Web services in performing common tasks such as scheduling, delivering, administering and managing.
Workflow and collaboration — This capability enables BI users to share and discuss information via public folders and discussion threads. In addition, the BI application can assign and track events or tasks allotted to specific users, based on pre-defined business rules. Often, this capability is delivered by integrating with a separate portal or workflow tool.
Information Delivery
Reporting — Reporting provides the ability to create formatted and interactive reports with highly scalable distribution and scheduling capabilities. In addition, BI platform vendors should handle a wide array of reporting styles (for example, financial, operational and performance dashboards).
Dashboards — This subset of reporting includes the ability to publish formal, Web-based reports with intuitive displays of information, including dials, gauges and traffic lights. These displays indicate the state of the performance metric, compared with a goal or target value. Increasingly, dashboards are used to disseminate real-time data from operational applications.
Ad hoc query — This capability, also known as self-service reporting, enables users to ask their own questions of the data, without relying on IT to create a report. In particular, the tools must have a robust semantic layer to allow users to navigate available data sources. In addition, these tools should offer query governance and auditing capabilities to ensure that queries perform well.
Microsoft Office integration — In some cases, BI platforms are used as a middle tier to manage, secure and execute BI tasks, but Microsoft Office (particularly Excel) acts as the BI client. In these cases, it is vital that the BI vendor provides integration with Microsoft Office, including support for document formats, formulas, data "refresh" and pivot tables. Advanced integration includes cell locking and write-back.
Analysis
OLAP — This enables end users to analyze data with extremely fast query and calculation performance, enabling a style of analysis known as "slicing and dicing." This capability could span a variety of storage architectures such as relational, multidimensional and in-memory.
Advanced visualization — This provides the ability to display numerous aspects of the data more efficiently by using interactive pictures and charts, instead of rows and columns. Over time, advanced visualization will go beyond just slicing and dicing data to include more process-driven BI projects, allowing all stakeholders to better understand the workflow through a visual representation.
Predictive modeling and data mining — This capability enables organizations to classify categorical variables and estimate continuous variables using advanced mathematical techniques.
Scorecards — These take the metrics displayed in a dashboard a step further by applying them to a strategy map that aligns key performance indicators to a strategic objective. Scorecard metrics should be linked to related reports and information in order to do further analysis. A scorecard implies the use of a performance management methodology such as Six Sigma or a balanced scorecard framework.
Business intelligence (BI) refers to skills, technologies, applications and practices used to help a business acquire a better understanding of its commercial context. Business intelligence may also refer to the collected information itself.
BI technologies provide historical, current, and predictive views of business operations. Common functions of business intelligence technologies are reporting, OLAP, analytics, data mining, business performance management, benchmarks, text mining, and predictive analytics.
Business intelligence often aims to support better business decision-making. Thus a BI system can be called a decision support system (DSS).
Personal experience
After having worked for 7 years in a BI software product in the past, I don't think it's an empty buzzword. Go to a supermarket business and ask them how they know how much cheese they put in their store; where they put it; and which brands. Go to a sausage producer: they had our product analyze sells based on lots of variables, for example, which kind of display they got in the supermarket: ordinary, more relevant, hard to spot. They decided which variables were relevant to them and thus should be analyzed. Go to a package sending company and ask them which services they promote and why. They all analyze all their data and they use software for that. Of course you need a brain as well as software; but, alas, you need software as well as a brain.
It may be a wide, open term, yes. But it's not an empty term.
In more practical terms, anything which pays your bills for 7 years is not empty :-)
我只能代表 Cognos，它是一个报告工具，添加的内容太多，以至于他们称之为“BI 套件”。 我认为大多数 BI 工具都是相同的。
如果您看到一款标记为“BI 工具”的产品，预计它会主要专注于报告（这是 BI 最明显的部分）。 您必须自己创建数据仓库，然后使用 BI 工具对多维数据集进行建模，以最好地表示用户希望从数据仓库中获取的数据。 最后，您将使用该工具创建报告，尽管您的用户可以使用您创建的报告之外的功能查看多维数据集中的数据。
此外，您还可以添加 Business Objects、Crystal reports 以及任何这些报告工具，因为实际上，BI == 报告。
I can only speak for Cognos, which is a reporting tool that has been added onto so much that they're calling it a "BI Suite." I think most of the BI tools are the same.
If you see a product labelled as a "BI tool" expect it to be heavily concentrated on reporting (which is the most visible part of BI). You have to create the Data Warehouse yourself, then you'll use the BI tool to model your cube(s) to best represent the data that the users want out of your DW. Finally, you'll create reports using that tool, though your users can see the data that's in the cube using functionality outside reports that you've created.
Also, you can add Business Objects, Crystal reports, any of those reporting tools because really, BI == Reporting.
You can write a piece of "business intelligence" software - but it's fairly complex. Such software would act like a manager of sorts, by analyzing data and making recommendations. Think about an program with an MBA. The catch is, to actually write a program like that requires not only building analysis tools to let the application automatically scan through information looking for business patterns, but also to give the program "intuition" which most successful business managers have. A program that runs based on strict rules will not necessarily make the best decisions, just the best documented decisions.
I was contacted by a company (this is an example of practical applications for business intelligence) that wanted an application to monitor trends in certain market categories, and use those trends to predict optimal prices for their products. They were selling luxury products whose prices fluctuated throughout the year and according to various economic indicators. Most of their managers could do this kind of price setting, and they were looking to automate it. The analysis required to do this would involve advanced statistics, some artificial intelligence to interpret it, not to mention the ability to acquire the data it needed on its own. The project's opening budget was $2M. Not something for the light-hearted.
商业智能是将现有 OLTP 数据库非规范化为衡量标准系统。 商业智能系统最重要的要求之一是报告的数据能够快速输出。 事务 OLTP 数据库系统会因 OLAP（用于 BI 报告的数据库类型）数据库通常以极快的速度执行的查询而受到阻碍。 当我谈到速度时，根据我的经验，任何耗时超过 5 秒的查询都表明需要以更好的方式重构架构。 在事务环境中，使用的数据库语言是TSQL。 在 OLAP 领域，统一语言被称为 MDX（多维扩展），实际上是 SQL 语言的扩展。 在 Microsoft 堆栈中以及从 VS 2005 开始，Analysis Services 以及 MS SQL Server 都与 CLR 融为一体。 可以直接从 Visual Studio 的 IDE 中创建和维护应用程序。 从 VS 中连接到 SSIS 对象并创建可与 SQL Server 集成的 ETL 处理层并拥有经过清理的数据仓库（其源成为 Analysis Services 数据库的数据源）的能力无疑向我表明，开发人员获得了对使用 MS Stack 创建解决方案时的输入和输出。 无论如何，这是我的看法。
根据 Business Objects 的经验，Oracle 以及较小程度上的 Cognos 被迫进行收购，以增强其 BI 产品，而 Business Objects 更像是一家报告消费者公司，而不是一家数据库和报告消费者公司。 在我看来，当 Cognos 从 Applix 收购了一个名为 TM1 的额外规划 OLAP 数据库，并获得了业内最好的自助服务 OLAP 报告工具之一（名为 Executive Viewer），该工具可以根据 Oracle 的 Essbase、TM1 进行报告时，我认为 Cognos 进行了更明智的收购。目前可能有 Cognos、分析服务、SAP BW，据我所知，HP 还没有提供 BI 产品。 然而，当我上次查看时，他们正在使用 Executive Viewer。
Business Intelligence is about denormalizing your existing OLTP databases into a system of measurement criteria. One of the most important requistes of Business Intelligence systems is that the data that is reported on is outputted with a great deal of speed. The transactional OLTP database systems would choke on queries that an OLAP (database type used for BI reporting) database routinely performs with a great deal of speed. When I speak of speed, in my experience any query that takes greater than 5 seconds indicates a need to refactor the architecture in better ways. In the transactional environment, the database language used is TSQL. In the OLAP world the unified language is known as MDX, Multi-Dimensional eXtensions and actually is an extension to the SQL language. In the Microsoft stack and as of VS 2005, Analysis Services as well as MS SQL Server are at home with the CLR. Applications can be created and maintained directly from within Visual Studio's IDE. The ability to hook into SSIS objects from within VS and create ETL processing layers that can integrate with SQL Server and have the scrubbed Data Warehouse whose source becomes the DataSource for your Analysis Services database certainly indicates to me that a developer gains a ton of control over inputs and outputs when creating solutions with the MS Stack. In any event that is my take.
Based upon experience Business Objects, Oracle and to a lesser degree Cognos were forced into acquisition to enhance their BI offerings with Business Objects being more of a Reporting consumer than a database and reporting consumer company. Cognos in my opinion made the more intelligent acquisition when the acquired an additional planning OLAP database from Applix named TM1 and along with it got one of the best Self service OLAP reporting tools in the business named Executive Viewer which can report against Oracle's Essbase, TM1, Cognos likely by now, Analysis Services, SAP BW, To my knowledge HP has no BI offering. They were using Executive Viewer however when I last looked.
In practical terms its the buzzword which describes a set of products such as Business Objects, SAS BI, and some offerings from the usual suspects such as Oracle and HP.
Mostly these are "pretty print" report writing front ends to datawarehouse style databases, and, probably the best generic description would be the presentation layer in a data warehouse architecture.
Business Intelligence (BI) represents the tools and systems that play a key role in the strategic planning process of the corporation. These systems allow a company to gather, store, access and analyze corporate data to aid in decision-making. Generally these systems will illustrate business intelligence in the areas of customer profiling, customer support, market research , market segmentation, product profitability, statistical analysis, and inventory and distribution analysis to name a few.
According to The DataWarehouse Institute (TDWI), BI is "the process, technologies, and tools needed to turn data into information, information into knowledge, and knowledge into plans that drive profitable business actions".
IMHO, BI does have a meaning, and it isn't just a buzzword, it's particulary true for business people that gain a real value from their data assets thanks to BI.
BI isn't just the fron-end tools of reporting and data analysis, it is rather the sum of technologies, process & peoplen thus, it's more than a technical issue, even if it encompasses a real (and generally hard) technical aspect. link text
新一代 BI 变得更加注重交互。 借助 Flash 和其他 Web 2.0，复杂但易于使用的仪表板、可视化可以像以前的报告一样在 Web 上提供。
A new generation BI has become much more interactive oriented. With flash and other web 2.0, sophisticated yet easy-to-use dashboards, visualization are delivered on web like reports before.
我认为 BI 的最佳定义是它使您能够轻松地询问系统的假设问题。 提供固定信息就是报告。 提供实时信息的是仪表板。 提供交互式答案就是 BI
I think the best definition of B.I. is it gives you the ability to easily ask what-if questions of your system. Providing fixed information is reporting. Providing live information is dashboards. Providing interactive answers is B.I.
Business Intelligence is about understanding one's business. It's an odd converse of Military Intelligence which is about understanding the enemy. It provide suits with information with which to make business decisions.
To a developer, it's a type of software one might develop. Not so much one that a developer would use.
发布评论
评论（12）
BI != 报告。 BI 平台使用户能够构建帮助组织学习和了解其业务的应用程序。 Gartner 定义< /a> BI 平台作为软件平台，提供以下 12 项功能：
BI != Reporting. BI platforms enable users to build applications that help organizations learn and understand their business. Gartner defines a BI platform as a software platform that delivers the following 12 capabilities:
定义
商业智能 (BI) 是指技能、技术、应用程序和用于帮助企业更好地了解其商业环境的实践。 商业智能也可以指所收集的信息本身。
BI 技术提供业务运营的历史、当前和预测视图。 商业智能技术的常见功能包括报告、OLAP、分析、数据挖掘、业务绩效管理、基准测试、文本挖掘和预测分析。
商业智能通常旨在支持更好的业务决策。 因此BI系统可以称为决策支持系统（DSS）。
个人经历
在 BI 软件产品工作了 7 年过去，我不认为这是一个空洞的流行词。 去一家超市询问他们如何知道他们在店里放了多少奶酪； 他们把它放在哪里； 以及哪些品牌。 去找香肠生产商：他们让我们的产品根据许多变量分析销售情况，例如，他们在超市的展示方式：普通、更相关、很难发现。 他们决定哪些变量与他们相关，因此应该进行分析。 去包裹寄送公司询问他们推广哪些服务以及原因。 他们都分析所有数据，并使用软件来分析。 当然，除了软件之外，你还需要大脑； 但是，唉，你不仅需要大脑，还需要软件。
是的，这可能是一个广泛的、开放的术语。 但这并不是一句空话。
更实际地说，任何能支付你7年账单的东西都不是空的:-)
Definition
Business intelligence (BI) refers to skills, technologies, applications and practices used to help a business acquire a better understanding of its commercial context. Business intelligence may also refer to the collected information itself.
BI technologies provide historical, current, and predictive views of business operations. Common functions of business intelligence technologies are reporting, OLAP, analytics, data mining, business performance management, benchmarks, text mining, and predictive analytics.
Business intelligence often aims to support better business decision-making. Thus a BI system can be called a decision support system (DSS).
Personal experience
After having worked for 7 years in a BI software product in the past, I don't think it's an empty buzzword. Go to a supermarket business and ask them how they know how much cheese they put in their store; where they put it; and which brands. Go to a sausage producer: they had our product analyze sells based on lots of variables, for example, which kind of display they got in the supermarket: ordinary, more relevant, hard to spot. They decided which variables were relevant to them and thus should be analyzed. Go to a package sending company and ask them which services they promote and why. They all analyze all their data and they use software for that. Of course you need a brain as well as software; but, alas, you need software as well as a brain.
It may be a wide, open term, yes. But it's not an empty term.
In more practical terms, anything which pays your bills for 7 years is not empty :-)
我只能代表 Cognos，它是一个报告工具，添加的内容太多，以至于他们称之为“BI 套件”。 我认为大多数 BI 工具都是相同的。
如果您看到一款标记为“BI 工具”的产品，预计它会主要专注于报告（这是 BI 最明显的部分）。 您必须自己创建数据仓库，然后使用 BI 工具对多维数据集进行建模，以最好地表示用户希望从数据仓库中获取的数据。 最后，您将使用该工具创建报告，尽管您的用户可以使用您创建的报告之外的功能查看多维数据集中的数据。
此外，您还可以添加 Business Objects、Crystal reports 以及任何这些报告工具，因为实际上，BI == 报告。
I can only speak for Cognos, which is a reporting tool that has been added onto so much that they're calling it a "BI Suite." I think most of the BI tools are the same.
If you see a product labelled as a "BI tool" expect it to be heavily concentrated on reporting (which is the most visible part of BI). You have to create the Data Warehouse yourself, then you'll use the BI tool to model your cube(s) to best represent the data that the users want out of your DW. Finally, you'll create reports using that tool, though your users can see the data that's in the cube using functionality outside reports that you've created.
Also, you can add Business Objects, Crystal reports, any of those reporting tools because really, BI == Reporting.
您可以编写一个“商业智能”软件 - 但它相当复杂。 这样的软件就像一个经理，通过分析数据并提出建议。 考虑一下 MBA 课程。 问题是，要真正编写这样的程序，不仅需要构建分析工具来让应用程序自动扫描信息以寻找业务模式，而且还需要赋予程序大多数成功的业务经理所拥有的“直觉”。 基于严格规则运行的程序不一定会做出最佳决策，而只是做出最好记录的决策。
一家公司（这是商业智能实际应用的示例）联系了我，该公司想要一个应用程序来监控某些市场类别的趋势，并使用这些趋势来预测其产品的最佳价格。 他们销售的奢侈品的价格根据各种经济指标全年波动。 他们的大多数经理都可以进行这种价格设定，并且他们希望将其自动化。 做到这一点所需的分析将涉及先进的统计数据、一些人工智能来解释它，更不用说自行获取所需数据的能力了。 该项目的启动预算为 200 万美元。 不适合轻松的人。
You can write a piece of "business intelligence" software - but it's fairly complex. Such software would act like a manager of sorts, by analyzing data and making recommendations. Think about an program with an MBA. The catch is, to actually write a program like that requires not only building analysis tools to let the application automatically scan through information looking for business patterns, but also to give the program "intuition" which most successful business managers have. A program that runs based on strict rules will not necessarily make the best decisions, just the best documented decisions.
I was contacted by a company (this is an example of practical applications for business intelligence) that wanted an application to monitor trends in certain market categories, and use those trends to predict optimal prices for their products. They were selling luxury products whose prices fluctuated throughout the year and according to various economic indicators. Most of their managers could do this kind of price setting, and they were looking to automate it. The analysis required to do this would involve advanced statistics, some artificial intelligence to interpret it, not to mention the ability to acquire the data it needed on its own. The project's opening budget was $2M. Not something for the light-hearted.
商业智能是将现有 OLTP 数据库非规范化为衡量标准系统。 商业智能系统最重要的要求之一是报告的数据能够快速输出。 事务 OLTP 数据库系统会因 OLAP（用于 BI 报告的数据库类型）数据库通常以极快的速度执行的查询而受到阻碍。 当我谈到速度时，根据我的经验，任何耗时超过 5 秒的查询都表明需要以更好的方式重构架构。 在事务环境中，使用的数据库语言是TSQL。 在 OLAP 领域，统一语言被称为 MDX（多维扩展），实际上是 SQL 语言的扩展。 在 Microsoft 堆栈中以及从 VS 2005 开始，Analysis Services 以及 MS SQL Server 都与 CLR 融为一体。 可以直接从 Visual Studio 的 IDE 中创建和维护应用程序。 从 VS 中连接到 SSIS 对象并创建可与 SQL Server 集成的 ETL 处理层并拥有经过清理的数据仓库（其源成为 Analysis Services 数据库的数据源）的能力无疑向我表明，开发人员获得了对使用 MS Stack 创建解决方案时的输入和输出。 无论如何，这是我的看法。
根据 Business Objects 的经验，Oracle 以及较小程度上的 Cognos 被迫进行收购，以增强其 BI 产品，而 Business Objects 更像是一家报告消费者公司，而不是一家数据库和报告消费者公司。 在我看来，当 Cognos 从 Applix 收购了一个名为 TM1 的额外规划 OLAP 数据库，并获得了业内最好的自助服务 OLAP 报告工具之一（名为 Executive Viewer），该工具可以根据 Oracle 的 Essbase、TM1 进行报告时，我认为 Cognos 进行了更明智的收购。目前可能有 Cognos、分析服务、SAP BW，据我所知，HP 还没有提供 BI 产品。 然而，当我上次查看时，他们正在使用 Executive Viewer。
Business Intelligence is about denormalizing your existing OLTP databases into a system of measurement criteria. One of the most important requistes of Business Intelligence systems is that the data that is reported on is outputted with a great deal of speed. The transactional OLTP database systems would choke on queries that an OLAP (database type used for BI reporting) database routinely performs with a great deal of speed. When I speak of speed, in my experience any query that takes greater than 5 seconds indicates a need to refactor the architecture in better ways. In the transactional environment, the database language used is TSQL. In the OLAP world the unified language is known as MDX, Multi-Dimensional eXtensions and actually is an extension to the SQL language. In the Microsoft stack and as of VS 2005, Analysis Services as well as MS SQL Server are at home with the CLR. Applications can be created and maintained directly from within Visual Studio's IDE. The ability to hook into SSIS objects from within VS and create ETL processing layers that can integrate with SQL Server and have the scrubbed Data Warehouse whose source becomes the DataSource for your Analysis Services database certainly indicates to me that a developer gains a ton of control over inputs and outputs when creating solutions with the MS Stack. In any event that is my take.
Based upon experience Business Objects, Oracle and to a lesser degree Cognos were forced into acquisition to enhance their BI offerings with Business Objects being more of a Reporting consumer than a database and reporting consumer company. Cognos in my opinion made the more intelligent acquisition when the acquired an additional planning OLAP database from Applix named TM1 and along with it got one of the best Self service OLAP reporting tools in the business named Executive Viewer which can report against Oracle's Essbase, TM1, Cognos likely by now, Analysis Services, SAP BW, To my knowledge HP has no BI offering. They were using Executive Viewer however when I last looked.
实际上，它是一个流行词，描述了 Business Objects、SAS BI 等一系列产品，以及 Oracle 和 HP 等常见产品的一些产品。
大多数情况下，这些都是将前端写入数据仓库样式数据库的“漂亮打印”报告，并且可能最好的通用描述是数据仓库体系结构中的表示层。
In practical terms its the buzzword which describes a set of products such as Business Objects, SAS BI, and some offerings from the usual suspects such as Oracle and HP.
Mostly these are "pretty print" report writing front ends to datawarehouse style databases, and, probably the best generic description would be the presentation layer in a data warehouse architecture.
商业智能（BI）代表在公司战略规划过程中发挥关键作用的工具和系统。 这些系统允许公司收集、存储、访问和分析公司数据以帮助决策。 一般来说，这些系统将说明客户分析、客户支持、市场研究领域的商业智能
、市场细分、产品盈利能力、统计分析以及库存和分销分析等等。
Business Intelligence (BI) represents the tools and systems that play a key role in the strategic planning process of the corporation. These systems allow a company to gather, store, access and analyze corporate data to aid in decision-making. Generally these systems will illustrate business intelligence in the areas of customer profiling, customer support, market research
, market segmentation, product profitability, statistical analysis, and inventory and distribution analysis to name a few.
根据数据仓库研究所 (TDWI) 的说法，BI 是“将数据转化为信息、将信息转化为知识、将知识转化为推动有利可图的业务行动的计划所需的流程、技术和工具”。
恕我直言，BI 确实有其含义，它不仅仅是一个流行词，对于通过 BI 从数据资产中获得真正价值的业务人员来说尤其如此。
BI不仅仅是报告和数据分析的前端工具，它更是技术、流程和数据的总和。 因此，这不仅仅是一个技术问题，即使它包含了真正的（通常是困难的）技术方面。 链接文本
According to The DataWarehouse Institute (TDWI), BI is "the process, technologies, and tools needed to turn data into information, information into knowledge, and knowledge into plans that drive profitable business actions".
IMHO, BI does have a meaning, and it isn't just a buzzword, it's particulary true for business people that gain a real value from their data assets thanks to BI.
BI isn't just the fron-end tools of reporting and data analysis, it is rather the sum of technologies, process & peoplen thus, it's more than a technical issue, even if it encompasses a real (and generally hard) technical aspect. link text
给出更长的答案似乎听起来充满风，所以：
商业智能：具有强大附加功能的报告软件，专注于基于历史数据的未来预测。
Giving a much longer answer seems to make it sound full of wind, so:
Business Intelligence: reporting software with strong additional abilities focused on future prediction based on historical data.
新一代 BI 变得更加注重交互。 借助 Flash 和其他 Web 2.0，复杂但易于使用的仪表板、可视化可以像以前的报告一样在 Web 上提供。
A new generation BI has become much more interactive oriented. With flash and other web 2.0, sophisticated yet easy-to-use dashboards, visualization are delivered on web like reports before.
我认为 BI 的最佳定义是它使您能够轻松地询问系统的假设问题。 提供固定信息就是报告。 提供实时信息的是仪表板。 提供交互式答案就是 BI
I think the best definition of B.I. is it gives you the ability to easily ask what-if questions of your system. Providing fixed information is reporting. Providing live information is dashboards. Providing interactive answers is B.I.
商业智能是关于了解一个人的业务。 这是军事情报的一个奇怪的对话，军事情报的目的是了解敌人。 它为西装提供了做出业务决策的信息。
对于开发人员来说，它是一种可以开发的软件。 与其说是开发人员会使用的，不如说是开发人员会使用的。
Business Intelligence is about understanding one's business. It's an odd converse of Military Intelligence which is about understanding the enemy. It provide suits with information with which to make business decisions.
To a developer, it's a type of software one might develop. Not so much one that a developer would use.