Support with the creation of an MSI for the corporate management of the company HANEX. An Oracle database forms the basis for this application. Multi-dimensional data structures are generated using Hyperion Essbase and mapped in Excel. The aim now was to use Microsoft Excel and VBA to create consolidated reports for management from these multi-dimensional data structures. The project was implemented using Microsoft Excel and VBA.

• Creating a data warehouse with the data from different sources.
• Load data into the data warehouse using ETL processes.
• Data mining of the long-term data stored in the data warehouse
• Evaluation of this data warehouse data.
• Load data from distributed and differently structured databases.
• Separation of the data used for the operational business.
• Provision of the necessary infrastructure (Oracle, Excel, Essbase Add-In etc.).
• Access to the necessary data provided by means of an Excel add-in (Essbase).
• Filter, sort and refine the data using MS Excel (VBA, array).
• The Excel reports are created using VBA.
• Creation of the queries for the data reference (SQL).
• Interface development from SAP to the data warehouse (LDAP, ABAP).