Please enable JavaScript.

Coggle requires JavaScript to display documents.

CEI+ (Churn Model, ARPU Model, CSAT Model) - Coggle Diagram

- - - - Descriptive
        
        Touchpoints
        
        QMChat
        
        Data Discovery
        
        check the columns of each table and the used fields
        
        Data Quality Checks
        
        null percentage
        
        data types
        
        Forming KPIs
        
        extract the available KPIs which are related to business
        
        Aggregate KPIs Per Subscriber
        
        Intermediate Layer
        
        Final Layer
        
        Extracting Statistics
        
        the value distribution of each KPI
        
        Determining & Removing Outliers
        
        based on the percentiles
        
        Churn Rate
        
        Calc. P-Value
        
        Correlation Between The KPIs and Churn
        
        < 5% Accepted
        
        5% Rejected
        
        Chi Squared Statistical Method
        
        Determine the Model Features
        
        Positive
        
        Negative
        
        KPIs Binning
        
        Manual Binning if needed
        
        Determining each KPI Weight
        
        based on the relation with churn
        
        Calc. Touchpoint Score
        
        Data Sourcing
        
        Determine the suitable data sources
        
        Further Analysis and Investigations
        
        Network
        
        Retail
        
        Call Center
        
        MYSTC App
        
        SMS900
      - Predective
    - - Descriptive
      - Predective
    - - Descriptive
      - Predictive
  - - - Descriptive
    - - Descriptive
    - - Descriptive