Data warehousing at lancashire care nhs trust l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 16

Data Warehousing at Lancashire Care NHS Trust PowerPoint PPT Presentation


  • 124 Views
  • Uploaded on
  • Presentation posted in: General

Data Warehousing at Lancashire Care NHS Trust. Tim Harvey – Head of Information Helen Dean – Information Analyst. The Trust. Established 2002 Provides Mental Health and Substance Misuse services across Lancashire Provides Secure Mental Health services for Lancashire & Cumbria Over 3500 Staff

Download Presentation

Data Warehousing at Lancashire Care NHS Trust

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Data warehousing at lancashire care nhs trust l.jpg

Data Warehousing at Lancashire Care NHS Trust

ASSIST Presentation


Tim harvey head of information helen dean information analyst l.jpg

Tim Harvey – Head of InformationHelen Dean – Information Analyst

ASSIST Presentation


The trust l.jpg

The Trust

  • Established 2002

  • Provides Mental Health and Substance Misuse services across Lancashire

  • Provides Secure Mental Health services for Lancashire & Cumbria

  • Over 3500 Staff

  • Over 120 Sites

ASSIST Presentation


Lct info systems l.jpg

LCT Info Systems

  • Pre-Connecting for Health

    • Six Legacy PAS Systems

    • Hosted by Acute Trusts

    • Reliant on Service Level Agreements

    • No structure to Information provision

    • No Data Integration

ASSIST Presentation


Ncrs deployment l.jpg

NCRS Deployment

  • iPM implementation- April 2005

  • Community rollout- April 2006

  • Data Extracts received on a 24hr basis

  • Initial Loads and Delta Loads

  • No Extract Management solution provided

ASSIST Presentation


Data warehouse l.jpg

Data Warehouse

  • In-house solution not feasible

  • CfH solution not available at the time of go-live

  • Reviewed off the shelf products and…

ASSIST Presentation


Health data manager l.jpg

…Health Data Manager!

ASSIST Presentation


Why health data manager l.jpg

Why Health Data Manager?

  • Designed specifically for NHS and Data Extracts

  • Provide integration, storage, analysis and presentation within one application

  • System C part of CSC Alliance

  • Keeps data under ‘local’ control

  • Ability to incorporate other system data

  • Ease of use

ASSIST Presentation


How it works 1 l.jpg

How it works (1)

ASSIST Presentation


How it works 2 l.jpg

How it works (2)

24 Hours

Stage 1 Job

Stage 2 Job

Extract Files

Staging Tables

HDM Tables

CSV

Oracle

Business Objects/

Web Intelligence

ASSIST Presentation


Slide11 l.jpg

ASSIST Presentation


Slide12 l.jpg

ASSIST Presentation


Lct current reporting configuration l.jpg

LCT Current Reporting Configuration

Performance

Dashboard

iPM

Web Info

Reports

Statutory

Returns

E-CPA

HDM Reports

ASSIST Presentation


Implementation issues l.jpg

Implementation Issues

  • Data Extract Issues

    • Versions and Loads

    • Completeness

    • Timeliness/Validation checking/LSP Relationship

  • Understanding Universes

  • New application

ASSIST Presentation


Future developments l.jpg

Future Developments

  • Community Activity

  • Information Portal

  • Feasibility of using full Business Objects Application

  • Migrate Warehouse from Oracle to SQL

  • Expand usage of HDM

ASSIST Presentation


Questions l.jpg

Questions?

ASSIST Presentation


  • Login