Mais notícias interessantes do blog http://www.itbusinessedge.com!
Why Business Intelligence Matters Now More Than Ever
May 21, 2009 11:22:34 AM
If you’re tempted to postpone integration projects related to business intelligence or BI projects in general – don’t, warns Sarah Burnett, a senior research analyst with European IT research firm The Butler Group. Burnett explained to IT Business Edge’s Loraine Lawson how both BI and CPM software can help companies navigate the current economic climate, and the integration challenges you’ll have to overcome first.
Lawson: In a recent report on Business Intelligence (BI) and Corporate Performance Management (CPM), the Butler Group concluded that holding off on business intelligence and CPM projects isn’t a viable option. Why not?
Burnett: BI allows organizations to get a more accurate and detailed picture of what is going on in terms of business and customers. It can do this in different ways – accurate view of costs, liabilities, risks, customer buying patterns, supplier cost-effectiveness, etc.
BI can bring visibility into the organization at granular levels and help link different aspects together. Take budgets, for example. It is all too easy for organizations to think that they have more money than they do and over-commit on budgets, only to find themselves later with liabilities that they cannot afford.
Whilst rolled up financial reports from spreadsheets can show expenditure and commitments against cost center codes, it is important to be able to drill into the figures, see where they have come from and to have some context around the expenditure. The expenditure, for example, can be viewed against progress and what should be expected next, and so enable organizations to forecast and be ready for invoices that are to come.
This is particularly important in a recession when organizations need to minimize outgoings and risks. It also enables them to plan savings in an informed and effective way.
“Now that consumer confidence is returning, it is also important for organizations to be ready to do sales and promotion campaigns at the right time. BI can help with that …”
- Sarah Burnett
- The Butler Group
Lawson: What’s the connection between CPM and BI applications?
Burnett: Now that consumer confidence is returning, it is also important for organizations to be ready to do sales and promotion campaigns at the right time. BI can help with that too – allow organizations to review customer behavior so that they can time special offers to get customers back before their competitors do. In this way, you can use Business Intelligence to optimize business and improve corporate performance – develop a full cycle of CPM right from the planning and budgeting stage through to implementing, monitoring and – very importantly – improving.
Lawson: With all the tools available now, why are poor data quality and lack of integration still major barriers to effective CPM and BI?
Burnett: BI relies on data collected from other systems, so the quality of the data is very important to BI. The intelligence provided by BI has to be trusted enough to be acted upon.
There are many data quality software tools that can be used to improve the quality of data that comes into the BI or CPM system. But there is more to data quality than just tools.
Data quality should be built into processes so that data is correctly captured and stored, that errors are not introduced in other processes that use the data, and that the data is integrated, i.e., brought together from different systems so that the information that it provides can be compared and contrasted to provide intelligence: Where is Widget X selling the best? Is it actually selling at a profit?
Lawson: What steps do companies need to take to address the integration problems undermining CPM and BI?
Burnett: Which aspect of integration did you want to discuss: Between BI and CPM software, or embedding BI in other apps, or data integration for BI and CPM?
Lawson: Could you explain all of them?
Burnett: As far as BI and CPM integration, many vendors offer their own integrated BI/CPM packages or integrate with software from third parties. Many of the leading software apps have support for standards. Some support other third-party tools or connectors to different pieces of BI/CPM software.
Following the spate of acquisitions in 2007, vendors have integrated some of the acquired products, for example, recently acquired OLAP engines, but there is still work going on in this area. It is advisable for organizations to ensure that their preferred software apps work together. In Butler Group’s Features Matrix, part of our recently published BI (CPM) report, we list the interoperability capabilities of leading CPM software from: Actuate, InformationBuilders, IBM Cognos, Microsoft, Oracle, SAP and SAS.
Vendors are addressing embedded BI in different ways, e.g., through SOA, operational BI or real-time BI. The latter is a different kind of BI that collects data from message queues or real-time events and builds process or event profiles to use for reference and comparisons. Deviations from the norm can then be spotted in real time and alerts generated or even other processes activated automatically. There are also BI software tools with open APIs and support for Flash, etc. that allow BI output to be used in composite applications (mashups).
The last, data integration, is very important and also benefits from years of development in this market. There are many ETL tools and other data integration apps that can interface to a myriad of BI applications and vice versa. The sort of problems experienced in this area include different data definitions, or reference data used in different parts of the organization and in different data sources, making it difficult to consolidate data, and compare and contrast info in different business contexts. Other problems include increasing volumes of data that can lead to data warehousing performance and scalability issues.
Data quality is very important, too. If you put garbage in, you will get garbage out. Data quality is important for business efficiency anyway and it is essential for gaining trusted business intelligence.
This entry was posted on maio 23, 2009 at 5:34 pm and is filed under Economia e TIC's. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.