Data Warehouse Demonstration

1
The Art of Warehousing
Data Warehouse Demonstration
Lorraine Lacey - Senior Business Analyst Jeremy
Chang System Architect
2
Background Information

• LPCT went live with RiO 4 in November 07
• Began system design of the Warehouse in January
  08
• Delivered Phase 1 in June 08
• Immunisation
• Activity Reports
• Delivered Phase 2 in October 08
• Immunisation Data Quality Missing Imms v GP
  Data
• Developmental Reviews
• Screening
• Currently in Phase 3
• RTT 18 Week
• Long Term Conditions and Diagnosis
• Patient Profiling
• Local Authority Disabilities Register

3
Requirements Gathering

• System Requirements
• Easy to deploy and Maintain and Use
• Web based application
• RiO Version independent
• Application independent
• Central Repository for other data sources
• True Warehouse Structure

• Business Requirements
• Vital Sign and Performance reporting
• Operational Reporting
• Overview of Trust activity at any given time
• Ability to drill into patient level details
• Data Quality reporting
• Process Management
• Slice and Dice

• Clinical Service Requirements
• Client Profiling
• Outcome measures
• Intelligent data to enable service planning
• Epidemiological Study

4
Conceptual Design

• Data Quality
• Key data areas are supported by quality reports
• Improves caseload and demographic management
• Identifies missing data
• Delivered
• Missing Activity
• Overdue Scheduled Items
• Incomplete or missing data elements
• Missing Immunisations against GP Data
• Caseload Cleansing against NSTS

• Activity Reporting
• Details all activity logged against clients
• Gives a cohesive view across services of
  activity levels
• Supports National and Local KPI reporting
• Delivered
• Contacts, DNA, Cancellations, Activity
• Immunisations Uptake, Cover Data
• Developmental Reviews

• Process Management
• Visual representation of where key processes are
• failing
• Enables targeted process re-engineering
• Under Development
• 18 Week Wait
• Birth to Primary Immunisations

• Profiling
• Patient centric data for profiling types of
  Clients
• Diagnosis and LTC analysis
• Demographic analysis for target services
• Data modeling for capacity and forecast
  planning
• Coming Soon
• Health Need Review
• Diagnosis and LTC

5
System Design
Data Sources
Future Sources
Sexual Health HR Financial Public Health
NSTS Tracing
GP Imms Data
RiO
Data TransformationApply Business Requirements
and Design Rules
WILMA Structure
6
WILMA User Interface
7
Immunisation Module
This is the User Interface which enables the
service and the immunisations team to quickly
drill into specific antigens and analyse uptake
against Ward or GP and to identify defaulters.
8
Imms Given No Of Patients
Health Visitor Ward
Uptake
9
(No Transcript)
10
Immunisation Analysis
Target Ward
11
Not Given By Ward Postcode
Target Postcode
12
Immunisation Not Given By Postcode by Ethnicity
13
Current Situation

• Year 2007-08
• 75 of general practices achieved over 70
  coverage for MMR1
• 84 of health visitor teams achieved over 70
  coverage for MMR1
• Year 2008-09
• 67 of general practices achieved over 70
  coverage for MMR1
• Health Visiting Service achieved over 70
  coverage for MMR1
• 90 practices reaching coverage of 70 or above
  for D3
• Health Visiting Service achieved over 70
  coverage for D3

14
Current Situation
Manual Collection of Data
Data Cleansing Began
RiO Go-Live
15
Current Situation
Data Cleansing Began
16
How Did We Get Here?

• RiO Vs GP DATA
• Missing Imms against GP Data through WILMA
• Manual entry ran for approximately 6 months
• Now Within 2 of GP Data

• CASELOAD CLEANSING
• Batch Trace 0-5 and move Clients off HV
  Caseload
• Ongoing Quarterly Cleansing

Immunisations

• TRAINING AND SUPPORT
• On-going Training for all HVSW
• Immunisation Help Line
• Quality Checking Flimsies and RiO

17
(No Transcript)
18
Warehousing Information for Lewisham Management
Analysis