Sketch a layer architecture for the new BI landscape of example company

— 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?