Business solutions for you portfolio

About

Company: Hanex AG, Poznan

Technology: Microsoft Excel and VBA

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Mar 2005 – Sep 2005

Cost: no details


Support in the creation of an MSI for the group management of the company HANEX. The basis for this application is an Oracle database. Using Hyperion Essbase, multidimensional data structures are generated and mapped in Excel. The goal was to create consolidated reports for the management from these multidimensional data structures using Microsoft Excel and VBA. The project was implemented using Microsoft Excel and VBA.

  • Create a data warehouse with the data from different sources.
  • Loading 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.
  • Loading data from distributed and differently structured datasets.
  • Separation of the data used for the operative business.
  • Provision of the necessary infrastructure (Oracle, Excel, Essbase Add- In etc.).
  • Access to the necessary provided data via Excel Add-In (Essbase).
  • Filtering, sorting and refining the data using MS Excel (VBA, Array).
  • The Excel reports are created using VBA.
  • Creating the queries for data reference (SQL).
  • Interface development from SAP to the data warehouse (LDAP, ABAP).
Back to the portfolio
Order a similar project
Order a project

+41 (0)44 586 53 45
+41 (0)76 737 00 84
+41 (0)77 915 25 52

 

info@bs4y.ch

Order a project
Tell us what kind of project you want to do.
Name
E-mail
Want to order
Upload your brief
For message
Submit project request

User Agreement

With this questionnaire (application) I officially express my consent to the processing (collection, systematization, accumulation, storage, clarification, (updates, changes), use, distribution (including transmission), depersonalization, blocking and destruction), including automated, my personal data specified in this Questionnaire (application), in accordance with the requirements of the law "On personal data".

The personal data specified by the client are provided for the purpose of communication with the client, as well as for informing about other products and services. Consent is provided from the moment of filling of this application for the entire life of the client.

This consent can be revoked by the client upon submission of an application in simple writing in accordance with legal requirements.