Data Visualisation

Motion charts are a great way of visualising trends and patterns in data and showing several dimensions simultaneously.

The concept was first developed several years ago by a company called Gapminder and popularised by its founder, Professor Hans Rosling, in a much acclaimed lecture on the developing world.  In 2007 Google acquired Gapminder's Trendalyzer software which incorporated motion chart technology. Google now make their own motion chart API freely available via the Internet.

We have used this technology to bring to life some of the information contained in Statistics Relating to Lloyd's through a series of case studies. The case study shown here uses anonymised samples of the data contained in Statistics Relating to Lloyd's. For access to the unrestricted version (i.e. all syndicates shown) please click here.

Syndicate Summary Financial Statements

A visual representation of the type of data found within the syndicate financial statements.

 

The chart above can be used to visualise Syndicate Summary Financial Statements from the Statistics Relating to Lloyd's.  The data used in this chart is based upon a random set of syndicates that have been anonymised (syndicates have been labelled A to I).  

 

 

In the default example above, the size of the bubbles corresponds to Net Earned Premiums (£M) and the colour is unique for each syndicate.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Activate the motion chart by clicking on the play button (bottom left corner of chart). You can watch the size of the bubbles change as NEP values change over time. The bubbles move around the chart to illustrate changes in NPW and pre tax profit. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The power of visualising data in this way becomes much more apparent when viewing all Lloyd's Syndicates in the chart. You can access the unrestricted version by subscribing to Statistics Relating to Lloyd's.

 

Create Your Own Motion Chart

With Google's API, creating motion charts like the ones above is reasonably straightforward. More details can be found on their website. If you have any questions about these charts, how to build your own charts, or any general feedback, please email us at Stats@Lloyds.com.

 

Excel Motion Chart

As an alternative to using Google motion charts, Lloyd’s Business Intelligence team have developed an Excel version that mimics much of the functionality of the Google charts. The advantage of using the Excel version is that you can run it from your desktop.

Download your free Excel Motion chart.xls

The Motion Charts are provided for general information purposes only. Whilst all care has been taken to ensure the accuracy of the data contained in and displayed by the Charts, Lloyd's does not accept any responsibility or liability for any errors or omissions. Lloyd's does not accept any responsibility or liability for any loss to any person acting or reframing from action as the result of, but not limited to, any statement, fact, figure, interpretation or representation contained in or obtained from any Motion Chart. The Motion Charts utilise Google Visualisation API and therefore your use is subject to Google's Terms of Use, in addition to lloyds.com terms & conditions. Lloyd's reserves the right to cease providing any or all parts of the Motion Charts immediately without notice or cause.

Access the full version - visualisation

If you have a lloyds.com account and valid subscription to Statistics Relating to Lloyd's, you can view the full Motion Charts using the links below:

Case Study Financial Statements
Case Study Performance By Class

If you wish to subscribe to Statistics Relating to Lloyd's, please click here.