Architecture and data management
Budget: €8 – €30 EUR
-- consider an example company.
-- This example company would like to implement its contribution margin calculation with
the help of a new BI landscape.
-- Data can be drawn from the following operational source systems:
-- Source system 1 with product, customer and sales data.
-- Source system 2 with costs at product and material level
-- In particular, a report with the contribution margin calculation
should be made available to the users as a result.
-- Sketch a layer architecture for the new BI landscape of the example company using the
classic hub-and-spoke approach.
-- For those databases that result from the source systems and the report for the profitability
analysis, characterize the form in which they are held in the various layers.
-- Name the main functions of the ETL processes between the individual layers and explain
them using the database of the example company.
-- What challenges in the area of data management do you expect in the context of the
example company?
-- This example company would like to implement its contribution margin calculation with
the help of a new BI landscape.
-- Data can be drawn from the following operational source systems:
-- Source system 1 with product, customer and sales data.
-- Source system 2 with costs at product and material level
-- In particular, a report with the contribution margin calculation
should be made available to the users as a result.
-- Sketch a layer architecture for the new BI landscape of the example company using the
classic hub-and-spoke approach.
-- For those databases that result from the source systems and the report for the profitability
analysis, characterize the form in which they are held in the various layers.
-- Name the main functions of the ETL processes between the individual layers and explain
them using the database of the example company.
-- What challenges in the area of data management do you expect in the context of the
example company?