Gora participates in all stages of building a data warehouse:
- Analysis and acquisition of data from various data sources, such as various analytical applications or other database sets. We support the transfer of data from heterogeneous sources such as relational databases from different producers (Oracle, IBM, Microsoft) or files (Flat files, XLS, XML, etc. Data transfer is carried out on a daily basis with the shortest possible time burden on source systems. Data transfer is carried out at the lowest level of detail (the possibility of a detailed analysis of business
- Designing and installing ETL system for the acquisition, integration, treatment and control of data
- Architectural design, design and manufacture of models, which are filled with the help of ETL processes. When filling dimensional models of predefined data fields the additional bulking, de-normalizing and processing is carried out. The dimensional optimization models are prepared, the materialized insights and tools caching options are designed.
The real value of the aggregated data in a data warehouse is gained by upgrading to a reporting or analytical part of solution CUBISS or Oracle BI solution. The data warehouse is the basis for further planning, forecasting or reporting within a single undertaking or statutory reporting.