OverviewAnalyticsServicesDatabaseToolkit

Log into Client Resources section
for more information
     

RMS Data Solutions

Value Driven by Data Quality

Insurers and reinsurers have long recognized that a robust risk management practice requires not only the appropriate and well-informed use of models, but quality data describing the exposures at risk. By employing RMS data solutions in portfolio management and underwriting processes, the resulting insights contribute to:

  • Improved metrics used in underwriting risk selection and pricing

  • Reduction in portfolio management operational risk

  • Increased confidence in reinsurance transactions and portfolios

  • Improved accuracy of post-event loss estimation

  • Demonstration of effective capital allocation to rating agencies

The impact of data quality flows through the insurance lifecycle from primary underwriting through to reinsurance and retrocession, incrementally impacting pricing, profit, and capital allocation along its course. Systematic data quality measurement in underwriting leads to better risk selection and pricing. Well-informed risk selection, whether for policies or treaties, also leads to fewer surprises in the event of a catastrophe, in the form of fewer unanticipated losses or through the preemptive reduction of difficult to identify risk concentrations. Strong data quality practices build confidence in capital allocation and in responding to rating agency inquiries. Systematic data quality management practices are a critical component of overall enterprise risk management, leaving their mark each year, whether implicitly or explicitly, on a company’s bottom line.

Data Quality Framework

RMS data solutions help insurers and reinsurers assess and improve the quality of exposure data used for catastrophe risk management. Proprietary RMS data quality methodologies are based upon a framework that evaluates data quality across three dimensions: consistency—is data presented in a standard format; completeness—is data present and of appropriate resolution; and accuracy—is the data correct.

Data solutions products and services fit within this framework, satisfying the industry need to implement data quality best practices. The RMS® Data Cleansing Service addresses the consistency aspect of data quality, offering a rigorous process for data formatting, cleansing, and geocoding enhancement. RMS Data Quality Analytics, packaged in a variety of RMS products and services, deliver straightforward metrics informed by RMS models that quantify the quality of exposure data for improved exposure data completeness, accuracy and catastrophic risk modeling.

RMS Data Quality Assessment Framework

Pre-Analysis Improvement

Data Quality Analytics

Consistency

Completeness Accuracy
Is the data presented in a standard format? How much does modeled loss vary due to unknown or low resolution data? The data may be known, but is it accurate?
  • Assessment to identify obvious errors


  • Location address cleansing and formatting to ensure consistency


  • Enhancement of geocoding resolution

  • Peril and region dependent scoring algorithms quantify the completeness of exposure data at the account and portfolio level


  • Scores quantify both the resolution of geocoding and the completeness of attribute data

  • Metrics report the potential variation in model loss estimates as a result of low resolution or missing attributes

  • Formalized validation heuristics to identify inconsistent or illogical combinations of geocoding, building, valuation, and financial attributes


  • Comparison to RMS ExposureSource database of property-specific information, with the option to enhance data

  • Industry comparison metrics indicate how aggressively or conservatively data has been coded compared to industry averages
  • RMS Products and Services:
    Data Cleansing Service
     
    RMS Products and Services:
    Data Quality Toolkit
    Data Analytics Service
    ExposureRefine Service
     

     












     

     


    Data Quality Analytics Introduction

    RMS Data Quality Analytics deliver objective and independent insight into the main elements of exposure data―where it is (location), what it is (vulnerability attributes), and how much it is (valuation)—allowing insurers and reinsurers to assess the quality of exposure data input into catastrophe models. Key components of Data Quality Analytics include completeness scores and accuracy assessments—future versions will also include industry benchmarks.

    Benefits of RMS Data Quality Analytics

    • Inform underwriting, portfolio management and capital allocation decisions

    • Systematically improve data quality management processes

    • Increase consistency and confidence in data quality using standardized metrics and reports

    • Prioritize and focus actions on areas that the greatest impact on model results
       

    Data Quality Analytics Delivery Platforms

    Data Quality Analytics are currently delivered through a variety of products and services in order to address specific user business requirements.

    Data Quality Toolkit ExposureRefine Service Data Analytics Service
    Product Type MS Windows client-server application
    Consulting project engagement Subscription ongoing service
    Applications In-house capability to investigate data quality; recommended in conjunction with the ExposureRefine service Investigate or validate intuition around portfolio data quality, across lines of business and accounts (for insurers) or across select cedants (for reinsurers)
    Data Analytics Service: Understand data quality as an underwriting metric to inform account decision-making and pricing

    Data Cleansing Service: Improve and standardize input data
     
    Features
  • Assess Portfolios across Multiple Data Sets


  • Validate and Enhance Data


  • Create User-Defined Validation Heuristics


  • Create Flexible Job Profiles


  • Generate Reports at Varying Levels of Detail

  • Compare Data by Cedants, Business Units, or Over Time

  • RMS consulting expertise used to contextualize and draw actionable insights from the produced data quality metrics



  • Detailed investigations into bulk coding, bias, and accuracy comparisons with ExposureSource database



  • In-depth sensitivity analysis to assess the impact of targeted data quality improvements



  • RMS rating agency summary letter and board presentation as optional deliverables

  • Data Analytics Service:

  • Account level data quality metrics provided with cleansed data, as Microsoft Excel® spreadsheet(s) and/or EDMs

  • Data comparison and enhancement with ExposureSource database

    Data Cleansing Service:

  • Formats, cleanses, and geocodes account schedules of locations



























  •  

     

    Related Information

    Data Quality Toolkit 2.0
     

     

    Home    Contact Us     Site Help    Privacy Policy    Terms of Use    Legal

    ©1999-2010 Risk Management Solutions, Inc. All Rights Reserved.