Public procurement notice: Voluntary Ex Ante Transparency Notice
Published: 2016-02-02
Buyer: NHS Highland
Country: UK
Region: Highlands and Islands
Contract type: Services
Procedure: Contract award without prior publication
CPV classification: 48810000: Information systems | 48814000: Medical information systems | 72212600: Database software programming services | 72222300: Information technology services | 72267100: Maintenance of information technology software
Estimated value: 850000 GBP

Technical requirements: Provision and Maintenance of the Data Warehouse, Business Intelligence tools and associated Services.
The provision of expert specialist skills and services to support the delivery, development and maintenance of iHealthBi and Data Academy Data Warehouse and Business Intelligence development tools.
The only unique modular data warehousing and business intelligence solution in the market which supports incremental data load, including deletes. A solution which is completely configurable to meet NHSH specific needs. A single version of the truth from the data systems. Access to all data via the Extract Load and Transform process rather than the ETL which provides limited access to the data. Visibility to all data available in the source system by extracting all data to staging tables. A platform which loads data from virtually any data source: Microsoft SQL Server, Oracle, ODBC, Access, Text Files, etc., meaning it can support various NHSH wide systems. A solution which is compatible with our legacy and current PAS/ PMS system. A solution which eliminates the need for manual data processing. Processing is completed automatically over night. Allows all generated code to be accessed and edited through a graphical user interface which also allows the user to monitor and administer the progress of the data warehouse. This also provides an administration audit and an exclusive error logging interface for each module. A data warehousing platform with a user configuration facility that allows each user to access relevant areas of data for their role. A unique field mapping structure allows mapping of source system fields into a set structure to add additional intelligence to the data such as data rules and calculations. Organised data warehouse builds into a single visual process for our daily extract/transform routine. A 2 stepped layered approach to the availability of data. 1 layer completes the processing, and after completion, the data gets transferred to the output tables to be used for reporting. The solution to allow critical information to be organised in custom data sets available for quick decision making. Provides the RTT module which supports 18 week compliance in the way our PMS system module can't. Transparency to any relational or OLAP-based reporting tool e.g. SQL Server Reporting Services, QlikView and Analysis Services. Supports the generation of SQL Server Analysis Services (OLAP Server) cubes. Data Quality reports to identify any data quality issue for resolution at source. A complete data dictionary of every data item.
Provision ans Maintenance of the Data Warehouse, Business Intelligence tools and associated services.
Insource is the only company with the specialist skills to provide training, support and maintenance of our Data Warehousing software, Data Academy, and our HealthBI data structure.


Number of bids: 1