DW - Data Warehousing & Modeling
Based on a need for information, a reporting was set up in Qlikview many years ago. The information was taken directly from the ERP source system (INFOR). Now, many years later and after an exponential growth in the demand for information, the current working method is no longer sustainable and it was decided to set up a new data warehouse together with element61.
This Planning & Budgeting project was build using IBM Cognos TM1 and SQL Server Integration Services. The high level goal of the project was to extract the existing planning data, being captured from the users through IBM Cognos TM1, to a data warehouse ready for Business Intelligence reporting.
The family owned Ardo Group (headquartered in Ardooie, Belgium) is an important player in the production of a full range of fresh frozen vegetables, herbs and fruit for retail, foodservice and industry. Today the Ardo Group has a global sales network and 21 production, distribution and packing units in 8 different European countries.