Weber Stephen wanted to rebuild its BI environment due to the change in the European organisation structure that was planned to take place in 2014 and 2015. element61 was selected to execute this project in close collaboration with the Weber Stephen team. The project delivered a new data warehouse platform which consolidated data ensuring the "one version of the truth", streamlined reporting processes throughout Europe and more visibility on the process of loading data. The delivered data platform ran at a lower TCO and enabled future projects such as improved budgeting and forecasting.
DW - Data Warehousing & Modeling
Given the nature of its business, MSF Supply is an organization that has to deal with a lot of data. In order to optimize some of its business processes and to better serve the operational units that work in the field, MSF Supply is looking to improve its reporting and analysis capability.
In order to achieve this, MSF Supply has defined a comprehensive and enterprise-wide BI initiative that includes the construction of a data warehouse, next to setting up a best-practice reporting and analysis environment. The technology selected consisted of the MS SQL Server 2012 suite, including SSIS, SSAS, SSRS and MS Master Data Services.
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.
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.
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.
In 2009, USG People decided to start building out a completely new Data Warehouse and Business Intelligence infrastructure, based on a design that was previously made by element61.
The USG People Belgium data warehouse is based on a multitude of data sources (back- and front-office). The decision support system is used by virtually all management levels in the organization, its affiliates and offices.
Reynders Labels was looking for a BI solution to replace their inadequate Excel reporting solution. element61 built a Microsoft SQL Server based BI solution for them, in a Software-as-a-Service ("Cloud") architecture. The scope of the project was to provide a reporting and analysis environment focusing on the production data of their printing presses.
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.