Business Intelligence: Peter Simons Reports on the Latest Developments in the Fast-Moving BI Software Industry and Forecasts New Trends in Decision-Support Technology

By Simons, Peter | Financial Management (UK), September 2008 | Go to article overview

Business Intelligence: Peter Simons Reports on the Latest Developments in the Fast-Moving BI Software Industry and Forecasts New Trends in Decision-Support Technology


Simons, Peter, Financial Management (UK)


The typical business intelligence (BI) architecture can be seen as having a stack of layers. The base usually comprises source data systems, from where data is processed by "extract, transform, load" (ETL) software into a data warehouse. Above that are the BI and application layers and then at the top there is the presentation or delivery layer, which can include executive dashboards, scorecards and other decision-making tools.

Software houses used to specialise in making applications for these different layers, which meant that businesses would assemble their own stacks using independent suppliers. So a company might have an SAP enterprise resource planning (ERP) system that feeds into an Oracle data warehouse, for example, and the firm's finance department might use an application from Hyperion for reports and another from SAS for analytics.

As BI has evolved, the greatest challenge has been how to integrate data on different systems accumulated from different vendors over many years. This challenge is being addressed in the following key ways:

* "Service-oriented architecture" (SOA) has been developed as a solution that eliminates the need for point-to-point connections between resources. It provides access to data in legacy systems through linked "services".

* ERP, ETL, data warehouse and customer relationship management (CRM) software vendors are now offering integrated BI applications. And BI vendors are adding ETL tools. Some brands span different layers of the BI stack (see diagram).

* The big vendors--IBM, Microsoft, Oracle and SAP--which already offered some BI solutions, have moved into performance management by acquisition. There has been a feeding frenzy (see "Who bought whom") and the big players are still digesting their prey. In future, they are likely to offer more integrated BI solutions.

BI and business performance management (or business analytics) used to be seen as separate applications, but the big vendors will integrate them. BI solutions have already become more accessible through web enablement and more applicable through the inclusion of a range of data sources and pre-defined business content. As Gartner puts it: "The data warehouse has evolved from an information store supporting the running of reports and ad-hoc queries into an analytics infrastructure repository."

BI has developed from reporting on data from an ERP source to include functions such as financial consolidation; activity-based costing; dashboards and scorecards; data mining, integration and warehousing; and "pervasive intelligence".

The BI industry is dynamic, with frequent announcements of new products, alliances and acquisitions. There are many vendors, but the biggest are as follows:

* SAP and Business Objects. Together these are the biggest players in the BI market. SAP is best known for its ERP system but it has been expanding into BI with the development of SAP Netweaver BI and SAP BI Accelerator and then its acquisitions of OutlookSoft and PeopleSoft. The acquisition of Business Objects in 2007 should give SAP a strong position in this market.

* Oracle and Hyperion. Oracle has built its reputation on database systems rather than ERR Hyperion is highly rated for its consolidation and financial accounting functionality. Siebel already provided Oracle with an analytics capability but the acquisition of Hyperion has added strength in the crucial area of financial planning tools. It is not yet clear how this will fit with other acquisitions.

* IBM and Cognos. IBM already had some BI capability with its DB2 product, but its strength lies in databases. Cognos, with its SOA and planning tools, should prove a valuable acquisition.

* Microsoft. Windows and MS Office may have achieved world domination, but Microsoft's BI offering is yet to be seen as providing the same depth as its specialist competitors' products. MS PowerPoint provides a complete BI stack, with MS Office as the top layer, so Microsoft could potentially bring BI to a wider audience. …

The rest of this article is only available to active members of Questia

Already a member? Log in now.

Notes for this article

Add a new note
If you are trying to select text to create highlights or citations, remember that you must now click or tap on the first word, and then click or tap on the last word.
One moment ...
Default project is now your active project.
Project items

Items saved from this article

This article has been saved
Highlights (0)
Some of your highlights are legacy items.

Highlights saved before July 30, 2012 will not be displayed on their respective source pages.

You can easily re-create the highlights by opening the book page or article, selecting the text, and clicking “Highlight.”

Citations (0)
Some of your citations are legacy items.

Any citation created before July 30, 2012 will labeled as a “Cited page.” New citations will be saved as cited passages, pages or articles.

We also added the ability to view new citations from your projects or the book or article where you created them.

Notes (0)
Bookmarks (0)

You have no saved items from this article

Project items include:
  • Saved book/article
  • Highlights
  • Quotes/citations
  • Notes
  • Bookmarks
Notes
Cite this article

Cited article

Style
Citations are available only to our active members.
Buy instant access to cite pages or passages in MLA, APA and Chicago citation styles.

(Einhorn, 1992, p. 25)

(Einhorn 25)

1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25, http://www.questia.com/read/27419298.

Cited article

Business Intelligence: Peter Simons Reports on the Latest Developments in the Fast-Moving BI Software Industry and Forecasts New Trends in Decision-Support Technology
Settings

Settings

Typeface
Text size Smaller Larger Reset View mode
Search within

Search within this article

Look up

Look up a word

  • Dictionary
  • Thesaurus
Please submit a word or phrase above.
Print this page

Print this page

Why can't I print more than one page at a time?

Help
Full screen

matching results for page

    Questia reader help

    How to highlight and cite specific passages

    1. Click or tap the first word you want to select.
    2. Click or tap the last word you want to select, and you’ll see everything in between get selected.
    3. You’ll then get a menu of options like creating a highlight or a citation from that passage of text.

    OK, got it!

    Cited passage

    Style
    Citations are available only to our active members.
    Buy instant access to cite pages or passages in MLA, APA and Chicago citation styles.

    "Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn, 1992, p. 25).

    "Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn 25)

    "Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences."1

    1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25, http://www.questia.com/read/27419298.

    Cited passage

    Thanks for trying Questia!

    Please continue trying out our research tools, but please note, full functionality is available only to our active members.

    Your work will be lost once you leave this Web page.

    Buy instant access to save your work.

    Already a member? Log in now.

    Oops!

    An unknown error has occurred. Please click the button below to reload the page. If the problem persists, please try again in a little while.