Hello, and welcome to this demo on care quality analytics. My name is Ron Bradham, and I'm very excited to be showing you our new product that we at Interworks have come up with in the care quality space. Before I jump into the details, let me just tell you what I'm going be going through today. So we'll be talking about what the product is, the c who the CQC are, the Care Quality Commission are, and what work they do, how we've handled the data, and what we've come up with, and I'm gonna be doing a demo on the product itself, as you can imagine. So first of all, this is me. You can see I've got a similar shirt on and checked shirt there. My name is Rowan Bradham. I'm the public sector lead here at Interworks. I haven't built this product by myself, although I don't mind taking all the credit for it. I've helped. It's been quite a team of us working on different parts of it, on the commercial aspects, on the data engineering, on the Tableau dashboarding itself, and just bring it all together. So I hope I hope you're going to enjoy what we have here. So great. So the Care Quality Commission, they are an organization rather similar to OPAL ratings or to OFFstead that are a government organization that go through and they do safety and inspection reports on all sorts of organizations. So let's have a look at who they who they do. I'll jump ahead to show you who they do look at. So we're mostly gonna be focusing on, care homes within this, but they look at adult social care, trusts, GPs, doctors, dentists, everyone gets CQC rated, along different domains and different ratings, outstanding, good, requires improvement, and inadequate as you'll see in a minute. And they regulate all throughout, England and a little bit, in Wales as well, some exceptions there. And, they have a website. As you can see, this is a screenshot from their website. And you can go into their websites, you can go and have a deep dive and look into any individual particular care home, or other organization. And they also tell you all sorts of details about how their services work. And they have an API that you can bring the data out or you can download the data straight from their website. But as as you can see, they look at all sorts of different types of aspects of of good quality care from safeguarding all the way through to staffing and governance and care. So it's really important that they do it. They do a really important job, and it's really it's really valuable to know as an individual consumer if you've got a a relative or you yourself are looking for a care home for yourself or which particular hospital or GP that you want to go to or for organizations to keep an eye on how they're doing at all sorts of different levels, right from the top, at a regional level or national level, all the way through to individual local authorities, CCGs or brands who want to keep an eye on how they're doing. If you are not registered with the CQC, you can get an up to, fifty thousand, pound fine, and, they have a numb and as well reputational damage if you are not, if you are rated badly within their system. So it's really important to take note of the ratings, and it's it's a really valuable part of each organization within their their data, to understand the data, to understand why you've not done as well as you want to have done and how you can improve or how you can keep going and and know how you're doing, really. So it's really important, that people are aware of how safe and caring their particular location is and what they can do to improve. So, what you can do is you can go onto their website and you can go and you can look into a certain particular postcode and or a particular service or service type, and and go and find out exactly how how you're doing. You for example, here is just an at a particular dental practice, and they can tell you what their overall summary is doing, who's running the running the practice, and so on. And you can dive into their actual report as to why they got the result they got and so on. But it's quite a slow and tedious progress process. If you were interested in this, you'd have to go through one at a time. And it really doesn't give much comparison. It's hard to find the history of how they've done and what the comparative scores are for those in the same industry or same area or same brands or so on. So it's yeah. It's just difficult to know how others are doing, how to compare. I'm a big believer that a number or a rating doesn't make sense on its own. It's only rarely in comparison to others when you get real value out of that particular rating or number. It's comparisons, benchmarking, how I was doing last year compared to how I'm doing now or how is my competitor doing compared to me or how is, all the different sub organizations doing compared to each other in the region that I'm overseeing? So this is where, we come in, to help answer some of these questions. So we've taken the publicly available CQC data, and I'll show you a bit of what we're doing. But we're trying to answer some of these questions. Can I feel comfortable to send my my loved one to one of these particular locations? How are other providers in the area doing? How's my brand doing in the market? And so on. So before we jump into the demo itself, let me just talk a little bit about the technology that is behind the demo. So first of all, we've got, the data being pulled through onto an AWS instance, using MongoDB. And then once that's there, again, there's publicly available data, so anyone can do this. We're then putting it at we're pulling the data into Tableau, which is a business information or visualization software. And we've created some dashboards, some four different dashboards in this demo. And then those dashboards, we're not looking direct in Tableau Server at them. We're looking through Curator at Tableau Server. It's giving us a nice kind of branded and housed environment where we can show a few more extra things within that. So without further ado, let's jump in and have a look at this. So here we go. So here's the portal that we've built here, our CQC portal. And the first thing you notice when you come in is a little navigation pop up. Now do be warned that this particular demo, it's quite far along, but they they we're still not completely finished our product. They're still being worked on. So there's gonna be more added and extra things built in here, including some more tutorials. So this little tutorial just tells us a little a little bit about the CQC and the different areas that it goes into. And you can close and never show that again if you want to, but it's just a little walkthrough of what the different ratings are, outstanding, good, requires improvements, adequate, as I mentioned, and, what the the domains are. So safe, effective, caring, responsive, and well led, and what they each of those particular mean. Then, just going into a few more details there. So let's close that off and have a look. So as I said, we've got four dashboards we can look in, and let's jump through to the first one. First of those dashboards here. Just going to close that again, and we'll just wait for that to to load up. So this first dashboard is called the overall view. And this just gives a very high level information, very general diagnostic, overall area for us to dive around and to look through at our particular, locations. So there's a lot of things we can play around with and change, but let's first just have a look at what we're seeing. So at the moment, we're seeing some head headline information that in the UK, there's thirty thousand rated locations and splits out into outstanding good requires improvements and inadequate. At the moment, this has been cut by region, but we can change this. But we're seeing how which regions have more locations than others, and we're seeing a little map, and we're seeing a timeline of the number of locations across that. You can see a bit of a dip here as we hit the lockdown and then building back up in terms of those ratings again for those locations. So what we can also do is dive into any particular one of these. So for example, if we were interested in Yorkshire, we could click on Yorkshire and just see some more detail where that is and how those ratings number of ratings that happened, over the years within that. What we can do as well is we can look at different, hone in on different types of ratings that we are interested in. So perhaps we're interested in looking at where we can see best practice happening. So where outstanding locations are. We can see the south east is leading in that regard, two seventy nine outstanding ratings, and we can see that shown through here as well. We might be more interested in good locations, or perhaps we're interested in locations that require improvement. What we're seeing in the background, by the way, is the the gray is the total number of locations. So we give a bit of an proportional visualization there within that, and then those that are inadequate. And you can see that's very small compared to the overall numbers, four hundred fifteen out of thirty thousand. If we wanna know exactly what those numbers are in relative sense, we can change this particular metric that we've chosen here, which at the moment is number of locations. We could look at percentage of locations instead. And this will tell us that, in the east, there's the highest percentage at two percent of, and there's the in a much more detail than percentage of locations which are inadequate. So almost double the national, standard there within that. So that's probably something to to worry about within within that particular region. We can also change this instead to an average rating instead to look at what the average rating is across. At this point, it doesn't really make sense to hone in on inadequate, so we can just click back on all locations and see those particular scores. We can see here Wales, but again, Wales is only a couple of data points, that's a bit of an outlier. You can see the northeast is doing very well, almost up at three right down to the west Midlands at, two point eight five within that. We can also look at the number of beds. This is just for our care home data and have a look, within that. So we can see here that the number of beds interestingly here is eight thousand, which is more than a third of twenty three thousand. So that's, when it comes to actual number of beds, we can see that less than a three to one ratio. But if we look at the number of locations, the numbers are slightly different. So it gives us a different view. So fifteen hundred compared to four hundred. So that's actually more than three to one in that ratio. So it's slightly different view we get when we look at the actual number of beds because the number of silos. So what we're seeing there is probably quite a few inadequate locations which are bigger than, than average or the outstanding locations are perhaps smaller than average. So that would be worth diving into and having a look around if that was of interest within that. As I said, we can also choose to cut this at different geographical levels. So perhaps we want to look at, CCGs instead of of looking at geographies. Obviously, there are a lot of CCGs in England, so you can see a huge range here. And, we might wanna filter this down. So let's say, for example, filter this down to somewhere close to me, to Yorkshire, and apply that. And we get a bit of a picture of how our CCGs are performing in, comparison to, or within within Yorkshire, how they compare to each other. We might be wanting to focus in on these inadequate places. And again, perhaps we are interested here. So there's some that have as many as seven inadequate locations which are inadequate, but we might be more find it might be more accurate to look at percentage of locations which are inadequate, and we can see a bit of an idea here. But maybe we want to dive into this in a greater amount of detail. So we could go across now to our locations analysis and see what picture we get. So again, this is slightly similar view, but this within this view, everything is in at a single location. So every data is a single location rather than whatever geography we chose before. So initially regions and then CCGs. And, if we look at all, it's a bit bit overwhelming, but let's have a little look at our all the maps. Not gonna be too informative at this at this analysis at the moment, but we can have a a view of what's happened nationally. So if we look nationally, we can see actually over the years that our percentage reviews, there's been more and more requires improvements have been happening as as the years have gone on. We can also see a picture of the overall ratings by domain. So in and around the two point eight, two point nine three mark with safe and well led being slightly lower scored in comparison to others and caring and being caring and responsive being a little bit higher. So we might want to go back in and dive in to that particular CC our particular region of Yorkshire. Have a look at how we're doing in that particular region. And we might not want to look at all the CCGs. We might just be interested in certain numbers of certain certain CCGs that we have within this, but let's leave them all on there for now. We can see the three thousand locations and forty five of those are inadequate. We can have we can zone in on those inadequate ones and see where they are and dive into those if we want to. But let's go back to all and let's imagine we were a particular brand that was operating within Yorkshire. Just gonna pick one out, Huggies. I like the name and have a a closer dive into sorry, closer dive into how Huggies is doing within within Yorkshire. We can see here that it's not doing so well. One good and three inadequate. And we could maybe take this region off, clear this this filter to see how Huggies is doing, overall in in in all its locations and see that it's slightly slightly better. It's just still not as quite a positive picture within that. We might be interested in a larger brand than that. So let's go back and deselect Huggies and maybe look at a brand such as Barchester, which has a wider footprint within within the care home industry. You can see here two hundred and sixteen homes, and we can see the eight outstanding good improvement. We can see how that particular pattern is going quite similar to the overall national pattern. If we wanna see what's leading to our outstanding, locations, we can see when when those were done, over the years within that. So let's go now and let's go back to deselect Barchester and go back to one of those inadequate homes within Huggies to maybe dive in and see what, you know, what's behind that? Why is that happening? What are the reasons applying to that? We've got some KPIs as well going down down the side for those particular. So we've got nothing there because I think we had we had had outstanding selected, which obviously is there isn't any of those outstanding. So we could go in and have a look at one of these particular care homes and have a deeper dive into that. So let's look at this particular care home, in York and click on that, and that brings up a little navigation menu and takes us into our third dashboard, which is a single location lens. And it we can have a look here. So, this tells us historically how we've done. So actually, we've done pretty well in the past. It's it's the historic ratings behind the most recent inspection. And we can see how long it's been since those particular when it was first registered, how long it's been since various inspections. We can see where regulator activities they have. We can see what specialisms they have as well within that particular care home. Eventually, when this is fixed, you'll be able to click and see here a report right here in this portal without having to leave this particular window. But for now, we can click here and be taken to a new tab and have a look at that exact report here for this inspection and go into all sorts of detail. You can see there's lots of information here that we can dive into that someone who was interested in this particular area might want to have a look at and see exactly which domains were rated and what's gone on within that. We can also go back and have a look. Okay. So we used to be good. So let's click in here. And that again would load that particular window down here with that that rating for the overall inspection for and and details of this particular one, you can go to the registration details and so on. So a link straight to that website. And so we can go back and see, oh, well, we actually used to be good across all of these and see what was going on, what was happening at this particular time of the reports and get some more information on that or, you know, go back and look at the one that required improvement and we can open the open the report for that and go into those sorts of details. The final dashboard that we have here is a comparison dashboard. And within this one, you can pick out any particular locations and addresses that you're interested in. So here, we could reset these filters and then go through and find Huggies, or we could find Huggies in particular brand that it's competing with that it's, interested in. So let's go and and find Huggies here. And we'll just get an overall picture of what's going on within those. And you can see here and compare and contrast across different locations. We could bring in one of its competitors and bring that in to look at as well at the same time and compare and see that. Just giving us an overall picture of, that sort of comparison, that competition that users might be interested in. Great. So that's the end of our demo. I hope that's been helpful and a good idea. If you have any questions, please do reach out to us. We'd be very happy to to take you through this in person and to answer any questions that you have. Happy to go into more detail, as to this overall product and, show you things as they emerge and develop as as we improve as we go through.