Kernel Matters

MFC Capstone Project 

 Kernel Matters

MFC Data 2012-2016.

  • The Datasets comprises of :
  • Customer Data 
  • Invoice Data       
  • Inventory Data  
  • Plant Data
  • Data Cleaning & Preprocessing

  • Cleaned the columns of Area, City & State with the pin codes in invoice data. Pgeocode library
  • Masking Values from Original Data Columns > Cleaned Columns Which Are Null after cleaning.
  • Merging Duplicate State Names.
  • Deriving Service_Time info =  Invoice_DateTime - JobCard_DateTime
  • Geolocation Based Analysis

  • Ownership Pattern across India
  • Top Car Brands in India
  • North  Zone
  • East  Zone
  • North East Zone
  • Central Zone
  • West Zone
  • South Zone
  • MFC's Revenue
    State-wise

  • MFC's  Revenue - India's Choropleth Map
  • MFC's  Revenue  among statesLog values of  Revenue (For better visualization )
  • MFC's  Revenue Trend Yearly - Yearly TimeFrame Choropleth Plot.ly offline
  • Revenue Trend Year-wise in Indian States - SunBurst Plot.ly
  • MFC's Revenue 
     States > Car Brands > Car Models 

  • State-wise Car Brands & Models that generates MFC's revenue ?
  • Mahindra & Maruti Suzuki leads in most of the states w.r.t. revenue
  • Order Type > Avg Service Time 

  • SMC Value Package   : 0 days 00:13:54
  • Repeat Order              : 0 days 04:17:56
  • Running Repairs         : 0 days 06:07:26
  • SMC Redemption      : 0 days 07:08:20
  • Mechanical                  : 0 days 09:08:43
  • Paid Service                 : 0 days 23:34:24
  • WBW Order                  : 1 days 04:22:57
  • Accidental                   : 4 days 05:09:41
  • Workshop Damage     : 25 days 01:54:20
  • MFC's Revenue 
    Order Types > States

  • Accidental 
  • Paid Service
  • Running Repairs
  • Generates more than 80% of MFC's revenue
  • Order Type Distribution - Pie Chart -Plot.ly
  • Order Type MFC's Revenue  - Pie Chart -Plot.ly
  • MFC's Revenue 
      Order Types > State > Workshop 

  • Overview 
  • Accidental - Order Type in Top 3 states and Top 3 worshops
  • Tamil Nadu --> 1Guindy 2Nerkundram 3- Ambattur
  • Maharastra --> 1- Nashik  2- Pimpri-Pune  3- Thane
  • Punjab         --> 1- Shivalik 2- Sas Nagar-Mohali  3- Gill Road-Ludhiana
  • MFC's Revenue 
      Origin > Manufacturer > Model 

  • Customer Origin &  Ownership pattern w.r.t MFC's revenue ?
  • Customer Referral
  • Employee Referral
  • Outdoor Campaign
  • Customer Lifetime Value Prediction

    CLV      = Avg Spend/ Churn Rate

    Spend = How much Customer has spent over their Lifetime 

    Churn = Dead Customers / Age of Customers



    Actual v/s Predicted Freq of repeat transactions

    Number of customers visited once
    RFM value by Predicted Model 
    Market Segmentation Approach
    Recency (R): 
    Days since 
    last purchase
    RFM Score Calculations



    Monetary Value (M): 
    Total money
    customer spent
    Frequency (F): 
    Total number 
    of purchases
    Clusters on Kms reading
    Clusters on Labour Amt
    Snake Plot
    Loyal customers, New customers and Churn customers Distribution 

    Frequency vs Recency
    Revenue vs Recency
    Frequency vs Revenue

    Observations

     * 64.34 % customers have visited only once



    * High Value Dead Customers 


    * Accidental Orders generates high revenue


    Suggestions

    MFC should retain these customers
    by
    Loyalty Program

    ( loyalty points for each service which can be redeemed on future subsequent visits to increase customer retention rate and  increase Customer Lifetime Value )




    Retain these dead customers with loyalty programs



    Display Hoardings of Car Roadside Assistance & Breakdown Services on National High Ways

    Observations
     

    * Customer refferal  generates high revenue 
    ( Refferals depends on  satisfaction of existing customers )



    * Target Kms Counter Reading 
    of existing customer



    Suggestions


     Improve
     Order Type Service Time of exisiting Customers


    MFC's Tech Team
    come up with 
    Market Sell Price of existing  customers 
    Used Car
    For selling  
     Sell your Car with MFC's 

    Give us your valuable #feedback 
    Type in Chat or Scan QR-code below with mobile scanner app (code : 661801)
    How was the presentation ?

    Awesome

    Excellent

    Good

    Bad

    Go to app.deckdeckgo.com/poll and use the code {0}
    Awaiting votes

    Thank You

    Seema Yadav

    Shamiyaz Motorwala

    Shakil Shaikh