[vc_row][vc_column][vc_single_image image=”450″ img_link_target=”_self” img_size=”1080×432″][/vc_column][/vc_row][vc_row][vc_column width=”1/2″][vc_text_separator title=”Enterprise information delivery strategy and EDW” title_align=”separator_align_left” title_heading=”h1″ separator_type=”type2″ margin_top=”0″][vc_column_text]

This project for the retail giant received an ITWeb award in February 2012. It consisted of the architecture, design and implementation of a cost effective and efficient information delivery environment to:

  • Provide the retail group’s users with a BI portal, which serves as a single entry point through which they will have easy access to information to facilitate analysis and decision-making
  • Provide the users with dashboards that will give them visibility into the KPI’s relating to the different divisional information through simple, graphical, high-level summaries in a single consolidated view
  • Collate and integrate data from various sources into a single platform for easy access on an ad hoc basis
  • Establish a reporting platform that is robust and scalable in order to easily extend the platform in the future when adding the information of new business areas


The process included:

  • Consultation on a strategic level, implementing the overall DWHS and BI conceptual architecture, building the core EDW team to implement the DWHS and BI architecture as well as advising on how to build their own BI competency centre by providing mentorship and direction
  • The design and implementation of an HR data mart on top of the DWHS. This assists the users with analytical queries via Excel on employment equity, payroll, recruitment, development, corporate social investment, employee relations, organisation development and employee wellness



PBT streamlined the reporting capability of the retail group’s new accounts department and redesigned their underlying data feed to adhere to basic data warehouse design principles. This newly designed and structured reporting solution improved reporting turnaround times and assisted with growing the new accounts client base, while improving the retail group client experience in general.

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


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

Enterprise information delivery strategy and enterprise data warehousing

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

Architecture, design and implementation of a cost effective and efficient information delivery environment or enterprise data warehouse

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

  • Strategic consulting
  • Programme and project management
  • Business analysis
  • 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]