News 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
Vroon 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).
Carmeuse 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.
Case study 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.
Manuchar 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.
Insights 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.