data warehousing at lancashire care nhs trust l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Data Warehousing at Lancashire Care NHS Trust PowerPoint Presentation
Download Presentation
Data Warehousing at Lancashire Care NHS Trust

Loading in 2 Seconds...

play fullscreen
1 / 16

Data Warehousing at Lancashire Care NHS Trust - PowerPoint PPT Presentation


  • 182 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Data Warehousing at Lancashire Care NHS Trust' - bryson


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
the trust
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
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
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
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
…Health Data Manager!

ASSIST Presentation

why health data manager
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
How it works (1)

ASSIST Presentation

how it works 2
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

lct current reporting configuration
LCT Current Reporting Configuration

Performance

Dashboard

iPM

Web Info

Reports

Statutory

Returns

E-CPA

HDM Reports

ASSIST Presentation

implementation issues
Implementation Issues
  • Data Extract Issues
    • Versions and Loads
    • Completeness
    • Timeliness/Validation checking/LSP Relationship
  • Understanding Universes
  • New application

ASSIST Presentation

future developments
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
Questions?

ASSIST Presentation