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.