Retail group


Enterprise information delivery strategy and EDW

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.

Project details



PBT Group entity

PBT Technology Services


Enterprise information delivery strategy and enterprise data warehousing

Project description

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

Service details

  • 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