Business intelligence

Marko Horvat (2009) Business intelligence. EngD thesis.

PDF Download (1905Kb)

Abstract

The purpose of this work is to present business intelligence systems. These systems can be extremely complex and important in modern market competition. Its effectiveness also reflects in price, so we have to exlore their financial potential before investment. The systems have 20 years long history and during that time many of such tools have been developed, but they are rarely still in use. Business intelligence system consists of three main areas: Data Warehouse, ETL tools and tools for Business intelligence. Data Warehouse is system for storing data in electronic form. It is important that this information is stored in a manner which allows quick searches. Main purpose of an ETL tool is to extract, translate and load data into data warehouse. Business intelligence tools help end-user to transform data into information. They are usually used by non-professional users so they must be as simple as possible. Some of those tools are digital dashboard, tools for data mining, tools for process mining, spreadsheets, OLAP, etc. Many companies produce tools in this area. In this thesis we present Oracle and Microsoft BI products. After deatiled presentation we compare tools by different criteria: safety, price, platform independance and others. We discovered Oracle has more expensive products, but they are not limited to Microsoft platform only. Gartner Group estimates that Oracle has better vision, Microsoft has better ability to execute, while they prove similar concerning speed.

Actions (login required)