Data Warehouse Development Contract

Data Warehouse Development Contract

APSE wishes to implement a new Data Warehousing solution to improve the monitoring and reporting function across its Performance Networks, which is a public benchmarking service across England, Scotland, Wales and Northern Ireland and used by over 200 local authorities.

Data Warehouse Development Project

Apse Manchester

Contract summary

Industry

Computer and Related Services, Technology and Equipment

Location of contract

M32 0FP

Value of contract (£)

£100,000

Published date

16 May 2016

Closing date

10 June 2016

Contract start date

04 July 2016

Contract end date

11 January 2019

Description

APSE wishes to implement a new Data Warehousing solution to improve the monitoring and reporting function across its Performance Networks, which is a public benchmarking service across England, Scotland, Wales and Northern Ireland and used by over 200 local authorities. The service has 17 years of collating a variety of performance indicator data. It has been recognised that there is a shortfall in the current way of information management within APSE Performance network and limits the ability to carry out detail information analysis across multiple years. Further, the current information management framework within APSE has scalability issues in accommodating changes to the performance network primarily due to the way it has been setup at the early stages of the performance network. The majority of data collection for the Performance Network happens through Microsoft Excel templates and data being stored using the Microsoft Access databases. This project is confined to the creation of a more efficient, reliable and user-friendly database to allow APSE to store performance networks data (from excel files and web forms), run queries and produce a range of reports. The new data warehousing solution should be able to replicate the current set of reports as well as producing new, more sophisticated types of analysis. It is not intended at this stage to change the way in which members submit data (through excel files) nor is it intended at this stage to move to on-line data collection and/or reporting. However, the medium-term aim is to replace the data templates with on-line data capture, as well as providing members with the ability to analyse their data on-line and to create their own reports. Therefore, the system should be capable of working with on-line systems as the intention is to move towards this in the near future. Attached is an Invitation to Tender which also includes: 1. Tender completion requirements, evaluation model and schedules. 2. Specification 3. Draft contract and schedules 4. Assessment questions There is also a pack containing samples of the current systems (databases and spreadsheets) which is available upon request to pntenders@apse.org.uk The anticipated value of the Services is approximately £100,000. APSE proposes to enter into one Contract for a period of 2 years 6 months and the anticipated service commencement date is 11 July 2016.

About the buyer

Address

APSE, Lancastrian Office Centre

32 Talbot Road

Old Trafford

M32 0FP

England

Email

pntenders@apse.org.uk

Website

www.apse.org.uk

Other information

Attachments

APSE performance networks

http://www.apse.org.uk/apse/index.cfm/performance-networks/

Payment mechanism

Payment Mechanism.pdf

Assessment Questions

Assessment Questions.pdf

Parent company guarantee

Parent Company Deed of Guarantee.pdf

Software Development Agreement (draft contract)

Software Development Agreement (Draft contract).pdf

Specification

Specification.pdf

Invitation to Tender

Tender Document.pdf

There is also a pack containing samples of the current systems (databases and spreadsheets) which is available upon request to pntenders@apse.org.uk

How to apply

Please apply directly to the buyer using the contact details provided.

 

Related Posts

Database Support and Maintenance Belfast

Supply Search and Apply Database for Further Education

To Supply Data System to Cornwall Council

Services To Collate Data about Air Pollution in the UK

Enjoyed this post? Share it!