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

The aim of this project for our banking industry client was to design and implement a data mart to provide information not only for general ad hoc use from a data cube, but also to provide executive management with crucial information to make strategic business decisions.

 

The process included:

  • Assisting permanent staff in the design and implementation of a data mart to replace a legacy reporting system used by the private banking segment. This involved gathering the requirements from the business as well as from the legacy system and establishing a workable solution.
  • Implementation of a marketing automation system to run the bank’s campaigns.
  • Services for ad hoc reporting as well as value-added services, such as hosting a forum each month for SAS developers across the bank.

[/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]

Banking and finance

[/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]

BI and analytics solutions

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

  • Programme and project management
  • Business and data analysis
  • Solution architecture and design
  • Dimensional modelling
  • ETL design and implementation
  • Report design and implementation
  • 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=”filtered_grid” grid_layout_mode=”fitRows” order=”DESC” grid_teasers_count=”all” grid_thumb_size=”250×150″][/vc_column][/vc_row]