 So back to basics, I'm going to be looking at the service level data, the basic basic data that you collect yourselves, what you perhaps already collect as a routine or what you collect as specific to something that you need to know more about. So I've just split it into basic types of routine data and sometimes people can forget that some of their routine data is actually very useful if you start delving into that. And specific data, that's the stuff that you might be thinking is important. Okay so yeah, everyday data, all the stuff that you usually collect as a routine, usually most people collect demographics of some sort, you're collecting ideas on how many people are using your service, what aspects of this your service that they're using, you're collecting financial data, so you might have data there available to work out what the costs of your service or split that into different elements, what parts of your service are costing the most or the most efficient. Hopefully also you're collecting some idea about the specific needs of your service users, particularly those around your particular service. So if it's a housing service, for example, you might be looking at what their current status of housing is and what they need. So specific data might be things that we're looking you're looking for effectiveness. So you want to be looking at your outcome success rates. So whatever your your service is designed for, hopefully you're measuring how many people use your service with a successful outcome. Again if it's housing, have they improved their housing level in some way or another? Then there are quality measures, how well are you delivering your service? So you're probably already collecting some kind of evaluation from service users or satisfaction surveys from service users. Not necessarily service users, but it could also people who are commissioning you to deliver that service and how well they are seeing your efficiencies. And then your efficiency measures such as did not tend rates might be particularly important to you. So I'm going to split them up into two kinds of knowledge that what we want to know about in a service that is who's benefiting and how are they benefiting. And when I do my second presentation I'll give you a good example of how that information can actually be quite useful, but also quite controversial. So it usually relates to your service goals, your outcomes and impacts. Some people get confused about the difference of those things or trying to separate those out as well. Basic outcomes are successfully used the service or successfully benefited from the service. And to get some information on that we need to collect the basic demographics and things that are pertinent to your service. As I say age and gender are typical type of need for that person. If I was running let's say a health and social care service I want to know what their specific health needs were, their social needs, what they're using service for. Then as we've seen that geographic data can be very important so postcode area is very useful to see how much you're covering and whether you're covering people with a particular need. So socioeconomic status example. So how do they benefit? What is the effect of the service? Did it work? Is it working for them? Is it meeting the need of the data you've collected on need? Is the service actually meeting that? And sometimes quite tricky to ask especially quantitatively how did it work? Sometimes you might need to explore that in a qualitative way. Okay it did work somebody moved from unsafe housing to safer housing but you want to know why? What was it that gained that improvement for them? Also importantly what did not work? And again a why question is very often something you can explore qualitatively. Okay so outcomes and impacts. The main outcomes are probably something to do with your what your service delivers. So example here is training community members for delivering mental health first aid. So improving the referrals to services, improving early early referrals might be a particular outcome. Reducing that's a deliberate self-harm in the community. Seeing more self-help in the community might be your identified outcomes. But the impacts of that are technically related to the outcomes. The impacts would be things that are slightly harder to measure but you can measure them specifically by identifying these. So there might be other benefits than knock-on effects if you like. So you've now got a wider community understanding of mental health. There might be an improved care pathway so that statutory services are seeing earlier referral or better referrals and they're seeing an improved uptake of services. There might be increased community cohesion and collaboration and maybe mutual aid groups have started up. So these are sometimes I call them spin-offs from your outcomes and it's showing that the impact of you achieving your outcomes is actually having impacts on wider issues. Okay so what do you do with the data? Now this is something that I'm going to go through in the second presentation but I think in my main message here is that those basic data collection are actually gold dust. You can do a lot with the basics. I think sometimes especially smaller community enterprises, charities and self-help groups can think that all this data analysis is beyond them. It's too complicated. You've got to access as they say the sexual data which is useful but sometimes you just need to look at what you're doing and you realize that you've got a wealth of information there that you could do a lot with. So your basic analysis is what is working? What is it that your service is doing that is actually having a positive impact and outcome for the people using the service? It's important to look at who it works for. So that collecting of basic demographic data, you're looking at not just who's using the service but be mindful of who's not there, who you not be able to reach, particularly if you've got a service that's price itself or has a mission statement to reach out to vulnerable people, to social excluded people. It's very easy to pick the low hanging fruit as some people say but are you actually achieving reach to the people that you want to reach? How it works. Sometimes you can collect that data and analyze that data quantitatively so you can see what aspects of your service are impacting on the people with most need for example but sometimes those how and why questions are more easily accessed by using quantitative or data that's about people's experience. So you're asking people what was the best element for you and things like that. Also of course if you're using, if you're collecting good financial data you can then break that down into seeing how much some of that success costs and then you can do very simple analysis of your financial efficiency, how much value for money you're giving people who are either commissioning you or funding you and people like that. Funders like cost-benefit analysis. Okay I'm going to finish it there and go into it a bit more depth in the second presentation but this is just food for thought thinking of valuing what you're already collecting and not needing to make it to that conjugated. I think we're going to be answering questions later but I'll have a look at the chat. Okay but now we're going to hand over and see a couple of case studies. So first we've got Mark from Circle telling us about his service and the data they use. Thanks Mark. Thank you I'll just share the screen. So presumably everybody can hear. So I'm Mark Wynn and I'm from an organisation called Haywood Middleton and Rochdale Circle. My colleague Leanne the lady who won the quiz is also on the panel. She will answer any questions that you want to put on the Q&A part in the chat sort of box if you will. So basically what does who we circle what do we do and normally when I do a presentation I start with a little quiz and I wasn't going to do that today but then I sort of realised yeah he sort of explains exactly who we are and what we do and why data is really important. So the three quiz questions and you can post answers in the chat is where would you go for a coffee or a meal with your friends? What year did the sex pistols play Manchester Leicester Free Trade Hall in the Breakthrough punk rock concert and what year did the Beatles last play the Cavern Club? So where would you go for a coffee with your friends? What year did the sex pistols play Manchester Leicester Free Trade Hall and when did the Beatles play the last concert at the Cavern Club? And so just going back to what Circle does we're a membership organisation for the over 50s. We operate predominantly in the Rochdale borough but we've got we've edged into areas of Oldham and Interbury. We're launching a North Manchester Circle with partners in Mossen and New Mossen. We have a version in Haringey in London and we've done some stuff in Trafford and we've got some other interested parties going along but basically we put on social events that members asked to do and they arranged for a meeting up for a coffee, going out for a meal, walks, talks, quizzes, that sort of thing through to as you can see on the slide hot air ballooning across the Lake District and indoor skydiving and on this side on the bottom right you'll also see a lady, one of our members who absailed down Rochdale Town Old Clock and we're really successful in what we do. We get really good attendances. The members suggest the event so then we facilitate that so it's very much member driven. We do the things that they asked to put on the social calendar. Sorry to interrupt you on our slides showing. All right. Miss, I'll just come out of that. Sorry it might have felt that. I didn't show the, sorry, apologies for the technical. We did practice this yesterday so again apologies for this. So yeah, so I'll stop through the slides that I mentioned. So yeah, so we put on a social events that members asked for and as you can see from the slides now, they're really broad range and they're really popular, well attended and that's driven by the fact that the members suggest the things that they want to do. The other part of what we do is practical. So we put on practical support, so gardening, decorating, DIY, moving boxes, changing light bulbs, all the jobs, all the people struggle to get somebody out to come and do. We have a team that delivers that. We also operate in a befriending program which we did. We're doing partnership with Give and Take Care which is based at Brunel University. It was developed along with Professor Heinz-Wolf, those of you who remember him. Unfortunately he's passed away now but we developed a unique befriending scheme along with that. And then the final thing, the final core part of what we do is the volunteer driver service. So volunteers drive as a service, take people to hospital, doctors, dentists, that sort of activity as well as to social events. Obviously during the COVID we've had to repurpose a lot of that and so we do collection and delivery prescriptions, emergency and standard food shops, delivery of PPE, information packs, craft packs, that sort of thing. And we've now been able to reintroduce some level of passenger transport. And then they're all great things but we always ask the question at Circle, does Circle work? Do all them nice things? Do those go in it for a coffee, go in it for a meal? Abseiling down Rochdale town or clock? Do they make a difference? And initially we interviewed over 200 of our members. It was an externally verified survey and you can see that the scores are really good, nearly 80% report increased social activity, a similar figure for over 50% improved self-confidence and improved health and well-being, 14.4% reduction in GP visits. Some really good numbers but we were conscious that we asked that question and I suppose if your child comes home with a cake that they've baked at school and you taste it and they ask you if it tastes nice, sometimes you might not give the real true answer and because we were asking the question we had to be sure that we were getting an honest answer. And so what drove us to data was we were contacted by a university studying social isolation amongst all the people and they said we were the best example they could find worldwide and this is just four people based in an office on Oldham Road in Rochdale. So they said could they come and see what we do first hand and meet members and talk to members and we said absolutely and the university was the University of Osaka in Japan. So they flew into Rochdale, came and saw what we did and they wrote a glowing report, sent it to us but they sent it to us in Japanese so it took two months to get that translated but what they said it was they didn't feel they'd walked into anything clinical it was very like walking into a group of friends out on a social event. So we were really pleased with that but that sort of planted the seed of does circle work and how can we prove that. So we got in contact with universities and I think it was as Lucy has just said most organisations certainly of our scale haven't got a research department. So we worked with the University of Manchester and also Manchester Metropolitan University who have a fabulous Q Steps program. So for the last this is our fourth year now with MMU we were able to get a student doing a quantity study on the impact of our work. So year one was the impact of being a member of Circle, year two was the impact of being a member of the Volunteer Drive Service and year three was being a volunteer with Circle. So all that research we would never have the time the opportunity or the work with all if we're perfectly honest to sort of pull together. What that research does it gives you an analytical and as near unbiased analysis of what you do as you possibly can by doing that you obviously open your or expose yourself to possible criticism all them nice things they may not actually work. Luckily the majority of the reports come back with really positive stuff. What they also do is give you advice and recommendations on the gaps in your system. So that is vital in terms of accessing funding. Subsequent to that we've done reports on special projects that we've done with Rochester Barrow-Wide Housing in their independent living scheme. How we expand the model and monetise the model and make it sustainable. We've also done some stuff with the University of the United Nations based in Brussels around our use of tech. So we're a big advocate of the use of tech in all the things we do. We've also done some stuff around co-production and we were featured on people powered projects so people were the members drive the decision making of the organisation. So all that then gives you a huge base to build your funding applications. As an organisation only about 20 percent of our income comes from the local authority. We do contracted work with different people because we can evidence that what we do makes a difference. I think that's the key to why you would use data. It makes a difference to people's lives and it also helps you to sustain the organisation because at the end of the day the only way you can do good is to be there and the only way you can be there is by making sure that you can pay your bills. So that all this university workers led us to get a huge amount of recognition for again just this small organisation based on Aldermen Road in Watchdale. If you go on the government website for CICs we're held as a best practice. We've done different rewards. We've done stuff that we're recognised alongside the private sector as innovators in our field. It led to us being the great amount of social enterprise the year at the end of 2017 beginning of 2018 and obviously that's all that ties back to working with the data sets. We don't do that. We get the universities to do it and there's a huge untapped layer before us if you will that will help deliver positive changes to social enterprises. That then helps grow your influence and your outreach if you will. Mark, one minute please. As we said we got the University of Osaka in Japan came to see us. We've had six different delegations from South Korea. We made a documentary for South Korean TV. We've had visitors from the US plus all over the UK and to go back to the questions I asked at the start so and the reason why I asked them is one where would you go for a coffee with your friends and most people would say Costa or Starbucks or some small independent but when we came when we launched Circle about 89 years ago that the offer to older people was a coffee in a community centre. Now we use community centres we still do and we'll continue to do but that was the only offer but absolutely most people don't pick that as the first choice so we had to to develop that offer. Why I say about the Sex Pistols. My youngest daughter is missing going to concerts she's 26 the 26 year old who attended the Sex Pistols concert is now 70 so the offer to older people has to change to reflect what an older person now is and the Cavern Club the 26 year old who attended the concert of the last concert at the Cavern Club of the Beatles is now in their 80s so I just wanted to show and define what an older person now is if you will so but we always come back to this does Circle make a difference and that's why any organisation does the work you do make a difference and that's why data is so important. So apologies for the glitch at the beginning but hopefully it's all worked out in the end. That's great thank you Mark and now we've gone to hear another case study this time from the Ethnic Health Forum so Haneesh is going to tell us about the work that they do there. Good morning afternoon actually hello hi Lucy can you hear me? Yes we can hear you. Okay I'm going to be pretty pretty pretty quick and short really the question for us was what was the what is it that we were not doing and I think about it two years ago we were delivering services without with minimal funding so we had few small pots of funding in a thousand pound here 2000 from the 500 so we were totalling alone but over that period we then started to say actually if we are to develop as an organisation we need to have some hard evidence so we kind of very crudely started to record stuff we were doing so lots of people were coming into the organisation and mainly started off with welfare rights advice so slowly but surely we and again we were always lack of staff very small organisation we're still only a four part-time staff team who provide welfare rights and other limited services often we were lucky we had a good volunteer as well who helped us to get the data together so anyway what the message that I really want to share is how a small organisation can actually use data information and as Lucy mentioned earlier data is gold dust I think for us putting that sentence or one by line is really the crux of it so I think we've learned over the years to make good use of the data information which actually helped us to build a good case for when we approached funders so we were our major funding came almost 18 months ago with the net community fund rotaries we had a number of meetings and actually we at our first meeting we presented the slides to the officers who visited us and basically they saw for themselves to say here is a small organisation doing really good work across the root level but they're struggling and really it was a simple request with them to say we've done this these are our statistics and we need some funding to employ paid staff who can actually deliver a consistent consistent service which meets relevant standards you know and the client or service user when he or she comes in gets the type of service that they deserve so this is a very crude slide but I think this was the beginning of our our journey and we have we have tweaked this now these were the initial categories you know employment support welfare benefits home office cases that we were either helping clients uh how many referrals from the NHS how many from the Manchester City Council related in terms of you know Manchester City Council or what was it you know we had families who needed filling in a form so that would go in education it wasn't the perfect way to monitor and evaluate but I think this was the start of it we have improved the way we collect data much efficiently now as we have developed uh next slide please Lucy if there is the other one okay this was an interesting one you know this clearly gave the the officers from the community fund and in fact we use this with other possible officers of the health services NHS local authority when we have a meeting we actually present real live data going back three months or six months and say these are the type of cases we are we are seeing and we have broken down so this was actually a slide going back almost 18 months ago we have actually now improved the way so these categories you see here which are maybe about 10-12 categories have actually have become more like 20 or plus categories so we are much better at breaking down exact reason why an individual has come to us or referred to us so again data is gold dust is how you use it to make a case you know to make a case for you know support to make your own case to say actually what you're doing is making a difference and part of this learning journey with our staff to make them help them understand why are we collecting often we had the questions we have now as well you know staff is saying why you want to this why you want to why you want to ask this why you want to collect this and I think if you I think once you once you help them understand the whole reason behind this they are much likely to actually be with you so again statistics very useful so all these things we were not being before and I think again the point is if you are a small organization capacity is an issue I think any small organization needs needs to have some kind of system or help or support to actually capture and reach the stage and one thing I've learned is you don't need to be a you don't need to have you know you don't need to be an expert you know sometimes stuff like this actually as you know a student who is in a he's or her final year of studies at the university can actually come up with this type of analysis you know once you've once you've given them the data information it's time consuming but they can actually help you prepare this so we've been lucky in that sense next slide please Lucy if there's a next slide okay this is again sorry there are only two slides okay if you just go back on the second slide that was on the that we were seeing have I got another minute Suzanne um yeah a minute okay so really the key message was you know is how a small organization like ourselves have have managed to make a case and we have actually convinced the funders so after having showing shown these slides plus others the lottery grant officers were very very very well impressed and said okay we would like some more further information but actually at the back of their mind they went away and said actually here's a small organization in the heart of the community we are in the M14 postcode covering Russia on Mosside Hume and you know there wasn't an organization providing a welfare rights advisory service you know we met the application and we got our basic first grant you know three-year grant which actually at the moment is covering you know salaries for three-part time staff and we have built on that actually so yeah I think presenting and you know collecting good information data makes a good business case as evidence for any organization who are growing and developing really um and we would we are always interested in partnership work with organizations across Greater Manchester I was very very glad I mean I heard Ma the previous speakers and the Rochner organization I think they have done a fantastic job I think I would we would like to aspire to get to that stage and we're good to touch base with them at some stage equally you know developing links and partnerships is a way forward so currently we're also involved in a number of interesting projects working with University of Oxford and Warwick on a quite a big national piece of work around developing an app to monitor data around mental health which is work in progress with I think the Bio University of Oxford Department of Biodata and Warwick's IT department so we are quite innovative in that sense as well we kind of think outside the box you know like to create new partnerships with local partners and you know partners across the country as well happy to answer any questions via email or you know I'm sure Suzanne and her team will share contact details later on so I much appreciated the opportunity given to us today to share our experience yes thanks Hanif and I think just now we're going to switch back to Lucy for just a bit of a sort of demonstration of how the data can be used yeah hi I'm just going to get my screen up and then we'll have a look at that let's go to Slycho Slycho okay so yeah so thanks for Mark and Hanif because they're underlining a lot of messages here so what I'm going to do with this presentation very quickly is to just give you an example of how some of the findings can really work for your service and show you stuff that perhaps you weren't predicting so they're making sense of data this is an example from an unnamed alcohol detoxification service in the northwest this service particularly prides itself on being able to reach out to socially excluded and they're more vulnerable people who are going to be using the service that's an important point that is their raison d'etre so what they wanted to do was to look at how their service was supporting people to complete an inpatient detoxification that is to to stay long enough to to have been detoxified safely okay so a little bit of background is that it's not going to the next one my screen doesn't seem to be going to the next slide for some reason this is weird ah okay okay so um what was introduced in the in the in an area in the northwest as a group of services that were providing detoxification for people who were alcohol dependent was a screening process so this was introduced to lots of services providing these these needs in this area so this service had to go over to a screening process so in other words people were screened before they gained admission to the service so we're calling this here um an open referral what they used to do people who used to be able to walk through the door and say I need to detox or um a screening process that they called gatekeeping so somebody would come into the service be interviewed and then either admitted or put on a waiting list or sent somewhere else so they collected data on who was using the service during open referral um process and during the gatekeeping process so they asked asked the man met to examine this database uh to have a look at client admissions so we also simply compared the data for direct admission people who could just get in through open referral to people who had been screened and then they also had records on who had completed treatment and had a planned discharge that is they were they were sober they were detoxed they were perhaps put in touch with continuing services compared to people who had an unplanned discharge that is they probably left they said oh I don't like this anymore I'm going home um probably to drink uh or had some other reason that they needed to be discharged possibly bringing alcohol into the premises and things like that so we compared the gate kept kept data and the open referral data against what type of discharge people had so very simple really simple um a two by two examination of the data we simply looked at that in terms of percentages so as this table can show it's a two by two table there's gate kept people who had a planned discharge and that was at 79 percent of gate kept people had a planned discharge against 20 percent who had an unplanned discharge they left all they were asked to leave and then we can compare that to the people who had an open referral as we can see only 72 percent 73 had a planned discharge against 27 percent who had an unplanned discharge so just by eyeballing this data it does look like that gate keeping improves the rate of planned discharge I'm hoping you'll all agree with that it's not a lot but there we had a lot of a big sample size so it was actually a significant difference so what we also looked at was those very valuable demographics we looked at people's age their unemployment status their gender their housing type their ethnicity and the SADQ is the substance abuse disability questionnaire of severity of alcohol disorder questionnaire I'm sorry but it basically shows how how much of a problem of alcohol is for these people and then we took one by one we looked at those and looked at successful discharge compared to unsuccessful or unplanned discharge the dropouts and asked to leave etc and lo and behold what we found was that there was a difference in demographics of who was having a planned discharge so just as an example here let's take gender for every one male as open in open referral 1.28 women were having a planned discharge compared with in the gate kept kept the ratio of men to women goes up for women so for every let's say 100 men there are now 162 women as compared to 128 women age gate keeping is as you can see they're valuing people over 45 so for every 100 people under 45 there are now 144 people having a successful discharge under the gate keeping system employment didn't it was was a bit of a strange one that went the other way but for housing again people with stable housing were being more successful with gate keeping than people with unstable housing so I think we've got a poll here I don't know if Lucy North can put it up or just to ask some questions on what you think this data tells us and you can tick on whatever things you think are true or what the evidence you think is telling us here a lot of people are agreeing with gate keeping improving the services efficiency so yeah this data would look good wouldn't it to a funder you'd be able to say look we're being really efficient with our gate keeping is gate keeping making the most of the services resources possibly because we're not wasting wasting resources on people who are going to drop out okay there's gate keeping making harder for those with most needs to access the service well if we can see here that there are some results okay so most people are tending to go with the efficiency absolutely okay so can we stop sharing the results now I think if we finished okay so in effect all those answers could be true it does just depend on which way you look at it and what you value for your service now remember at the beginning I said that this service it's sort of mission statement it raised on debtor was to reach out and help people who were the most needy the people with severe alcohol problems and people with unstable housing the people who found it difficult to get into services elsewhere so while we can say yes we've got we've got gate we've got gate keeping now we're being really efficient we can also show our funders the data on how that gate keeping is actually producing a barrier to people to access our service so what this service could advertise for its services and for more funding is perhaps that's if they get rid of the gate keeping which is exactly what they did they start they went back to open referral and started getting more of those people who were more vulnerable and they could demonstrate then that because we've got an open referral system we are able to help more people who are actually in greater need okay so I think I've got another slide here but which confirms that which is not working again but it basically summarizes that so just to finish then yeah that basic data you could see from these slides that we simply use the basic data that they were collecting as people came through the door we could have done a financial analysis as well which would have highlighted the the results but for this service it particularly focused on justifying what they were there for why they were different to statutory services for example okay I'm going to leave it there and we'll answer questions later