Data Analysis

Data analysis is the process which involves profiling the legacy data thoroughly to understand its structure, content, quality and integrity.

Using our in-depth knowledge of Insurance data we can carry out an independent unbiased assessment of your data which can include database records, spreadsheets, text files, scanned images and paper documents. All these data formats can be migrated to a new system.

Depending on exact requirements and your budget we will either use advanced data profiling software or analysis using SQL scripting or a mixture of both.

Each table, row and field in your databases will be analysed with reports written detailing its accuracy and completeness i.e. where there are quality issues, gaps in the data, redundant columns, duplication and validation problems etc.

As part of this exercise we can help you examine the age/value of your data. This is useful when deciding whether to migrate all or part of your datasets. Detailed extraction scripts based on your criteria can filter out information i.e. on or after a certain date. If migrating, why bog down a new system's performance with data unless it’s useful and needed for trend analysis. Given our knowledge and expertise of insurance data we have also on occasions helped our clients produce trend analysis /management information reports at given periods daily/weekly/monthly as well as aggregation of information for intelligent views of customers, policies and risk information.