Closed
Data Warehouse Development Project
Descriptions
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.
Timeline
Published Date :
Deadline :
Contract Start :
Contract End :
Tender Regions
CPV Codes
48612000 - Database-management system
48611000 - Database software package
Keywords
relational DB engine
SQL query processor
database schema designer
indexing optimizer
backup/recovery manager
ACID transaction handler
data export tool
performance tuner
data migration utility
stored-procedure editor
DBMS platform
client-server database
database security manager
user privilege control
concurrency control engine
data integrity module
replication manager
high-availability cluster
schema versioning tool
database audit logs
Tender Lot Details
2 Tender Lots
Workflows
Status :
Procedure :
Suitable for SME :
Nationwide :
Assign to :
Tender Progress :
Details
Notice Type :
Tender Identifier :
Tenderbase ID :
Low Value :
High Value :
Buyer Information
Name :
Procurement contact
Name :
Phone :
Email :
Possible Competitors
1 Possible Competitors