Raw data to finished report WORKSHOP

1
Raw data to finished report WORKSHOP

• Richard Wight and Graham Putnam

2
(No Transcript)
3
Data extraction

• Specification for extraction created
• Has limitations specified eg period for analysis
• Selected fields
• Range of values
• Linked files
• Csv format

4
Prior to export to registries

• Search for duplicates
• Quality check on data within fields
• System check looks for anomalies
• Differences direct entry and upload
• Of uploaded data values outside of ranges
• Data cleansing
• Within the DAHNO application, data cleansing,
  where otherwise meaningless or unrecognised
  values can be automatically corrected during the
  import process to reflect valid data entries, has
  yet to be applied

5
Registry analysis

• Numerator and denominator definition has
  iteratively been made, and a methodology
  established for consistent future comparisons.
• Boundaries
• For future reports, it will remain a challenge to
  analyse data by Cancer Network, particularly
  where boundaries and patient treatment pathways
  may vary, and to understand its limitations and
  interpretation.

6
What happened to cases entered after cut off last
year? Effect of period for analysis

• As this is a continuous audit with annual
  reporting years, inevitably some patients will
  complete the treatment phase of their pathway
  beyond the reporting year.
• A review of new cases with a diagnosis date prior
  to 1 October 2005, shows that contributors have
  added a further 367 cases.
• Future reports will seek to look cumulatively
  beyond the reporting year.
• Users are encouraged to get both diagnostic and
  treatment data as close as possible to the point
  of care delivery.

7
The expert panels 2006/7

• LARYNX
• Pat Bradley
• Mark Watson
• Terry Jones
• Chris Nutting

• ORAL CAVITY
• John Hayter
• Iain Mcvicar
• Cyrus Kerawala
• Chris Nutting

8
The expert panels 2006/7

• What they do in 2 meetings-
• Look at each generic and each site related output
• Does the information make sense?
• Does the maths add up?
• Is their sufficient contribution to allow
  inclusion?
• Does it match to their expectation/evidence?
• What more detailed or alternate analyses should
  be done?
• Key conclusions on findings to facilitate write
  up

9
YOUR CHANCE TO BE THE EXPERT PANEL

• TWO EXAMPLE OUTPUTS FROM THIS YEARS REPORT

10
Interval from biopsy to reporting
11
Interval from biopsy to reporting

• What does this histogram represent ?
• What is your interpretation of the information ?

12
Interval from date of surgery to post operative
radiotherapy
13
Interval from date of surgery to post operative
radiotherapy

• What does graph represent ?
• What is your intepretation of the information ?

14
Discussion of findings