Indian Journal of Advances in Computer Sciences and Technology

Open Access Open Access  Restricted Access Subscription Access
Open Access Open Access Open Access  Restricted Access Restricted Access Subscription Access

OLAP Implementation in a Banking BI System


Affiliations
1 Department of Computer Science, University of Tirana, Tirana, Albania
     

   Subscribe/Renew Journal


In this paper we will focus on online analytical processing (OLAP) technology - an essential component of business intelligence (BI) - exploring its features and applications in decision support. We will describe our system, with the data organized in multidimensional cubes and see how easily we can "play" with the cube by using "slice-anddice" techniques. This way, the business analysts can view and analyze the business data online, interactively and from different perspectives, which helps them to take better decisions.

Our illustrations will be provided from the system we developed in a Bank, using Microsoft Analysis Services.


Keywords

OLAP, Data Warehouse, Cube, BI, Bank
Subscription Login to verify subscription
User
Notifications
Font Size


  • Evelson B (2008). "Topic Overview: Business Intelligence". http://www.forrester.com/rb/Research/topic_overview_business_intelligence/q /id/39218/t/2

  • Han J, Kamber M, Pei J. (2011). Data Mining Concepts and Techniques. 3rd edition, Morgan Kaufmann.

  • Chaudhuri S and Dayal U. (1997) An overview of Data warehousing and OLAP technology. SIGMOD Record, 26(1), Mar, pp 65-74.

  • Codd E.F., Codd S.B., and Salley C.T. (1993). "Providing OLAP (On-line Analytical Processing) to User-Analysts: An IT Mandate". Codd & Date, Inc. http://www.fpm.com/refer/codd.html.

  • Pendse N, Creeth R (1995): The OLAP Report. In: Business Intelligence.

  • http://www.bi-verdict.com/fileadmin/FreeAnalyses/fasmi.htm


Abstract Views: 749

PDF Views: 8




  • OLAP Implementation in a Banking BI System

Abstract Views: 749  |  PDF Views: 8

Authors

Dhimiter Kikina
Department of Computer Science, University of Tirana, Tirana, Albania

Abstract


In this paper we will focus on online analytical processing (OLAP) technology - an essential component of business intelligence (BI) - exploring its features and applications in decision support. We will describe our system, with the data organized in multidimensional cubes and see how easily we can "play" with the cube by using "slice-anddice" techniques. This way, the business analysts can view and analyze the business data online, interactively and from different perspectives, which helps them to take better decisions.

Our illustrations will be provided from the system we developed in a Bank, using Microsoft Analysis Services.


Keywords


OLAP, Data Warehouse, Cube, BI, Bank

References