Business Analytics Strategy

Integrated Performance Management in the Public Sector


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.

Senior Data warehouse Design & Project/Program Management


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.

Implementation of a Performance Management architecture & setup of a BICC within an SAP BI Context


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 ...).


S'abonner à RSS - Business Analytics Strategy