Implementing Business Intelligence System - Case Study

• Published in: Database systems journal Vol. VII; no. 1; pp. 35 - 44
• Main Authors: Yasser AL-HADAD, Razvan Daniel ZOTA
• Format: Journal Article
• Language: English
• Published: Bucharest University of Economic Studies 01-08-2016
• Subjects: BI(Business intelligence); DSS(Decision support systems); DW(Data warehouse); ETL(Extract; OLAP(Online Analytical Processing); SAS(SQL server services); transform and load
• ISSN: 2069-3230; 2069-3230

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.