Mensura have based their BI architecture on the MS BI platform, including the available 3rd party extensions and improvements Targit and TimeXtender. TimeXtender is used as a data warehouse automation tool to speed up the ETL development process, whereas Targit is implemented as a user-friendly front-end – an alternative to MS Excel - on top of MS Analysis Server cubes. Mensura have selected element61 as the partner of choice for support them in all of these technologies.
DW - Data Warehousing & Modeling
In 2011, OCMW Brugge started with a new data warehouse. The focus of the first iteration was HR reporting & analysis based on data from the operational HR & personnel application InfoHos. The application contains personnel information like contracts, work place, work regime, activity center, absence & illness and a payroll engine. All the information is extracted and transformed to the data warehouse, where the information is enriched with budget information and transformed into FTE-based calculations, given varying working regimes. Several types of reports are created on top of the data warehouse. As a public municipality organization, OCMW Brugge needs to publish statistical information on the use of funds and personnel related activity. Next to information for top management delivered via Analysis Services 2008, also Reporting Services reports help managers at all levels to follow up more operational activities.
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 element61 SAP BW Competence Center has been leading an SAP BW 7.0 implementation at Tecteo between 2009 and 2013. The main focus areas of the project are marketing related reporting on top of SAP CRM and financial reporting on top of SAP IS-U.
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.
element61 has delivered a comprehensive BI project on behalf of Vandeputte Safety. The main challenge in this project was to extract data from an SAP ECC 6.0 ERP system, without using the intermediate SAP Business Warehouse layer, using a Microsoft SSIS solution. This project has been very successfully, delivered in time and on budget, serving a business audience of 100+ end users.