As their business expands and grows beyond their traditional services of auction, through the addition of value-added services such as development of new fruit species, fruit storage, packaging etcetera, Veiling Haspengouw requirements for reliable and timely management information also grew.
They quickly discovered that their existing reporting solutions, mainly Excel-based, had significant shortcomings, and therefore they decided to look for a more stable and automated solution. This process was a joint initiative of the Finance Office and the IT department, who both saw the advantages a best practice Business Intelligence solution could bring them. After an initial and short Performance Management Roadmap project, Veiling Haspengouw decided to invest in a BI architecture based on Microsoft SQL Server. The first iteration of the Enterprise Data Warehouse has been built and delivered, mainly focusing on Sales Revenue reporting. This project was delivered in a short timeframe of 3 months and has resulted in a set of validated and reliable reports and dashboards that are being used by both the Finance and Commercial departments, enabling them to have a better view on their commercial performance. The next iterations of the BI program are currently in full preparation and will cover their Production process reporting and analysis.