Copia LogoCopia Consultancy Services

Copia Products - Data Management - Customer Data Hub

Customer Data Hub ( CDH ) is a product which collects data from various sources in one place.
It then applies the Relational Database Management principles and normalizes the data in suitable tables
Post that it helps users to build required analytics and use this data for various marketing or other activities.

Application Overview

CDH is a web application and can be accessed from anywhere. To login, you need to have valid user ID and password. Once you log in, your access is based on the role allocated to you.

Data Management

CDH pulls data from multiple applications. Based on what data is pulled such as material master, customers, contacts, purchase data and so on, each data set has its own rules to fetch and store the data. Each data type can have different frequcy of update.Attendnace can be recorded using Mobile phones. Optiona features of Selfie, Geo Location tagging with provision to record weekly off & holidays.

Data Normalization

All such data pulled in multiple ways, is stored in different staging tables. The data sets have control keys and based on which the data is normalized in separate set of tables for reporting. These tables are then used in reporting functions.

Data Analysis Parameters

User has to define what type of analysis is needed. Like customer purchase history, for how long & what kind of data reprots are needed. Based on such parameters, reports can be generated.

Reporting Tools

User can select multiple fields and columns for building own reports. User can also write new queries and create own reports. These reports can be downloaded or graphical outputs can be generated for such data sets.

Integrations for marketing

This section deals with integratings with marketing tools such as Whatsapp, SMS or email marketing. It can also be posted on various social media tools automatically.

Users and Access Setups

Users in an organization can have multiple roles. Roles can be admin, report user, data analysis engineer and so on. Based on your role, you get required access to the application.

Data Safety & Security

Data is stored in multiple layers and so its difficult to get one set in one go. Plus system uses obsfucation, MD5 hashing and JWT tokens to manage application security apart from security layers at the application level.

Data Privacy

Users can be restricted not to allow right clicks, download or can have only limited access for the application. Entire application as such is governed by our data provacy principles.