The BI program at Isabel consist of a number of main project iterations. The first two increments concerned mainly the actual platform usage & the expected product usage by customers.
Business Analytics Strategy
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.
element61 has been involved in the Tessenderlo Group BI program since 2007. After the definition of a Business Intelligence Roadmap, a new SAP Business Warehouse 7 deployment was executed. The current SAP Business Warehouse includes data from multiple SAP source systems and covers functional areas such as Profitability Analysis, Sales and Distribution, Profit & Cost Center Accounting, HR, Overhead Cost Controlling, Actual Costing & Material Ledger, Spend Analysis and CRM. As one of the first sites in Belgium, SAP Business Objects Xi was rolled out on top of SAP BW in 2008. element61 has also assisted Tessenderlo Group in all aspects of setting up a BI Competence Center (processes, people, methodology ...).
Following a Scorecarding and Performance Management roadmap, HDP & Arista decided to extend a Customer oriented data mart with the financial data from an ASW/FIN accounting system. The technologies involved were end to end Microsoft Business Intelligence SQL Server 2008 including SSIS, SSRS and SSAS.
The VMM wanted to provide information to internal users in order to compile their yearly reporting, follow up their measurement networks, control companies dumping dirty water, check water quality. For all of the complex design & implementation work of their Data Warehouse architecture, the VMM relies heavily on element61 data modeling expertise and technical skills.
The Corporate USG People Data Warehouse is based on multitude data sources (back- and front-office). The decision support system is used by virtually all management levels in the organization in order to get a complementary overview of the performance of the USG Group. USG country management can retrieve financial and operational details on their country performance. At VP-level, consolidated financial and operational data is available. A crucial part of the project was also working out an implementation blueprint that considerable facilitates and speeds up the integration of additional local USG People offices in the application.
Over recent years, De Lijn has deployed a large scaled data warehouse environment, currently serving over 300 users. The Business Intelligence environment on top of the data warehouse is used for reporting & analysis on subject areas like personnel behavior (driver productivity, employee sickness behavior, overtime worked, employee scheduling), ticketing information (both for operational and marketing purposes), vehicle operations (GPS data, driven kilometers, maintenance, fuel consumption, vehicle cost per vehicle age), financial data (budgets versus actual, subsidies from the government, money going to subcontracting…) and vehicle road accidents. Next to that the data warehouse also drives the De Lijn planning and budgeting application in IBM Cognos TM1.
Currently De Lijn is also building a case to implement a data warehouse appliance to keep supporting the fast-growing demand for more subject areas, more users and new types of analysis within the data warehouse.
Technologies used include IBM Cognos Business Intelligence, IBM Cognos TM1 and IBM Datastage on a DB/2 platform on iSeries.
Through the years, Jetair has been building a large data warehouse containing all their operational data to focus on the operational performance of the company. The next step was integrating all the financial data and building a companywide Planning solution to come to a complete closed-loop Performance Management environment. Hence a Planning, Budgeting & Forecasting-project was started.
The aim of the project was to automate the Profit & Loss-statement, integrating all accounts and cost- and profit centers to allow for both bottom-up and top-down planning. As part of the project, this application has been extended with driver-based data being fed to the application for some specific areas. Main focus of the project was on to the operational business of selling vacation over land (TO Overland) and by plane (TO Flight). The overhead cost centers have been integrated by basic enduser-input to come to a full P&L.