Implementing Business Intelligence System - Case Study

Yasser Al-Hadad () and Razvan Daniel Zota ()
Additional contact information
Yasser Al-Hadad: University of Economic Studies, Bucharest, Romania
Razvan Daniel Zota: University of Economic Studies, Bucharest, Romania

Database Systems Journal, 2016, vol. 7, issue 1, 35-44

Abstract: Understanding and analysis data is essential for making decision within a system. Any analytical tasks can be implemented directly by the transactional system but it becomes more difficult as the transactional system grows. Analytical systems and their extension appear as a solution for complex and large datasets. We think that it's time for medium companies to get the benefit from such systems as analytical systems become more variant and in hand for every possible user. In this paper, we propose an architecture of analytical system that can adapt and integrate with existent transactional system of timber export company. The proposed analytical system should have the ability of implementing the tasks required by the decision makers of the system. Also, we try to explore the ability of SQL server of implementing our proposed architecture.

Keywords: BI(Business intelligence); DSS(Decision support systems); DW(Data warehouse); OLAP(Online Analytical Processing); ETL(Extract; transform and load); SAS(SQL server services) (search for similar items in EconPapers)
Date: 2016
References: View references in EconPapers View complete reference list from CitEc
Citations:

Downloads: (external link)
http://www.dbjournal.ro/archive/23/23_5.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:aes:dbjour:v:7:y:2016:i:1:p:35-44

Access Statistics for this article

Database Systems Journal is currently edited by Ion Lungu

More articles in Database Systems Journal from Academy of Economic Studies - Bucharest, Romania Contact information at EDIRC.
Bibliographic data for series maintained by Adela Bara ().