As part of another project, a data warehouse (DWH) is currently set up for the German branch of a global group operating in the retail sector. Based on this DWH, a multidimensional tabular model is built to create an opportunity for in-depth data analysis.
Supplement
The DWH currently contains, among other things, sales information from the company's various stores. This sales information is prepared for a transparent analysis possibility and made available for the various specialist departments by means of a multidimensional tabular model.
Subject description
The Tabular Model is to be used by the departments purchasing, sales, accounting and controlling as well as the management. The focus is here at the 'self-service' of the user. The solution is to be set up in such a way that users can analyze the data themselves without the help of the IT department. A further requirement is that it is always possible to understand whether the data provided is up-to-date. For this purpose, end-to-end monitoring of data provision must be implemented.