Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data Analytics (Data Governance (Dictionary (Transformation (Data Linage),…
Data Analytics
Data Governance
Dictionary
Transformation
Data Linage
Table Structures
Content
Format
Business Rules
Codes
Class
Macro : usage, return value, parameter
Customize Function
Business Request Form
Manual format [Ms. Word]
Web
Policy and Procedure
SOP
Policy
Backup Plan
SVN Subversion
Copy to 28
Gitlab
House Keeping
Local 28
per 3 months data deletion
Server
Monthly
per 3 Months
Yearly
Standardized Format
Data Modules
MASTER
PRODUCT : [MST_PRODUCT]
Master Zipcode
Etc detail in excel for Master
RAW
POLICYS
Raw POLICYS : [RAW_POLICYS_YYMM]
Raw POLICY GROUP : [RAW_GLH_POLICYS_YYMM]
PHOLDER
Raw PHOLDER : [RAW_PHOLDER_YYMM]
BENEFICIARY
Raw BENEFICIARY : [RAW_BENEFICIARY_YYMM]
COVERAGE
Raw Coverage Monthly : [RAW_COVERAGE_YYMM]
INSURED
Raw INSURED : [RAW_INSURED_YYMM]
CLAIMS
Group
Raw GLH Claim Detail
Raw GLH Treatments
Raw GLH Claim Provider
Raw GLH Hospital Benefit
Raw GLH Incident
Individu
Raw Indv Claim Provider
Raw Indv Claim Detail
Raw Indv Treatments
Raw Indv Hospital Benefit
Raw Indv Incident
INTERMEDIATE
Int Customer Individu Monthly [INT_CUST_INDV_YYMM]
int Policy Holder
Customer
CSV
Customer Contact Management
DM : [DM_TABLENAME_YYMM]
Customer Insight
NPS
Analytics
Campaign
dm_Customer_Portfolio
MDM SVOC
OCDM
Customer Profile
Account & Contact
Demography
Life Stages & Status
Registration ID
Financial Account
Customer ID Master Issuing
Source Channel Tracking
Segmentation & Tier
Agent Code
Agent Demography
Agent Hierarchy
Agent Productivity
Form & Documentations
Contact & Communication
Policy Reference
Roles & Relationship
Infra Structure
Server : [IDWPRD94][10.129.34.88][Windows Server 2012 R2]
Database SQL Server 2012 [IDWPRD94][yfachru][port:1433]
IDAA : Database contains raw, int, dm etc
MLIAA : Database for Pentaho Repository [ETL]
Data Integration SQL Server <-> SAS Enterprise
Anaconda Server
Python
Jupyter - iPython
Data Scientist Story Telling
R
Orange Python [
https://orange.biolab.si
]
[PBI] Power BI
Web Based Setting and training
Visualization
Power BI
Tableau
Jupyter
D3Js
Data Quality Management
360° Customer Single View
Customer Characteristics
Descriptive
Life Stage
Location
Demograpics
Relationship History
Interaction
Transaction
Operational
Social
Family
Corporate
Online
Offline
Customer Insight
Needs
Strategic
Temporary
Real-time
Satisfaction
Underlying
Immediate
Value
Profitability
Lifetime value
Wallet share
Analysis
Base Profile
- (Age, gender, channel, platform, version, geo, primary use, browser, contact)
Social Platform Profiles
- (likes, dislikes, demographic)
Tenure
- Days since the first time they did something
Recency
- Days since the last time they did something
Frequency
- Count how often they do something
Monetization
- count or rank of how much they spend
Sociability
- count or rank how social they are
Engagement
- count or rank of how engaged are
Movement
- what types of movement have they done
Data Cleaning
Remove duplicates
Imputation
missing/blank/null value
Trim heading & trailing
Enrich data by adding additional fields to support cleansing process
Data Standarization
Standard Format
Standard Structure
Standard Data Type
Standard Business Rules X-Systems
Data Validation
https://en.wikipedia.org/wiki/Data_validation