You are here

DW - Data Warehousing & Modeling

23 Nov 2017 Thursday
Join us on Thursday November 23th, 2017 at our annual element61 SAP Business Analytics & Performance Management event. With over 140 participants year after year, this is the most business focused event to understand which SAP Business Analytics solutions

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

Adrien Constant's picture

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.

15 Nov 2018 Thursday
Join us on Thursday November 15th, 2018 at our annual element61 SAP Business Analytics & Performance Management event. With over 140 participants year after year, this is the most business focused event to understand which SAP Business Analytics solutions
29 May 2018 Tuesday
Invest 1/2 day to learn all about or update yourself on the IBM Business Analytics portfolio! Learn from best practices and network with other local IBM Cognos users.
08 Mar 2018 Thursday
Join us on March 8 th, 2018 at our element61 Microsoft Business Analytics Day focusing on delivering business insights using the Microsoft portfolio.

Build data warehouse layer

Tom Graft's picture
Placeholder

Supporting the BI Analyst in further developing the DWH environment using SSIS and SQL Server 2016.  The ultimate goal is to accelerate the delivery of reporting to the business (Crew, Finance, Ship Management, ...).  In addition, there is a migration process that links existing ETL, which is now directly linked to the source systems, to a central database system that is considered to be the "single source of truth".

18 May 2017 Thursday
Invest 1/2 day to learn all about or update yourself on the IBM Business Analytics portfolio ! Learn from best practices and network with other local IBM Cognos users.

A. Schulman Plastics - Finance Cost Center reporting

Tom Graft's picture
Placeholder

The goal of the project was to have standard management report on functional level, with drill-down/drill through functionality to a number of predefined reports/dimensions.
In addition, a self-service query model was made available which allows controllers to easily and quickly do their functional cost analysis. The data needed to be available at the lowest level grain (BPCS journal line level). Hyperion budget data (and non-BPCS actuals) was added to the level of BPCS CostCenter.

A. Schulman Plastics - Sales

Tom Graft's picture
Placeholder

Analysis/Design and Build of data warehouse and reporting environment of all Sales related reporting/analysis requirements.  Project was executed with a mixed team of element61 resources and ASI resources (both local and near shore in UK and Poland), managed by element61 project management.  All development was done in a coaching and co-development model between element61 and ASI resources.  During this phase of the project the existing non-sales legacy environment was uplifted from Cognos 8 to 10 (Cognos datamanager and Cognos BI).  Main source system for this was BPCS

Pages

Subscribe to RSS - DW - Data Warehousing & Modeling