Case study: report on credit risk

Data Communication Concepts

Hadrien Lacroix

Curriculum Manager

Credit risk

  • Credit risk: probability of defaulting
  • Loanme bank wants to predict if a customer is likely to default
  • Raw data available
  • Data Exploration Analysis
  • Model training and evaluation
Data Communication Concepts

Audience

  • Non-technical stakeholders
  • Bank decision-makers
Data Communication Concepts

Story

  Puzzle piece with the word story

  • Background:
    • Increase in defaulting percentage over last 5 years.
    • Predicting which customers had a high probability of default.
  • Insight: People with more unemployment periods tends to default more
  • Insight: People with lower income tend to default more
  • Climax: Possible to predict which people is more likely to default with an accuracy of 95%
  • Next steps: Run a trial on a control population
Data Communication Concepts

Tech or non-tech

  Puzzle piece with the tech or non tech

  • Translate technical results
Data Communication Concepts

The right data

  Puzzle piece with data word highlighted

  • Audience persona
    • Role: Financing Department Director
    • Interest: Decision on implementing an automated loan rejection system
    • Appropriate data:
      • Relationship between age or income and loan default
      • Percentage customer defaulting over the next months
Data Communication Concepts

Statistics

  Puzzle piece with data word highlighted

  • Median age and income
  • Percentage of change
Data Communication Concepts

Visuals

  Puzzle piece with the word viz

  • Boxplot with age vs. default condition

boxplot with age vs. default condition

Data Communication Concepts

Visuals

  Puzzle piece with the word viz

  • Boxplot with age vs. default condition
  • Lineplot with % change defaulting customers

Lineplot with increase percentage of change in defaulting customers over the months

Data Communication Concepts

Correct format

  Puzzle piece with the word present

  • Who? Financial Department director
  • Why? Important decisions ahead
  • Content: Key findings and recommendations
  • Channel: Send the results before the meeting
Data Communication Concepts

Report

  • Written report
  • Summary report or final report?
Data Communication Concepts

Report

  • Summary report
  • Informational report vs. analytical report?
Data Communication Concepts

Report

  • Summary report
  • Analytical report
Data Communication Concepts

Summary report structure

  • Introduction
    • Purpose
    • Contextual information
    • Question of analysis
  • Body
    • Data
    • Results: Key findings
  • Conclusions
    • Restate question
    • Central insight
    • Add recommendations
Data Communication Concepts

Let's practice!

Data Communication Concepts

Preparing Video For Download...