Change/Create Data

In Your Analytics Environment

Without IT Intervention

WHAT IS RETOUCH ?

ReTouch is a web-based solution that enables your business users to prepare and manage data assets in DWH/BI systems for analyzing reports and making decisions with full traceability.

Web Interface

Web interface based on google sheet and excel.

Cell Based

Cell based multi editing.

Column Update

Column based update.

Copy & Paste

Copy & paste from Excel.

OUR CORE FEATURES
1
Supported Platforms

Oracle, MySQL, MS SQL, Amazon, DB/2, Sybase, PostgreSQL, Teradata, Exadata, SAP HANA, Hadoop, Amazon Redshifton google sheet and excel.

2
Export/Import file types

CSV, FTP, Excel, TXT, XML, JSON

3
Table Operations

Table select, create, alter, drop, rollback and data entry, edit, delete

4
Multitasking

Multi-user editing and Multi-object editing

5
Data Quality

Creating data quality validation rules

USE CASES

Inconsistent data in reports :
Latency of defining reference data (such as tariff code, reseller id, branch id etc) in ERP systems while the transaction data is already in DWH system.

Generally, the hierarchy on which the enterprise reporting is based is built on the financial reporting criteria. However, departments such as Sales or Marketing may have different hierarchies which they want to use when viewing their reports.

In many enterprises, the information regarding targets may not be present or different revisions may not be tracked in the enterprise systems, this targets and their revisons are typically keept on Excel.

Any known data problem on the source system may take a long time to correct which means the reports will show incorrect data untill the issue is resolved.

WHAT IS RETOUCH FOR?

No need to extract the data from DWH and join with excel files to produce the required reports.

Delayed reflection of data from enterprise systems to the BI and DWH platforms (master data, reference data, conformed dimensions, hierarchies, meta data and parametric tables)

Versioning of the changes like yearly targets, sales hierarchy etc.

Different hierarchies /structures need while representing data from the same platform.

RETOUCH = SOLUTION
SOLUTION RETOUCH