Data warehouse development : An opportunity for business process improvement

Abstract: Many of today’s organizations are striving to find ways to make faster and better decisions about their business. One way to achieve this is to develop a data warehouse, offering novel features such as data mining and ad hoc querying on data collected and integrated from many of the computerized systems used in the organization. A data warehouse is of vital interest for decision makers and may reduce uncertainty in decision making. The relationship between data warehousing and business processes may be used at the pre-deployment stage of a data warehouse project, i.e. during the actual development of the data warehouse, as an opportunity to change business processes in an organization. This may then result in improved business processes that in turn may result in a better performing data warehouse. By focusing on the pre-deployment stage instead of the post-deployment stage, we believe that the costs for development will decrease, since needs for changes detected early in a development project probably will be detected anyway, but in a later stage where changes in the business processes may cause a need to restructure the finished data warehouse. We are therefore interested in which factors that may cause a need for changes in the business processes during the pre-deployment stage of a data warehouse project, the types of business processes affected, and also if there is any correspondence between factors that trigger changes and business processes affected. Based on a literature survey and an interview study, general triggering factors to change business processes have been identified, such as needs for new organizational knowledge and for prioritization of goals etc. We have also found that needs for changes more often concern supporting processes than other types of business processes. We have also found a general correspondence at a type level between triggering factors and affected business processes. In combination with the results and conclusions presented, we have also identified propositions for future work, which will refine and confirm the ideas presented here.