Building and Evolving Data Warehousing and Business Intelligence Artifacts: The Case of SYSCO

Abstract

This paper investigates the use of data warehouse and business intelligence capabilities to integrate with customers in the supply chain and improve insights into customer sales. By making that same data warehouse sales information available to customers, this paper explores how the data warehouse can provide additional value to those customers, eliminating asymmetries of information in the supply chain. In addition, this paper investigates the evolution of data warehousing into business intelligence, expanding sales information to include marketing associate performance analysis generated for internal use. Further, this paper also examines a methodology that was used for building a business intelligence system. Finally, this paper investigates what appears to be a business intelligence driven focus on enterprise resource planning systems. These issues are illustrated using real world data warehousing and business intelligence artifacts developed at SYSCO.

Keywords: Data Warehouse, Business Intelligence, Artifacts, Artifact Evolution, Business Intelligence Methodology, Implementing Business Intelligence