DW - Meta- & Master Data Mgt

Show on team page (filter)

Off

element61 celebrates its 15th anniversary

Brussels, April 3rd, 2022 - element61, the thought-leading Business Analytics consulting company, celebrates its 15th anniversary!

maandag, 4 april 2022

Migration of SQL Server cubes to Azure Analysis Services tabular

In a prior successful project, Vroon asked element61 to design and implement a modern data warehouse on Azure Cloud for its newly developed Environment, Health and Safety tool (EHS).

BI for Finance on top of SAP (using TimeXtender and Microsoft) in Manufacturing

A former, old Data Warehouse solution existed but was too strongly SAP focused and based on SAP BW. Instead of upgrading an obsolete technology platform, Carmeuse decided to replace it by a newer modern architecture that addresses all the short comings in the old setup.

Data Warehouse Automation

As Business Intelligence is becoming mature and more of a commodity, there is pressure to achieve things in a faster & cheaper way.

Fedrus International

GDPR data mapping for Roof Construction Distributor

The Customer Fedrus International is an independent Belgian group, active in the distribution of roof and façade materials for the European market. The group consists of five operational business units: APOK, I.R.S-Btech, Laude, VM Building Solutions and, new to the group, MCP Defrancq. I.R.S-Btech promotes and distributes EPDM and other roof materials to the construction and roof materials dealer in West Europe.

Data Management, Governance and Report Optimisation for Accounts Receivable

Manuchar wanted to optimise their reporting process. As there is no central/common ERP, a well designed architecture needed to be put in place in which the various (global) affiliates could submit their data to the corporate reporting. The quality of the affiliate data must be checked automatically using technical and business validation rules.

SAP BW/4HANA: The Next-Generation Business Warehouse

SAP BW/4HANA, the Next Generation real-time data warehouse was launched in September 2016. This article gives an overview of the solution, the key benefits and the migration paths to BW/4HANA, as opposed to the previous SAP BW releases. It will also demonstrate that Data Structures, Data Integration and User Interface are significantly simplified. The article will also elaborate on the SAP BW/4HANA High Performance capabilities.

Nico Sacré

vrijdag, 27 oktober 2017

Recommended books

Star Schema The Complete Reference

One of the best books around on dimensional modelling. Adamson takes you onto a tour around the different types of dimensions and fact tables and clearly explains how to design them and how to construct your ETL. At least as good as the Kimball books.

donderdag, 22 december 2016

Recommended books

Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions

Window functions are a special construct in the SQL language that allow you to easily calculate more complex requirements, such as year-to-date calculations, moving averages, percentiles and so on.

donderdag, 22 december 2016

Spicers Belgium

Master Data Management process analysis

Spicers Benelux heeft de hulp ingeroepen van element61 om het proces rond het master datamanagement van haar 18.000 artikelen in portefeuille in kaart te brengen.