SemTalk BI provides methodolgies to design BI architectures, to model multi dimensional data marts and to develop ETL proceses. Special notations are included e.g for SAP Business Information Warehouse. Semantic models as well as logical models may be used.
Architecture of SemTalk BI Edition
The following methodologies are available in SemTalk BI:
SEM BIAM (Semtalk BI Architecture Modelling)
The architecture of a business intelligence information system environment is used to describe the individual system components in terms of their type, functional properties and interaction. In practice there are a variety of BI architecture options, which will ensure a unique focus on effective support available for sales and strategic information management processes. Data marts, source systems and core warehouses are suitable combined for this purpose.
SEM T-ADAPT (Semtalk Conceptual Data Mart Design)
Analysis and design on a conceptual base is an essential step in building business intelligence systems. Therefore, the semantic modeling of multi-dimensional OLAP data structures is a high-priority task. For this early concept-driven project phase with T-ADAPT an extension of the method ADAPT™ 'Application Design for Processing Technologies' is available. The focus of this modeling approach is the consideration of dimensions and hierarchies.
SEM ETL (Semtalk BI ETL)
The preparation of operational to dispositive databases requires in successive levels of filtering, aggregation and harmonization, as well as enrichment activities that have to be modeled in the form of ETL processes (Extract, Transform, Load). This method focuses on the conceptual modeling of such ETL activities.
SAP BW (SAP Business Information Warehouse)
The SAP® BW is the BI solution from SAP® AG, whose main component is the Business Information Warehouse (BW) as the core data warehouse solution. It is part of the BI architecture of many companies, especially in cases of the use of SAP® ERP solutions. In addition to multi-dimensional data marts based on Info Cubes also objects in the data warehouse architecture are important, and the connecting transformations in the description of logical data models based on a SAP® BW basis.