PROMATIS Business Intelligence creates a clear view to make the right decisions

Exacting, better and faster business decisions – these are the challenges on the market today, that culminate in the much propagandized real-time enterprise. Systems, which are transaction oriented, are usually swamped here, even though they provide valuable data. The solution’s name is Business Intelligence (BI), thus the provision of business knowledge based on data in real time.

PROMATIS – Solution partner for Business Intelligence

Since more than 20 years now, PROMATIS implements business intelligence solutions based on Oracle. The strength of PROMATIS BI specialists lies in the combination of business and technical expertise. The preferred platform is the Oracle Business Intelligence Suite in combination with the Oracle Enterprise database (incl. Essbase, In-Memory, Data Mining, etc.), Oracle Hyperion EPM and Oracle Analytic Applications. We prefer Oracle Endeca for information discovery – also in conjunction with Oracle Applications. Apart from the proven Oracle On-Premise products, there is an increasing demand for relevant cloud services, especially in projects with a strong innovative character and high requirements regarding scalability. In client projects we also use third-party products if needed, including BusinessObjects, Cognos, Informatica, QlikView, or SAP BW.

Data Warehousing

The quality of the BI results depends primarily on the quality of the basis data. In many cases the existing volume of data must be consolidated first in comprehensive Data Warehouses or in range- or task-specific Data Marts and summarized if necessary. Our BI specialists take over conception, design and development of the Oracle Data Warehouses as well as multi-dimensional Data Marts. Besides that we plan and realize the necessary processes for extraction, transformation and loading (ETL) of the data into the Data Warehouse.

Reporting and OLAP

When using data, flexibility has the highest priority. This reflects in our solutions for business intelligence portals, enterprise reporting, for ad-hoc-query and analysis as well as detailed online analysis and planning. According to the requirements we also use transaction systems next to data warehouses and data marts. For this purpose we use materialized views. The presentation of results takes place in print media, on the web or on mobile devices (smartphones, tablets). Our experience portfolio is comprised of the following components: Oracle BI platform 12c, 11g and older, Oracle Analytic Applications, Oracle Hyperion EPM, BI Publisher, and Discoverer.

Business Performance Management

In the business performance management key indicators are derived on the basis of company targets and success factors, over which the business performance can be measured. Based on these key performance indicators (KPI) a monitoring and an early warning system are developed, which interact over customizable web portals and mobile devices with the user. In Oracle environments completed applications such as Analytic Applications and Hyperion Enterprise Performance Management (EPM), individual portal solutions with “consumer-style” data visualization or Oracle Business Activity Monitoring (BAM) are used.

Data Mining

Data Mining provides for automated recognizing of hidden connections within the data and makes statements for the future, due to historical values, possible. The PROMATIS experts possess conceptual Data Mining know-how – in particular concerning the implemented algorithms – and the experience of build-ups and utilization of Data Mining applications. Preferred we work with Oracle Data Mining, an option to the Enterprise edition of the Oracle database.