Data Warehouses and Business Intelligence in Croatia: Do Managers Know How to Use Them?

Data Warehouses and Business Intelligence in Croatia: Do Managers Know How to Use Them?

Kornelije Rabuzin (Faculty of Organization and Informatics, University of Zagreb, Zagreb, Croatia) and Darko Škvorc (Faculty of Organization and Informatics, University of Zagreb, Zagreb, Croatia)
Copyright: © 2016 |Pages: 11
DOI: 10.4018/IJBAN.2016040103
OnDemand PDF Download:
$37.50

Abstract

Authors of this paper were directly involved in several data warehousing and business intelligence projects that were carried out in companies in Croatia. Based on the experience from those projects, this paper presents how those solutions were implemented — and more importantly, how they were used by managers at different levels of management. Three different companies are described, including three different implemented solutions. One company was small, one was mid-sized and one was large. All had differences in ownership and education level of managers. Implementation (technical) details are omitted, but this paper shows that managers do not always see what business intelligence can do. Furthermore, it is shown that such projects do not always have to be expensive.
Article Preview

Etl

Regarding sources of data, many different database management systems (DBMS) can be used; and it is usually best when one such system can be found. The reason is quite simple, i.e., one can use Structured Query Language (SQL) to extract data from such data sources (Rabuzin, 2012; Rabuzin, 2014). More often, flat or Excel files, or even old, not well-documented applications exist as data sources. Other types of data sources may require specialized knowledge and skills in order to extract and to use data. As Liu and Shi (2014) recognized, business data could cause severe problems:

  • Business data often encounters quality issues and needs substantial cleaning efforts;

  • Business data is large in overall size but cannot be fully shared due to the concern of data security;

  • Business data often needs to be cross-referenced with public databases to reveal more information and knowledge.

In recent years, many NoSQL systems became available that contain relevant data. NoSQL systems are usually characterized by large volumes of data that do not share the same structure and that do change quite often. Volume, variety and velocity represent big data challenges, which cause difficulties in capture, storage, search, sharing, analysis and visualization (Abdelhafez, 2014). So there is a problem when one needs to extract data from all those sources, because they are not standardized; each system uses a different query language. For example, graph databases are interesting as they can represent nodes and their relationships. The query language that is used could be Cypher Query Language or Gremlin. For column-oriented databases (e.g., HBase), another specialized language is used. Key-Value databases are not an exception; neither are document-oriented databases. So one needs to be familiar with these systems in order to extract data. For more information on NoSQL databases, one could look at (Redmond & Wilson, 2012) or (Robinson, Webber & Eifrem, 2013).

Furthermore, in recent years Facebook and Twitter are becoming of increasing interest, because people write and publish large amounts of text on them; text analysis (mining) is becoming more and more important. Measuring a user’s opinion and attitudes could be very challenging, but at the same time it is known that people do publish things that could be disturbing or even dangerous. There are an increasing number of cases where people wrote on Facebook that they were going to do certain things that were criminal or dangerous, and then really did those things.

Complete Article List

Search this Journal:
Reset
Open Access Articles: Forthcoming
Volume 4: 4 Issues (2017)
Volume 3: 4 Issues (2016)
Volume 2: 4 Issues (2015)
Volume 1: 4 Issues (2014)
View Complete Journal Contents Listing