[vc_row][vc_column width=”1/1″][vc_single_image image=”718″ css_animation=”appear” img_link_target=”_self” img_size=”1080×432″][/vc_column][/vc_row][vc_row][vc_column width=”1/2″][vc_text_separator title=”Data warehouse rescue” title_align=”separator_align_left” title_heading=”h1″ separator_type=”type2″ margin_top=”0″][vc_column_text]

When the health insurance division of a well-known South African insurance group encountered difficulties with their newly implemented data warehouse, they contacted PBT Group to help resolve these complexities, commencing a rescue mission with winning results.

 

The company procured QlikView based on its ability to develop high quality reports with basic analytical capabilities in relatively short periods of time.

 

The problems that they encountered were:

  • QlikView struggled with the number and complexity of the business rules
  • The quality of the data
  • The volume of raw data
  • Performing longitudinal analysis on the data

 

PBT Group’s intervention

Some of the biggest challenges included the number of undocumented business rules. Knowing that it is unlikely to document all business rules upfront, we adopted a more agile approach to development.

 

We began by creating a solid data model, framework and architecture. Then we started populating the data warehouse, testing as we progressed. No project is without challenges, and here the production migration was delayed by an unavailable production server. In addition, the development server was underpowered and as a result some fact tables could be loaded and tested on a subset of data. However, everything passed UAT, with the caveats imposed by environmental constraints.

 

Outcome:

The project resulted in a well-designed data warehouse that will eliminate multiple versions of the truth, hide complex business rules from the end-users and therefore make analysis a lot easier, even for novice users.

 

Despite constraints and challenges, we developed a data warehouse with about 20 fact tables and even more dimensions in a complex environment in about 650 labour hours, which included a POC. We have now been asked to bring in additional data into the data warehouse and to continue with the QlikView front-end development.

[/vc_column_text][/vc_column][vc_column width=”1/2″][vc_text_separator title=”Project details” title_align=”separator_align_left” title_heading=”h1″ separator_type=”type2″ margin_top=”0″][vc_accordion active_tab=”false” collapsible=”yes”][vc_accordion_tab title=”Industry “][vc_column_text]

Health insurance

[/vc_column_text][/vc_accordion_tab][vc_accordion_tab title=”PBT Group entity”][vc_column_text]

PBT Technology Services

[/vc_column_text][/vc_accordion_tab][vc_accordion_tab title=”Services”][vc_column_text]

Data warehousing

[/vc_column_text][/vc_accordion_tab][vc_accordion_tab title=”Project description “][vc_column_text]

Data modelling, framework and architecture

[/vc_column_text][/vc_accordion_tab][vc_accordion_tab title=”Service details “][vc_column_text]

  • Strategic consulting
  • Programme and project management
  • Solution architecture and design
  • Data migration
  • Testing
  • Training

[/vc_column_text][/vc_accordion_tab][/vc_accordion][/vc_column][/vc_row][vc_row][vc_column width=”1/1″][vc_text_separator title=”Similar items” title_align=”separator_align_left” title_heading=”h1″ separator_type=”type2″ margin_top=”0″][vc_teaser_grid grid_columns_count=”4″ grid_posttypes=”portfolio” grid_content=”teaser” grid_layout=”title_thumbnail_text” grid_layout1=”thumbnail_title” thumbnail_hover_icons=”link” grid_link_target=”_self” grid_template=”grid” grid_layout_mode=”fitRows” order=”DESC” grid_teasers_count=”All” grid_thumb_size=”250×150″][/vc_column][/vc_row]