DWH – Data Warehouses

The BI division specializes in the design, establishment and testing of data warehouses (DWH) in Enterprise organizations, while implementing a range of leading global platforms (Microsoft, Oracle, Teradata and more)
Over the past few years the division carried out many projects involving rewriting of existing data warehouses, establishment of Data Marts and processing of Data Cleansing testing procedures.
The projects were based on a comprehensive methodology called Eternity Smart which was maintained for years.
The establishment of data warehouses, upgrades or implementation of new products commences at the business specification stage, through architectural design, data mining, Source to Target and establishment of the three tiers: MRR, STG, and DWH.

Establishing Organizational Data Warehouses
Management commitment and involvement is the foundation for a successful establishment of organizational data warehouses.
The following stages are required towards the establishment of a central data warehouse:
  • Stage 1 - A strategy is defined, to include main topics of interest, business entities and common dimensions.
  • Stage 2 - An overall architecture for the central data warehouse is formed. This is achieved for the short, medium and long terms. This process includes a first level review of the data and the existing and/or missing systems and interfaces.
read more
  • Stage 3 - Defining the data requirements and levels - this process includes the type of use to be made by the organization in reports and/or reviewing interfaces, data interfaces to existing systems and the needs of top and medium management as well as those of all users, while emphasizing the reviewed topics.
  • Stage 4 - Selecting the most suitable technology and top level specification for the organizational data warehouse. After the structure of the data warehouse has been defined, alongside its method of extraction and usability, a number of processes can be initiated in parallel:

  1.  Examining technological alternatives in support of ETL processes, reports and the formal structure
  2.  Writing and preparation of a top level specification for the central data warehouse which includes, among other factors, a definition of the data model
  3.  Stages of implementation and launching, risk management (financial), and more detailed estimates of cost, time, etc.

Upon completion of the process, a technological addendum will also be issued, presenting all alternatives that were examined, as well as results and recommendations.

More details