Where can I get data?

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