DW - Data Warehousing & Modeling

Finance Business Intelligence project on ASW/FIN

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.

Business Intelligence Program management in Financial Services

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.

BI Phase I - Finance

After a Business Intelligence & Performance Management roadmap, Essers decided to define a first Business Intelligence iteration focused on the financial data of IBS ASW-FIN (on AS/400 - iSeries).

New Business Intelligence architecture in Staffing Sector

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.

Vlaamse Milieumaatschappij (VMM)

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.

Data Warehouse for Soudal

In parallel to an ERP migration program from Baan to SAP, Soudal decided to implement a new data warehouse. After a BI roadmap exercise by element61, MS SQL Server 2008 was selected as technology platform for the new data warehouse.

OCMW - CPAS Brugge

Business Intelligence in the Social Sector

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.

Vandeputte Safety

Business Intelligence on top of SAP, without using SAP Business Warehouse

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.

Vlaamse Vervoersmaatschappij De Lijn (VVM)

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.

From batch to real-time reporting and analytics

With the emergence of digitization and IoT, it becomes crucial for some companies to enable faster decision making through faster data insights. Gone are the days when everyone can wait for hours or days to look at insights and performance dashboards. In this insight, we have proven that providing these real-time insights means a change in system architecture for many business intelligence teams. In our expert opinion, we concluded that a best-practice real-time architecture consists of two main building blocks: a receiving end-point to receive the data streams and a real-time analytics layer to transform the data. We conclude that getting started with real-time analytics isn't complex: all leading vendors as well as open-source providers offer a serious of proven solutions and as solutions are offered through the cloud, they start with no investments needed (pay-as-you-go basis).

Bart Van Der Vurst

Bart Van Der Vurst

Vendredi, 21 octobre 2016