BIOLAP provides data warehouse design and implementation services. We subscribe to Kimball's Dimensional Modelling approach - to increase the strategic use of information by our clients thereby improving margins. By gaining an understanding of your organisation's value chain we help to prioritise the project stages to create maximum value as early as possible.

Below is an example of a value chain in the insurance sector supported  by strategic data marts that form part of an overall data warehouse design:

To read further about some of the benefits that our clients in the insurance sector have reaped from our strategic data marts and well designed data warehouse solutions, click on the links below:

View - Balance Sheet Diagnostics for Insurance Intermediaries

View - Revenue Analytics for Insurance Intermediaries


BIOLAP has developed  data mart solutions for the following well known insurance broking accounting systems:

Insurance Broking System  
Brokasure Some customisation required
Impact Some customisation required
Sector Some customisation required
Sirius Some customisation required
Acturis Some customisation required

The process typically involves extracting data from an application database and staging the data in a data mart or data warehouse. We have designed and built data warehouse solutions using the Microsoft BI Stack and WhereScape Red. The data can then be reported on directly or via an OLAP application facilitating easy slicing and dicing of results.


Please contact us for more information about our data warehouse services: +44 (01952) 456-453 or +44 (07785) 766-829

Biolap Services

  • Balance Sheet Diagnostics for Insurance Intermediaries +

        Overview   Insurance Intermediaries continuously face the challenges of handling client money and the underlying problems associated with Read More
  • Consultancy Services +

    BIOLAP provides professional and qualified  finance and IT consultants with wide industry experience. We are equally comfortable liaising with board members or Read More
  • Data Warehouse Design +

    BIOLAP provides data warehouse design and implementation services. We subscribe to Kimball's Dimensional Modelling approach - to increase the strategic use Read More
  • Due Diligence & Forensic Reviews +

    BIOLAP provides pre-acquisition data due diligence and data analysis services providing valuable insight into data quality and operational exposures. In addition, Read More
  • Excel Training Courses +

    Excel Training (1 to 2 days) Materials Covered: Custom designed courses that focus on obtaining more from Excel. Topics include Pivot Tables, Read More
  • PowerOLAP Training Courses +

    PowerOLAP Technical Training (3-5 days) A comprehensive technical training course covering the following: install PowerOLAP create multi dimensional models (cubes) Read More
  • Revenue Analysis & Margin Improvement +

    How can BIOLAP help? Market conditions, including rates and FX, continue to present real barriers to meaningful top line brokerage Read More
  • Support +

    BIOLAP prides itself on its ability to support clients fast and effectively.  We provide extensive product and solution support in the Read More
  • Systems Implementation +

    BIOLAP consults on, installs, integrates and trains for the optimum use of software technology in creating solutions that help our Read More
  • Training +

    Our training courses are designed to meet individual client requirements and will help to ensure the success of any of our Read More
  • 1

Login Form