Measuring Performance for Data Warehouse – A Balanced Scorecard Approach
Introduction
Data warehouse is one of the key information technology (IT) infrastructures. Data warehouse involves a huge financial undertaking. It is important that data warehouse performance is measured in terms of some key aspects. A balanced scorecard (BSC) approach could be applied to measure the performance of data warehouse operations. These measures include user perspective, internal process perspective, financial perspective, and innovation and growth perspective. The motivation behind using a balanced scorecard is to make sure data warehouse environment is efficient and stable.
Objective
To measure the performance of data warehouse operations for increased the completeness and the quality of enterprise resource planning implementation reports. To make data warehouse project progress in term of innovation and learning. Data warehouse project continuously helps information technology (IT) department in adding business value and enable, cost avoidances. Data warehouse team provides business executive quality information at the right time to support making strategic business decision.
The goal is to ensure that they put a control on financial aspects in terms of adding business value and achieve cost avoidance while maintaining a data warehouse. The other prominent goal is to make sure data warehouse environment is efficient, stable, and provides quality information
Method
Data Warehouse Balanced Scorecard: User Perspective
Measuring data warehouse implementation success depends on user satisfaction surveys to be conducted periodically among analytical community. This will provide performance metrics as to whether the data warehouse managers are able to increase user satisfaction over the years.
Data Warehouse Balanced Scorecard: Business Value Perspective
Data warehouse implementation requires a large amount of capital investment. A big amount of annual expense is also involved in its operation and maintenance of hardware, software and licenses. Data warehouse architects need to evaluate if they are able to provide customer services to end user groups and needs to identify any bottleneck and inefficiencies in data warehouse operations. It is also important to make sure data warehouse workforce consists of the right people only.
Data Warehouse Balanced Scorecard: Internal Process Perspective
Balanced scorecard is designed to provide managers an internal perspective of an organization. Data warehouse architects need to make sure that internal processes are effective and efficient in providing services to fulfill user satisfaction. As part, of internal operation in data warehouses certain key factors needs to be taken into consideration. These measures need to be revisited periodically to make sure continual improvement is achieved.
Tools
This article use balanced scorecard to measurement performance for data warehouses. The balanced scorecard is a strategic planning and management system which takes into account non-financial aspects of corporate performance, such as customer satisfaction and business processes, to create a complete picture of how the company is likely to perform in the future. For example, reducing the level of customer service may boost current earnings, but the balanced scorecard approach would also take into account potential loss of future earnings due to poor customer satisfaction.
Conclusion
This article is measure about data warehouse, which include user perspective, internal process perspective, financial perspective, and innovation and growth perspective. Proposed is a balanced scorecard approach for measuring performance of data warehouse operations. The scorecard provides data warehouse managers and architects with crucial measures on business value creation, cost avoidance, innovation, user satisfaction, internal operations, efficiency, data warehouse performance and stability. The balanced scorecard measures should enable data warehouse architects to deliver operational excellence in terms of quality, efficiency, velocity, and capacity to deliver services.