Building and Evolving Data Warehousing and Business Intelligence artefacts: the Case of Sysco

This paper investigates use of data warehouse and business intelligence capabilities to integrate with customers in the supply chain and improve insights into customer sales. By making internal data warehouse sales information available to customers, additional value to those customers is created, eliminating asymmetries of information in the supply chain. In addition, the evolution of data warehousing into business intelligence is investigated, expanding sales information to include marketing associate performance analysis generated for internal use. Further, a methodology that was used for building a business intelligence system is also examined. Finally, what appears to be a business-intelligence-driven focus on enterprise resource planning systems is analyzed. These issues are illustrated using real-world data warehousing and business intelligence artefacts developed at SYSCO. Copyright © 2012 John Wiley & Sons, Ltd.