DWEM® – Data Warehouse Enterprise Modeler

Build your own DWH with a simple, user-friendly interface!



DWEM FUNCTIONALITIES

+

Data Extraction

The process of retrieving data from one or more data sources for further data processing or data storage.

n

Data Staging

Development of procedures for transmission of data and structure from the source systems to Stage 1 (part of DWH) in a 1:1 ratio for the purpose of filling the data warehouse and load reductions of the source systems.

ETL

ETL is a series of procedures to extract, transform and load data from the source systems, ie Stage 1, to Data Warehouse.

Data Warehouse Modelling

DWH systems modeling is performed in order to analyze and define data requirements that are needed to support organizational business processes.

Well designed data model built according to the best practice rules will provide great analytical power of the future system and therefore provide better decision support.

Predefined Reports

Predefined reports provide user access to information at the level of individual business units, or the entire enterprise.

Users have the ability to view reports and analytics, and the ablity to monitor KPI’s through the Dashboards.

All predefined reports will be made in Microsoft technology (primarily through Excel).

Notifications and Administration

Provide the ability to administer and manage  the DWH/BI system – setting user rights, night processing of ETL etc.

DWEM ADD ON’S

DWEM Business Modules

Our Business Modules include Finance, Sales & Distribution, Purchasing, Warehouse, Human Resources, Manufacturing, Controlling, Planning & Forecasting, Calendar, Business Dimensions, etc..

DWEM Industry Solutions

Retail, Wholesale, Hospitality, Bakery, Money exchange, Banking, Leasing, Customized..

DWEM Connectors

Connectors to your data sources such as: SAGE ERP, Microsoft Navision ERP, Micros Fidelio Opera PMS, Pantheon ERP, POINT ERP, Mobilisis, Repsly, etc.

DWEM Custom

You can create your own custom DWEM by expanding our pre-defined modules or add additional modules or connectors.


DWEM WIZARD

 

 Defines the database connection

Defines the data sources (tables)

Defines Custom SQL – for complicated tables

Generates scripts for table structures

Starting and scheduling functions

Defines Manual Data Entry tables

 

 

 

Dashboard for ETL process monitoring

Generates documentation in PDF

DWEM PRICING


Developer License

  • Named – User license              .
  • All functionalities required to develop a DWH
  • Import / Export of ready to use DWEM modules and connectors
  • PRICE UPON REQUEST

Developer Runtime

  • Company license – depending on the number of emloyees:
  • Small: 10 -50
  • Medium: 50 – 250
  • Large: > 250
  • PRICE UPON REQUEST

Model Runtime

  • Company runtime license – depending on the number of employees:
  • Small: 10-50
  • Medium: 50-250
  • Large: > 250
  • PRICE UPON REQUEST

Extractor Runtime

  • Company runtime license – depending on the number of employees:
  • Small: 10-50
  • Medium: 50-250
  • Large: > 250
  • PRICE UPON REQUEST

Contact us today and get access to DWEM, as well as our other products and services:

4 + 11 =