Nederlandse versie  -  Version Française

Ferranti builds multinational Business Intelligence environment for Marine Harvest VAP 

Belgian system integrator Ferranti is currently working on an extensive Business Intelligence project for the Marine Harvest VAP Europe group. The environment centralises relevant corporate information from ten different European branches of the company in one data warehouse. It will enable the company's head office in to make better decisions.

Marine Harvest group breeds salmon and trout and produces derivative products. It has several fish farms all over the world.

For some time, the company had been looking for a solution to group the sales data of the branches in one central location. It wants to make detailed Business Intelligence analyses of the performance of the whole group.

Grouping geographically spread information wasn't Marine Harvest VAP Europe's only challenge; it also works with many different database environments.  Ferranti came up with an ETL (Extraction, Transformation and Loading) solution that retrieves the relevant data from, among others, DB2, Oracle, Progress, CSV-files and MS Access.

The data on clients, products, invoicing and costs of the different sites is collected, transformed and prepared for loading in the data warehouse in .

The architecture is based on Microsoft SQL Server and the Microsoft SQL Integration Services. In the head office in , Microsoft Reporting Services provides the Business Decision environment.

This project is very important for Ferranti in the context of its partnership with Microsoft. By bringing this project to a good conclusion Ferranti is showing Microsoft, but also other potential clients, that it can hold its own in terms of BI.