Comprehensive Works in Progress, by Program (CWIPP)

Perth City

 

Background

CWIPP provided a single view of all known projects and programs either planned, underway, or completed within the Housing Authority.

The Corporate Data Mart (CDM) was implemented to provide a refined selection of data that was held across various data warehouses in the Housing Authority. The Authority manages more than twenty data sources (manual and automated) and it identified the need for a single source of truth.

Problem

The project included both the development of the interface and facilitating staff training in its use (n=100). CWIPP was the first example of a single source of truth for activities underway within the Housing Authority.

The key CDM project objective was to provide the Authority’s corporate executive with an overview of key data from key areas of the business. This included land and construction; housing programs; finance and tenancy management. The CDM is now a central element of the Department’s IT infrastructure.

Solution

PHC expertise for the CWIPP Project included:

  • Analysis of datasets,
  • Creation of a master database for projects and programs;
  • Creation of unique identifiers and linkage of datasets;
  • Enable Geocoding of data and spatial presentation;
  • Developing mapping frameworks for spatially enabled data;
  • Develop queries for management to understand the datasets for visual presentation; and
  • Deliver data in report and format as expected by the client.

PHC Services Utilised:

  • Business Case, Scope and Implementation Plans
  • Project Management
  • Business Analysis
  • Project Coordination and Administration
  • Training & Development Designv
  • Business Case, Scope and Implementation Plans
  • Project Management
  • Business Analysis
  • Data Analysis & Development (Geocoding)
  • Training & Development Design

Outcome

The project included both the development of the interface and facilitating staff training in its use. CWIPP was the first example of a single source of truth for activities underway for projects and programs within the Authority.

PHC delivered the objective to provide the Authority’s corporate executive with an overview of key data from key areas of the business. This included land and construction; housing programs; finance and tenancy management. The CDM is now a central element of the Authority’s IT infrastructure. The CDM delivered the single source of truth. PHC developed, implemented refined selection of data that was held across various data warehouses within the Housing Authority. This work formed the foundation for the ‘Work in Progress’ GIS Layer.

cwipp

PHC. Bringing your business and the future together.