Database Warehouse
Udirect maintains a healthy database by keeping a strict check on the following:
- Design of the database structure
- Standardization in its respective fields
- Running quality check on all fields for errors
- Rapid generation of data warehouses, data marts & data streams
- Reduced cost to design, maintain & integrate data with powerful tools for the collaboration & reuse of common metadata
- Udirect’s ETL processes are reusable, easily modified and embedded with data quality processing
- Increased returns on existing IT investments by providing multi-platform scalability and interoperability.
- Detailed reports that contain 2 customised data intelligence fields tagged onto each record
- Data Status
- Data Remark
- Summary reports that give users a final analysis of the results of selected campaigns. The information is broken down into the following fields:
- No. of Successful Responses
- Rates of Success
- No. of Uncontactables
- No. of Bad Telephone Numbers
- No. of Refusals
- No. Un-subscribed
We also run a sophisticated Extraction, Transformation & Loading (ETL) Management process that allows for the extraction of data and formats it so that the information can be accessed consistently across the entire enterprise. Udirect’s ETL Management processes give the following benefits:
Our system generates 2 reporting formats in its database management services:
