Where Where Can Can II get get Data? Data? TRAINER: TRAINER:
Denise Denise Phillips Phillips Senior SeniorImprovement ImprovementConsultant Consultant
2
Data Sources • General Local Government Data Unit ~ Wales http://www.dataunitwales.gov.uk NOMIS(National Online Manpower Information System) http://www.nomisweb.co.uk/ Neighbourhood Statistics http://www.neighbourhood.statistics.gov.uk/ Office for National Statistics http://www.statistics.gov.uk/ Welsh Government – Statistics http://new.wales.gov.uk/topics/statistics/?lang=en • StatsWales http://www.statswales.wales.gov.uk/ • InstantAtlas http://www.instantatlas.com/
3
Data Sources Health Health in Wales http://www.p2.wales.nhs.uk/ NPHS (National Public Health Service Wales) http://www.publichealthwales.wales.nhs.uk/ Health Solutions Wales http://www.infoandstats.wales.nhs.uk/
Environment Environment Agency http://www.environment-agency.gov.uk/ DEFRA (Department for Environment, Food and Rural Affairs) http://www.defra.gov.uk/evidence/statistics/index.htm
4
Data Sources Housing Land Registry http://www.landregistry.gov.uk/ Communities and Local Government http://www.communities.gov.uk/housing/housingresearch/housings tatistics/housingstatisticsby/
Transport Department for Transport http://www.dft.gov.uk/pgr/statistics/
5
Data Sources
Community Safety • • • • •
Home Office Crime Statistics http://www.homeoffice.gov.uk/rds/ Local Crime and Justice http://localcrime.direct.gov.uk/index.php South Wales Crime Mapper http://maps.police.uk/view/south-wales/ Dyfed Powys Police Crime Mapper http://maps.police.uk/view/dyfed-powys/ Gwent Police Crime Mapper
/
http://maps.police.uk/view/gwent •
North Wales Police Crime Mapper http://maps.police.uk/view/north-wales/
6
Output measures
Outcome measures
Population outcome measures
7
Performance Measures Quantity
Effort
or
Quality
How much did we do?
How well did we do it?
#
%
or
Effect
Is anyone better off as a result?
#
%
Outcome Measures – Population indicator / Conditions of wellbeing Quantity How much?# Effort
Input measure
or
# Effect
or
Quality
How well?% Process output measure
Is anyone better off? Outcomes for Individuals Attitude Behaviour Circumstance Knowledge
%
Outcome Measures – People feel safe in their community Quantity Quality or How much?# Input measure
Effort or
Number of policemen on the beat Number of neighbourhood watches set up
# Effect
How well?% Process output measure Response times to calls
Number of arrests
Is anyone better off? Outcomes for Individuals
Crime rate statistics V Survey
%
Attitude/Behaviour Circumstance/Knowledge Increase in reported crimes Walking home after dark
Which of these could be outcome measures? Burglary per 100 buildings
Cautions for Anti social behaviour
Theft per 100 people
Number of people afraid to walk home after dark
Arrests for suspected arson
11
Population Outcome A condition of well-being for a population (or sub-pop) stated in plain language
Families in XXXXX live in a safe community
Population Indicator Measurable information which helps quantify achievement of population outcome
Crime rate in XXXXX
Performanc e
Population
Keeping Accountability Straight
Performance Measure Measurable information which helps quantify if a service etc works
Children in XXXXX are born healthy
Rate of low birthweight babies in XXXXX • How much did we do? • How well did we do it? • Is anyone better off?
How How can can II gather gather Data? Data? TRAINER: TRAINER:
Dr Dr Jenny Jenny Murphy Murphy CStat CStat Senior SeniorStatistician, Statistician,Research Research& &Surveys Surveys Consultant Consultant
How can I gather data?
Using surveys to get data
USA Today has come out with a new survey- apparently three in every four people make up 75% of the population. ~David Letterman
15
When do we need survey data? • When the information can’t be obtained any other way
Why? • Because surveys are: • Expensive • Time consuming • Complicated • Estimates 16
To survey or not to survey? • Reasons for not visiting the dentist • Household incomes
• Children’s views on travel to school • Reasons for liking the neighbourhood
17
Problems in survey questions How would you rate the street furniture and road markings in your local area? •
Street furniture and road markings are different subjects
•
Separate questions for each subject
•
Does your audience know what street furniture is?
•
Carefully define local area 18
Vehicles with large engines create greater CO2 emissions than those with smaller engines. Do you think that 4x4 vehicles are a contributor to Global Warming?
This is a leading question. The answers you get are not going to be truthful.
19
Use consistent and balanced answer option scales
How satisfied or dissatisfied are you with the local bus service? Tick one box only Answer option list 1 Very satisfied Fairly satisfied Neither satisfied nor dissatisfied Fairly dissatisfied Very dissatisfied
Answer option list 2 Very satisfied Satisfied Neither satisfied nor dissatisfied Quite disgusted Appalled
20
Don’t reinvent the wheel • Harmonised questions and concepts • Question Banks • Survey and Information Exchange
21
How do I analyse data?
Statistics and when to use them
22
Statistics can be made to prove anything even the truth. ~Anon
Statistics means never having to say you’re certain. ~Anon.
23
Understanding your data • Take a look at the data before analysis • Check for anomalies/outliers • Use the right statistics • Give the audience the information they need
24
(237,81)
25
(137,81)
26
(107,81)
27
What difference does it make? Average 1 = 214 Average 2 = 211 Average 3 = 210
(x=237) (x=137) (x=107)
• One data point, real or error, can make a difference • Context will determine if this difference is important
28
How much information? • Mean
50
50
• Standard deviation
10
5
• Number of points
10
100
29
How can I share data?
Presenting data to maximise impact
30
The goal is to transform data into information, and information into insight ~Carly Fiorina (President of Hewlett-Packard)
31
Getting from data to information
How do we interpret a number?
12573981 12,573,981 13 million 32
Effective Digits • Data should be rounded to give two effective digits for comparison
1234
1,200
7153
7,100
33
What is happening to population? Population 32,000 31,000
The scales have been manipulated to produce different impressions
30,000 29,000 28,000 27,000
1994
1995
1996
1997
1998
1999
2000
Population 35,000 30,000 25,000 20,000 15,000 10,000 5,000 0 1994
1995
1996
1997
1998
1999
2000
3434
3D charts Figure 1: Percentage of interventions identified in each category
5 - Early problems
6 - Severe problems
1 - Universally applied
4 - Adults and elderly
3 - Schoolaged
2 - Pre-school
35
Apparent percentage of visible area
Actual percentage from data
1 Universally applied
43
46
2 Pre-school
22
12
6
4
17
19
5 Early problems
3
5
6 Severe problems (white)
9
14
Category
3 School- aged 4 Adults and elderly
36
Writing clearly • Know your audience
– Different people will want different things and have a different amount of time to read them • Try to avoid acronym and jargon • Try to write top down rather than bottom up
– A journalistic style will get key messages across quicker 37
Managing Managing my my RBA RBA Project Project TRAINER: TRAINER:
Denise Denise Phillips Phillips Senior SeniorProject ProjectManager Manager
39
RBA on a postage stamp • • •
Do I know what needs to be measured? Is there data available? Who has it and where can I find it? How much?
Effort?
How well?
Effect?
40
Fundamentals • How much did we do? • How well did we do it? • Is anyone better off?
41
Questions • Do we know where we are? • What does success look like? • What outcomes are we hoping to achieve? • What is it that makes the difference? • Do we have output milestones? • Who is we? 42
The Importance of Language Too many terms. Too few definitions. Too little discipline
Outcome Indicator Aim
Milestone
Benchmark
Result
Modifiers Goal Measurable Core Urgent Qualitative Priority Programmatic Targeted Performance Objective Incremental Strategic Systemic Target Impact
Measure
RBA
44
The Thinking Process What is the problem? How do we know? Why is it happening? How can we fix it? Who can help? How will we know when it’s fixed? 45
The Community Process What Results do we want? What will theses look like? How do we know if things improve? Why are things improving? What works best? Who can help? What can we do?
46
The Programme Process
Who are our customers?
How can we measure if they are better off? How do we know if we are doing well? How are we doing on important measures? What partners do we need? What works best? What are we going to do? 47
WHAT ARE WE GOING TO DO?
• ………. AND HOW ARE WE GOING TO DO IT?
48
What is a project?
A TEMPORARY organisation created for the purpose of delivering specific outcomes and deliverables to support a business case.
Project Considerations
Responsibility
Reporting Resource
Planning
Accountability Budget
Communication
Monitoring 51
Easy steps to project success
52
Questions and Answers
53
Further Support Available‌ Other courses and workshops Organisational Change Business Improvement Process Mapping for Efficiencies Project Management Customer Needs Analysis Data Management Survey Design Supporting Products/Services Best Practice Guidance. InfoBase / LIS contextual Performance information.
Diolch i chi am gymryd rhan Thank you for taking part Uned Ddata Llywodraeth Leol - Cymru 3-7 Rhodfa Columbus Caerdydd CF10 4SD Ffôn: 029 2090 9500 www.unedddatacymru.gov.uk Local Government Data Unit – Wales 3-7 Columbus Walk Cardiff CF10 4SD Tel: 029 2090 9500 www.dataunitwales.gov.uk
56