Deliverable 4 - Population Health Management Dashboard

Live Class Recording M4

January 27, 2026, 8:58PM

29m 46s

Merle Point-Johnson started transcription

Merle Point-Johnson 0:03 To our presentation for Deliverable 4 in the Population Health Management course, we're going to be looking at data dashboards today and that's a really important element of what we're doing relative to your program that you're implementing, your population health management program that you are going to be implementing. OK. So the presentation goals are as followed. We're going to describe the requirements for Deliverable 4, which we do in each one of these presentations. We're also going to examine the role of dashboards in population health management. We hear a lot about dashboards, but I just want to make sure that we are covering it in such a way that it's. Meaningful in terms of applicability to your population health management program that you are going to be implementing with your organization. We're going to also analyze the deliverable requirements. We're going to look at every element of it, meaning we're going to look at what the rubric is going to be requiring that you do in order to achieve mastery and. each of those criteria, criterion. OK, so we're also going to discuss best practices when it comes down to submissions, and we're going to review evaluation determinants for submissions, as well as a reminder, a supportive reminder of your deadline for a submission. submitting coursework for this particular course. In other words, when the term ends. All right, so let's start with a motivational quote. And this quote is from Malcolm X. It is Education is the passport to the future. For tomorrow belongs to those who prepare for it today. So in other words, you've got to get it. You got to prepare for anything that you're going to be doing in life. You've got to have a plan. You've got to prepare for it. So, and sometimes that will require that you have an alternate plan or a Plan B, as you would call it, right? But you've got to. Have some kind of plan in place. All right, so let's go into what competency you will gain from this particular module. So for this module, you're going to gain the competency of applying data analytic methodologies to diverse populations to address population health needs. So. Is. Important to understand what the competencies are, particularly when we're starting to talk about data and data analytic methods. This is what we're going to be doing as a foundation for creating the data dashboards. Now I've heard a lot of students express concern that they've never done a dashboard before. They're not really familiar with that. Data dashboards. And so sometimes it gives them a little bit of insecurity, if you will. But let's just go into, let's just break it down so that you understand there's nothing different from what you always do anyway, right? So we're going to talk about that in terms of how we normally see data dashboards, OK, so before we do that. Let's go backwards. Let's take a step back for a moment. So we're going to connect the dots as we do each and every time that we have these presentations or these live sessions where it comes down to how this population health management program is going to take off. So let's look at the beginning. So in module one, and I like to connect the dots. I know it's kind of repetitive, but sometimes that helps to see the bigger picture. So in module one, you were asked to look at a community health needs assessment and in doing so, what you were asked to do was to describe a local. Healthcare profile, looking at population demographics and statistics. So this example I'm showing is a smoking cessation program. So you are assessing the population health needs using that community health needs assessment. The reason why that is so very important. Is. because you are going to advise your organization on the type of population health management program that they should actually implement. You do not want to waste resources by just making yeses at this, and the community health needs assessment gives you evidence informed. It gives you evidence so that you can make an informed decision based on the evidence that you see. OK, so you're going to assess populations' health needs using that community health needs assessment. You're going to the CHNA really indicates a large number of residents are diagnosed with lung cancer in this particular. Example that I'm using looking at the smoking cessation program, what we're saying is that the CHNA, if you're going to implement a smoking cessation program, you want to make sure that the numbers are there to support the need for that particular program. So in this instance, it indicates for this particular UM. Challenge our concern within that community. These individuals were developed, they developed lung cancer. A large enough number of individuals in that community developed lung cancer. So your organization is going to say, well, because we have so many people in this particular area. based on the CHNA developing lung cancer, maybe a smoking cessation program would be a good idea, given the fact that we do know that smoking cessation kind of helps because lung cancer is often associated with smoking, even if it's firsthand smoke or secondhand smoke. OK. So you're going to identify KPIs. This is what you did in module one. So if you had that as your program, smoking cessation program, a KPI might be the number of residents that enroll in your program. Because if you do not have any residents enrolling in your program, then that would be not very beneficial because you want you. utilization of your program because it will be a waste of resources. Another KPI would be the number of residents who quit after going through your program. So both of those will tell you whether or not the program is succeeding. So that's what you're looking for when you're looking at key performance indicators. How well is this program succeeding? Meeting the goals and objectives that we put together as an organization. Is it doing the right thing? Is it going in the right direction? Do we have to make some tweaks to the program, or do we, in rare instances, have to scrap it all together? So for module 2, you're going to prepare an executive summary. So in your executive summary, you're going to identify data sets that are needed to support the company's Population Health Management program. So in this particular case, data really is referred. Well, data always refers to numbers or sometimes data. Can be, I mean qualitative as well, but we're looking at quantitative variables, so we're looking at any numbers now. So in this case, some of the data sets that you might want to use to include in your presentation is the number of individuals who smoke if you're an organization and you look at the. Numbers and maybe there's 500 members in a small community and only two smoke. The organization might not want to invest in a smoking cessation program because they'll be putting a lot of resources into it, and that might be cost prohibitive. But if you're in a small community of 500 residents and maybe 300 or. 400 smoke, then definitely that might be an indication that this program is needed and would be utilized. So that's another data set. Um, the average number of years an individual has been smoking. That is another data set and that's important to your program because the longer an individual smokes. The more difficult it is to really break the habit. So you at least know what you're facing when you're an organization who's developing a population health management program for smoking cessation. So in module 3. Identify the sources of data. The sources of data could be from electronic health records where you see the ICCICD 10 CM codes, right? And that's just your diagnosis codes and the data from the EHR, other data from the EHR, maybe smoking. Surveys were sent out and maybe surveys were sent out and people were indicating that they smoke and you might get the data from that as well. So those are your data sources, potential data sources. And then you want to also in module 3, you would have also had to describe the use of readily available data, how important that is that you're using. Secondary data because it's already readily available, and that's really going to come through using your community health needs assessment. Sometimes individuals might be able to go to the health department website in their local community and visit that website, and that might give you data as well, but wherever you get the data from. That. You're describing in module 3 for the module 3 deliverable. So we've covered module one, which was identifying the program based on those factors that we discussed. We look at deliverable 2, which is which data are you going to need to show that this is going to be an important program, a relevant program. A program that's going to be used, a program that's going to help solve an issue that's already identified in the community health needs assessment. And three, where are you going to get the data? You know what data from Unit 2, you know what data, Module 2, you know what data you're going to need. So now you're going to talk about, well, where's that data going to come from? OK, so those. Those are the components that we've covered thus far. So 1-2 and three. Now this becomes the fun part. You're going to be creating a data dashboard because you're going to use that data that you've already said you're going to need, right? And you're going to develop a data dashboard. OK, so a data dashboard just for our own. Understand. Finding a data dashboard. This is information management tools. These are where you visually track, analyze, and display performance indicators, key performance indicators, your metrics, and the key data points to monitor the health of a business department or specific process. In this case, you're going to be using the. Got a dashboard to put a visual to the data. In other words, you're going to be saying to your leaders, this is the data that we've captured based on the community health needs assessment. So we put it in a visual because there are many of us who are visual learners and if you put it in a visual. Hits a little bit differently than you're just giving them an executive summary. When they see it, they definitely can relate to it a little bit more because you're putting the data right there in front of them. All right, so let's just talk about what a data dashboard is and what and why you shouldn't be afraid of the data dashboard. So this is a car from the 1900s. Back then, cars didn't go any more than 35 miles an hour, which is totally quite different from what we see today. So 35 miles an hour was very that was very fast car, but there was no speedometer in the car, right? It didn't tell you anything other than the car's moving. You just know the car's moving. So there was no speedometer in the car. Well, at some point in time, we started to realize that we needed that data in order to see just how fast people are going, right? So that's we created a car dashboard, right? By the mid 70s, just about every car had a dashboard, but as cars were evolving, the issue of safety. Really became of some significance, right? And so in 1948, the Tucker, which was a car, I don't know which manufacturer, became the first car with a padded dashboard. So that's what a dashboard looks like. That's a data dashboard. You know, this is old school, but that's a data dashboard. So again, when we reach the 1970s. Then almost every car had a data dashboard, but that's what one looked like from the early on. Now this is what one might look like today. So we've come a long way. We use a lot of artificial intelligence. We use a lot of technology. Technology has advanced so much so that this might be what a data dashboard looks like. Of course we. see a whole variations across the board of what data dashboards look like. This is just one example of what one might look like today. OK, so if you look at this, it gives you a whole lot of information here. That's a very complicated or complex data dashboard. Now, of course, you're not going to be Anything as complex as this, but I just want you to understand that it's not something that you don't see every day anyway, so I want you guys to feel comfortable in understanding what it might look like. All right, so data dashboards and car dashboards. If you think of data dashboard like a car dashboard, but instead it shows you know when your car shows the speed, fuel level, those things translate that to how healthcare use the data dashboards. They look at wait times, they look at infection rates, they look at patient satisfaction data. And performance management in general healthcare. So those might be the images that you will see instead of these images that you see in a car. OK, all right. So for your population health management program, it may show things like the average age of individuals living in a particular community. So it might show a data. Image of the sociodemographics within a community, which is always a great place to start. Number of teens who report having unprotected sex. If you're doing a teen pregnancy prevention program, that may be a very good data. Depiction on your data dashboard are the average income of residents in a particular community. So this is something that could be used across many population health management programs. So again, this is what you want to include. Excuse me. So what you will find in looking at your and creating these data dashboards is that healthcare really and truly has a lot of ways that we can process data anymore. We've always had data, always had data in healthcare. We just never had the. capacity to store the data, to interpret the data, and to apply it to the decision making that we do today. Because of rapid advances in technology, it is really made much more possible. OK. So if you have any questions about that, please don't hesitate to reach out to me. I want to make sure that you guys are feeling comfortable in the data dashboard presentation part of it. So just let me know if you have any question or you think of any questions as you're working on it. All right, so let's look at the scenario that you guys are faced with for this particular deliverable. So you have assessed your local population health needs and in deliverable one, identified data sources and data sets in deliverable two and three that you are needing in order to help providers make a. immediate gains and patient outcomes. So your Health Systems Board of Directors is requesting that you develop a high level population management dashboard. For this assessment, you will need to assess the local population health needs and identify data sources and data sets. You've already done that part of it, so now it's just about putting it all together that are needed to help providers make immediate gains in patient outcomes. So in other words, you're going to be looking at the data sets. And you're going to put them into a visual display, and the goal of it is to show how important this data is in order to improve whatever issue that you're you've decided to help with in your community. So if it's teen pregnancy prevention, the only way that you're going to know that this is. Actually, an improvement your program is improving as if you monitor the data. So put the data on a display and your organizational leaders will understand what your metrics are for determining whether or not the program is successful. So there's a major undertaking to plan. Design and implement A robust population health management program. You're going to be investing a lot of resources, both financial and human and even technical resources to the data that I mean to this program. So the data dashboard is going to be very supportive in helping you to that end. So therefore your health systems board of directors. Is requesting that you develop a one to two page high level Population Health Management program dashboard. In other words, they want you to show them where this program is going to be successful. In this dashboard, you're going to list the health needs based on the community health needs assessment and the critical data sources and sets. Needed for the Population Health Management program that you're planning to launch, for example, Teen Pregnancy Prevention program, which data did you identify as necessary? Then you're going to put that in different charts on your data dashboard. OK, so you're going to refer to the data from previous deliverables, mainly from your. deliverable too. So the data that you've said is going to be so important in order to determine that the program is going to be beneficial to the community, that's the data representations that you want to have on your data dashboard. So if you're saying you are going to have a teenage pregnancy prevention program You certainly want to know the number of teens that have admitted to participating in unprotected sex, the number of teens in the community. First of all, you also want to look at. The number of teens that are on oral birth control, maybe that's a data set that's not necessary, but it's still a data set. Anything that you can come up with that will help to support the need for the program. The number of teens under the age, a certain age, you know, that's what you want to put in there. OK, so. So bottom line is any data that you think is going to be supportive of the need of your program, that's what you want to highlight in your data dashboard. So using the information from modules 1-2 and I highlight 2 here in red because that's really where the bulk of your information will come and summative assessments constructed data dashboard that. List the health needs based on the community needs assessment that that was performed. You've already got this information at your fingertips. Just use the community health needs assessment and the critical data sources and data sets needed for the Population Health Management program that your organization is planning to launch. All right, so you might want to be asking, well, how do I create a data dashboard? There is a software program that is wonderful in doing it. You can go to you can Google canva.com. You might find other software platforms as well. But the that Canva is designed to do just this. If you've not been familiar with Canva before, if you've not used Canva in the past, then what you might consider doing here is just looking at Canva and through YouTube and it will walk you through the process very, very. methodically, and it's really a very big help. So if you've never done a data dashboard before, Canva is a really user friendly, very intuitive program. So if I were you, I'd go ahead and start by looking up YouTube videos on how to use Canva. And and I'll tell you, when you go to canva.com, it is a free design tool. You do not need to spend a dime for this. They will offer you the upgraded version, but you don't need that for the purpose of this course. Uh, you could use the free version and it works perfectly fine for the purpose of what we're trying to achieve in this particular. Particular classroom. So keep in mind that you don't have to pay for anything, just go to canva.com and go with the free presentation and even on that website it offers you a tutorial on how to get this done. So please don't hesitate to use that because that's going to be. A very, very useful tool for you. So Canva will ask you what are you trying to design and you could put in there a data dashboard for population health. OK and by the end of your session you might have something that looks similar to what I have here as an example. Example. So you you will want to make sure that you're using data and and making sure that you're we're going to see these different types of graphs that will show a highlight the data that you're going to be using and that's going to help gain support for the program that you're trying to implement for. Your organization. Again, canva.com is free and and and it's really important that you understand it is always free to every individual. If you want to unlock premium features, you don't need to do that for this course, but you do have the opportunity to do so, which will cost you, but you do not need. need to do that for this course. Individuals can upgrade to Canva Pro to easily create professional designs and content. The ease of what you're doing in Canva is going to be the same. It's just that you get more features if you upgrade it, but I highly recommend that you do not upgrade for this particular course. for the school work. You could do that on your own, but I do not want you guys to feel like you're needing to do that in order to create a professionally looking Canva output where it comes down to your data dashboard. Now you can also use PowerPoint. That's the only two options that I can think of that would really stand out as something that you want. Well, but Canva is not the only because there are other software platforms. But in other words, don't use Microsoft Word because that's not going to do what you need it to do. Some people feel like Excel would be good if you're perfect at Excel. Then maybe you can design one, but I have not seen one that looks good and that looks like a data dashboard should look from an Excel creation yet. But you can use PowerPoint. The reason why I say PowerPoint and just use the two slides as the 2 pages and not a PowerPoint presentation. You still have to do a data. Dashboard not a presentation please. But I recommend if you really are uncomfortable using Canva, even after you've looked at the tutorial and given it a try, you can use PowerPoint. The reason why PowerPoint might work for you is because you can easily manipulate the images so you can put it in the order that you want to put it in. PowerPoint will allow you to put the numbers in and create your graphs right there on the screen. But Please remember you want it to look like a data dashboard. So let's just see another you can use the example. Go back to our example of teenage pregnancy prevention programs. So the data sets might be the number of teens in the community. We know that socioeconomics often play a role in this. So income levels, education levels, the age of the individuals within the community, and you can also look at the age of those individuals who are between the age of 13 and 18, for instance. And that's totally up to you. And what you can do is create visuals such as bar graphs, pie graphs, and line graphs. OK, so I tell you to use a bar graph. So let's just talk about what that looks like. This is what a bar graph looks like. So the bar chart. Also known as a horizontal column chart. This is really popular for many reasons. You don't want to just use one thing. You don't want to have all bar graphs. You can. You need to really vary it, and I'll show you a couple of others in just a second. But it's easy on the eyes and quickly visualizes the data sets, and that's what you want. OK. bar charts, you can quickly identify which bar is the highest or lowest. And as you look at, um, this is a birth rate per 1000 of mothers aged 15 to 19 by a specific race. So the race are all highlighted in the legends here. So you see Hispanic, Asian, Pacific, American, And. Black, white and the total there. So if you look at the bar graphs, obviously you can see which ones and and these are in years. So the blue was for year 2006. So if you look at year 2006 in the Hispanic community at taper, it went down a little bit but then it went back. Up. Well, for Hispanics, it was up. And then you look at the Asian Pacific, it was low. And then you look at the American Indian, it was a little bit higher and black Americans were even higher than that. And so you can look to see when those numbers change. So when Hispanics went down a little bit, where it. comes down to the the next year. If you look at the green, that's going to be your, um if you're just looking at Hispanics numbers, for instance, the blue represents 2006, 2005 is green, 2004 is the orange, and the purple is 1991. So if you look at, again, Hispanics from 2006, they had the highest representation there. And then it went down a little bit. That's what I was about to say earlier. It went down a little bit uh for 2004, but it was, it kind of tapered off a little bit because in 2005, it looked close, very close to the same thing and it went back just a little bit. It nudged up just Little. When you're looking at the purple, OK, so that's what your your that's what your data dashboard should include. Bar graphs should be one option. Pie graphs is another option for you to use. A pie graph chart represents the numbers and percentages and the total sum of all. pies should equal 100%. So in other words, if you have 50% on one side, then you need to have 25% and 15%, 25 and 25, that will equal 100. So whatever the numbers are, that's what the numbers you want to make sure you display, but you want to capture that 100%. So when considering Charts and graphs to employ visual data. Pie charts are most impactful for your audience if you have small data sets. OK, so use a pie chart for the smaller data sets and because you're going to be using multiple data sets, OK. Line graphs. These are you compare and present lots of data all at once, OK? And then you show trends. And that's really an important part of line graph is to show trends in the data. So these are just three examples of what you might include, OK? And this is what the example might look like. So I did this on a PowerPoint slide just to show you what I meant when I said you can manipulate the images and put it in any order that you want. OK, any questions about any of that, please don't hesitate to reach out. I really do look forward to those questions because it lets me know. The. You are engaged and it also lets me know your thought process and it gives me an idea as to how I can best support you in completing this particular deliverable. So again, any questions that you have, please do not hesitate to reach out. Again, I look forward to those. So as a reminder. A supportive reminder. I know we have quite a bit of ways to go in this class, but I do not want you guys to kick the can down the road. You know, just keep kicking the can down the road because it makes it easier to do because you don't have anybody saying submit every week. So what I want you to do is pace yourself in such a way that you are really keeping up. With the information on keeping up with the deliverables based on the weeks. So I recommend you try to do at least one deliverable per week. Now I know that's a very ambitious goal and most of us are not going to be able to do that. But I do want you to give it a try because what you'll find is that you might end up with a deliverable averaging 1. 1 1/2 weeks that will get you in good position for the course. But the last thing you want to do is put it off and put it off and then at the end of the course you're stuck with so many deliverables that is overwhelming. OK, so you know you've got resources, you can always contact me. We can work out a time management schedule for you or. You know, I can help you one-on-one. And during the times that we have the live question and answer sessions, those usually end up being one-on-ones. OK, so, but reach out to me, let me know how it is that I can help you. OK. So thanks everyone and I will see you in class.

Merle Point-Johnson stopped transcription