 This session is to summarize or to share with you highlights of new features and new upgrades into DHS. Many of these new features are coming from the feedbacks, especially with regards to improvements that are being requested by different implementers worldwide to make sure that DHS is ruined. So that's actually the purpose of this session of the academy. So the updates that we shall be sharing with you is only the updates that are really focusing on updates, but for the sake of this academy, we shall be only focusing on updates that are more tied to the topics and features that we shall be talking in this academy. So this DHS academy, as we have been saying, is DHS analytics tools, so which means we are focusing on the analytics tools, the built-in analytics tools of the DHS, mainly dashboards, data visualizer for charts, data visualizer for pivot table and maps. And as you are aware, the DHS visualizer app has been upgraded to accommodate charts and pivot tables in the new devices. So in these highlights, we shall be looking at what are the new updates, what are the new features, what are new functions added into the DHS, especially in the analytics part. So every DHS series involves updates to these tools, especially most of the feedbacks from the field. So this overview covers features up until the latest DHS series to 37. So you might find like the features that I'm talking about, I'll be talking about, you may not currently produce into your implementations. So one of the calls would be if you are not using, let's say this 2.37 version, you may not be able to explore those ones, but as soon as you upgrade to upper versions, you can be able to, you shall benefit from these features. So with regards to DHS dashboard, as I said, these highlights will only focus on the analytics tools. So one of the analytics tools which I'll be talking about in this academy is dashboard. So the new dashboard app has been implemented since the version 2.29 that we have upgraded dashboard application. So with this one, it allows for customizing and location of dashboard items, and also you can be able to expand maps to be fully screened. So these are, I'm not sure if I don't have a pointer, but we shall be looking at how we can expand the map to be fully on screen. So if you look at analytics text, if you look down here under the map, you can see we have the analytics text where you can write your interpretations, your comments, and this discussions, based on different features, of course in the analytics tools features. So that's one of the new improvements that has been learned to dashboard. I can see there. Okay, so I would request colleagues facilitators over here to keep on responding to questions asked in the comments, but also encourage participants to please share your issues concerns into this lab. So this is one improvement on the dashboard. Secondly, the dashboard has been has been improved to quickly move between charts, tables map in a single dashboard visualization. So from a dashboard, so you can be able to if you look here can be able to change from a chart to a table or from a chart to a map. So that's a quickly move from one chart table to another that has been also improved. So from also a dashboard, you can also apply multiple filters to dashboard and all outputs will be updated together. So, or maybe during the demo here if you look here on top, we have filters. You can filter out or in computer out some of the features, whether you drill down or you do up to any object of the dashboard and automatically when you validate the changes automatically reflected on the dashboard. The third update we wanted to share with you is the favorite. So within the dashboard, there are features that has been enabled to, to, to start some favorites so it means like you are giving high priority to some of your favorite. The dashboard, especially to make sure that they are well sorted by orders image you can see the immunization dashboard has a star and immunization map and also BCG coverage doesn't so which means as as you go. So. Right dashboard automatically it comes at the first place first position. So that's the dashboard. The dashboard also has been improved to ensure there is a navigation of the menu for managing dashboard items. So, if you look here on top, we have some in dashboards. So the dashboards have been improved to simplify the navigation throughout dashboard items. From the dashboard, they also improved and from here you can from the new dashboards, of course, the new you can up when you are from the printing dashboard, whereby you have that in a dashboard, you have a possibility of being able to print your dashboards and you can print it for any way of printing. So the dashboard also has been improved to support mobile applications for those who are now testing the mobile applications with the recent versions. So the dashboard app has been improved to to both support portrait and landscape orientations within a mobile devices. So if you look on this image. So there are possibilities of seeing the dashboards on your mobile application. And if you look at the beauty of it, it's really, really good for, for, for, for, for visual for use and for so whoever wants to explore this DHS dashboard application. So the, the six improvements is that now the, the dashboard cannot be saved offline. So if you look from from the upper image here on top of at the far end, where we have far end of every dashboard, we are we are we are having now. So this means when you are offline, so we shall see during the demonstration and automatically you have an offline widget. If I can see an offline area, we can click and visual the offline dashboards. So of course, the improvement also the improvements also allows you to move between different dashboards you have saved while offline. So it means if you might, you might be having multiple offline dashboards. So which means the progress also helps you to get through. I see previously it wasn't easy possible to navigate through a dashboard when you're not connected but by making your dashboard offline. So you can easily navigate through the offline, the offline dashboards. So, so this the next. It's adding cascading sharing. This is also a new updates, new improvements to the DHS dashboard application. So within DHS to default layout has also been also been improved. So if you look at the dashboard in the in the dashboard portions, you can play around with it with the layout up to you guys in your limitation to decide what you really want. You want to meet so that you have. You have to organize so you have initially it was there you have to go and reorganize but you can stick decide to any dashboard without you want it and you stick to it. So the second application that as I have said, in this DHS and I think so it's a data visualizer. So as I have said the digital visualizer has been upgraded since 231 and integrate to combine chats and also to combine people table tables. So you can start but see what are the improvements. Excuse me, what are the improvements with regards to chats development. So with the new DHS versions, the app data visualizer app has been improved to include the new user interface for selecting chat types, selecting chat types dimensions and setting the layouts. So that that's something we shall we shall be having in the demo. You can also set your layout. You cannot set your layout as you want. So if you look here. For example, the data visualizer has a place for sales categories and so you can always filter out and play around with the layout you want and stick to that. The data visualizer, of course, charts. So the gold charts has been improved by adding legends and target line. If you look at the legend here, it has also been improved by adding the single value charts, especially looking at the legends, colors and the types. And also, the bar and column charts, legends, the colors aspect has been improved. So, throughout this session, this academy, we shall be exploring all these improvements to see and have hands on. So these are actually very good features that has been gathered from field feedbacks. And that has been integrated so far so far. Of course, you might find some of your feedbacks are not yet integrated. But maybe it requires more time or it requires more changes onto the core part of the choice but progressively your feedbacks shall get be integrated into the new releases. So the data visualizer app also has been improved to as a previously in the previous slide to add chart color set to apply to define color sets to every chart. So here we now have possibilities of a chart deciding I want to use this color set for my chart. And also, it has also been improved to text styling, meaning changing the style of the text, the size, and also even the legends. So now, users has more flexibility to decide what text style he or she wants to use colors, size, and so forth within the visualization. So these are like one of the screen shot taken from demo instance, whereby we can easily choose text features or even chart sets of colors we want to use for a given chart. So meaning like chart color set it means in this area of chart area and why text styling is about these legends. All these texts explaining the figures, the upwards figures. Any question, comment, compliment? Okay. Okay. Most of the issues shared here, the chart is related to people's use accounts. So let's keep on moving to the next update. So data dimension in data visualizer of chart has also been improved, especially making more a little bit flexible to the user. So it's now much more possible to do dimensions recommendations when working with the data elements. Of course, when the charts are. So the DHS, the interpretations, so the panel for which if you look at in the live where I'm pointing. So there is interpretation panel where users can share their interpretations on a given analysis. So all the details related to these charts and visualizer has also been improved to with a very new chart type. For example, if you look here over here bar and line charts that has been introduced. So the, the year over year balance chart is here upwards. So we have possibilities of, let's say, of floating, you can have a chart year by year. For example, this chart shows the last, since 2020, 2019, 2018 chart, the annual, the annual chart, line charts, but we have possibility of lining up the three consecutive years. So on here you can see we have the single value chart. This is a, also the improved improvements that has been made to the new DHS releases. Some of its, these are can be found, not only in 237, but also even the previous versions, especially starting from 231 version. So with the data visualizer, the new improved data visualizer app. So also the new chart type also introduced, let's say combining charts. Let's say here in the first chart we are, we are combining a bar chart and in the line charts. So we have possibilities in the new versions, new release, a new improved data visualizer app, a new possibility, a new possibility of combining charts into one floating area. For example, down here we can also have two categories of charts. So these are, all these are, also all these new chart types that has been introduced, that we shall be, we shall be sharing with you and hearing from you feedbacks, static applications. So they are, so they change based on user feedbacks. So we hope also hope to get feedbacks from you guys on how do you see the improvements made and what are the gaps and what are the new improvements that maybe you may require to have integrated into the new versions. So the new chart type also introduced in this version, 2.237. This is a sketch uploads. So the sketch uploads has been there, but it has faced some improvements, especially to make it more visual and also to make it more interpreted. So if you look here, you can see we have different colors. So see the legends, as also as I said in previous slides, legends has been improved to improve the visibility of most of the charts into the HIS. In addition to charts, as I said, data visualizer as of now combines charts configurations or development and also pivot table creations. So within the data visualizer, you can be able to create, of course, pivot table with, of course, with a very new improvements that you shall be be following the new coming sessions, comparing to the previous sessions. The pivot table since 234, it has been improved to into a single data visualizer app. The previous pivot table app is no longer available sevens, which means if you are planning to upgrade to 2.37. So get ready that the old pivot table application won't be available. But of course, as you've seen, they are very good. They are beauty with this new improved data visualizer app that combines data visualizer on that combined charts creation and also pivot tables. So all previously made pivot tables made in the pivot table app are compatible with new improvements. So all pivot table made in data visualizer are compatible with the pivot table app. So this means you might have some pivot table customized into the old pivot table. But you shouldn't be afraid that maybe you may lose your pivot tables and whatever. So in your analysis, so whatever you have customized with the old batch, I'll be transferred to the new app as you upgrade apps in the recent the chess versions. You don't have any issue. So this image tries to explain a little bit are looking at say if you look at the visual presentation of the app, so it's completely different. Because here with the new pivot table, you see, it's actually better than the new ones, right. So the next improvement of updates made into pivot table, of course, within data visualizer app. This one is regarding improvements meant to data visualizer app. Okay, this is what I have explained. So the persisted layout of people for pivoting items quickly. There are also dimensions recommendations. So which means if you configure the applications. So the, the new app or recommend some of the new dimensions, especially looking at how what will be the most ideal analysis that you would want to do the interface also has been improved. So, of course, in the old HHS, we had also interpretations but with this new pivot table, the interpretation panel has been enhanced. So you shall be experiencing that one also throughout the exercise and the practice sessions in the coming in the coming days. Some of us has been, you know, with some of us have been used with using Excel and being able to freeze some of the columns and rows and people has been requesting these features for long to be able to have similar functionalities to be able to freeze, let's say, if you have, let's say a very long, a very long pivot table and want to scroll down to see but keep on, let's say the columns and and leave out the freeze the headings. So this feature has been also integrated to the HHS and we shall also be exploring this one in the exercise. After any question before, even though this is a highlight we shall have more time to do practice and assess all these features but if you might, in the case you might have some questions up to I can have time to get two or three questions. For compliments from facilitators here. Any question. Okay, so if there is no question, let me go on. No compliments. Am I audible? Yes. Okay, because sometimes with technology you are still online. Okay, good to hear from that you're also still there. Okay. I don't know sir, the audio is on. Thank you very much for the feedback. So the map application since 2.29 has has got very much improvements especially trying to accommodate to feed feedbacks collected from the field from the field from implementers. So the interface, as you can see from this image, it has really completely changed adding new new map layers. If you look in here, we have a thematic layer, we have events, you have track entity, you have boundaries, temperature, specifications, land cover layers. So all these layers have been integrated to make sure that you are more comfortable with the map application and also the map application can respond to most of your mapping needs. Secondly, initially, we had issues by downloading maps, especially combining multiple layers. So this time is now possible. So you can now download your map as an image. And so you can download your map data and be able to look in here. This is really, people have been requesting this feature for a while, whereby you find, even though DHIS can address most of the mapping needs of users, but of course there are people who still need some much advanced QGIS or ArcGIS features that maybe we haven't yet integrated with DHIS within DHIS. So the map application has been improved to accommodate all those requests to make sure that you can download your data and be able to do manipulations into ArcGIS to produce more fancy, more advanced ArcGIS QGIS based maps. So if you look at this image, so you can now download your data as a Jensen format and start to use it for your ArcGIS applications and other JIS software that you may have at your disposal. So with the new maps application, it has really been improved to allow you to map or to display your data table. So you might be displaying your map, but there are some people who are, let's say, depending on the different audience, they want to see your data table. You want to see data that has contributed to the map that they are seeing. So the DHIS map application has been improved to accommodate that request also. So this is the visual presentation of it for you guys, but we shall have more time to do practices on this. The next improvement made on this DHIS map application is to be able to use your data by machines to do something. So if you look here, let's say you might have a disaggregated agenda. In your first bloating of the data, maybe you didn't want to have, you didn't want to have different things between, you didn't want to have... You're breaking a lot, I don't know if it's on my side. I can't hear anything. Does everybody experiencing it? Yes, thank you. Experiencing myself. You've been off for a while. Hi everyone. While writing for others to come back, we shared the training instances in the Mudo. Check on the announcement path. We have the link for what we're using for training. And you shall create the account for yourself. I will share the links in chat as well. So, sorry guys, I had the network issue. I hope my audio bono. Yes, you are. Okay, so let me continue the presentation. So I was explaining that the next improvement done on maps application is to be able to use your data dimensions to filter your maps. So let's say you might have as a user as an example, you want only to focus on male-related data on your map. So here you can easily exclude data related to male to female. I'm mixing up. So you want to include female-related data and you want to exclude male-related data. So from here you can fit out what you want and be able to plot it on your map. So with the map, it has also been improved to create both color plate and bubble maps. So you can choose whether you are using color plate or bubble map. So if you look, bubble map looks like this one. So you have bubbles and here you are just painting the whole area or the whole base on your shape files. So you can decide is it going to be like a bubble map? Is it going to be like color plate map? So the color plate is this one and the bubble map is this one. So you see, so as for the bubble map when you have, so based on your origins, so where it's redwish based on how your origin is, so it's the same thing like this one. But it's here it's presented in a bubble style, but here it's color plate. So within the new maps feature, so the maps have also been upgraded or enhanced to have split view and timelines map. So if you look here, so you can easily split your maps and have it split it and also you can also use different timelines to have different maps. So all these are new features that has been added into the HIS or improved into the HIS for you to be able to maximize the use of the HIS for your different data uses and also data and reporting requirements. So if you look at this image, you can see that there is a possibility of creating map, combining the facility, your facilities layer and also adding including images based on the types of, based on the facilities you want, the image of facilities. This is also another feature for you for those who wants to have real facility image into their systems. Let's say having, we know you used to have, we normally have also the images for different facility types, making them private for private, for public, for referral hospital, for health center. So there are possibilities of having different images and icons for different facilities, but also as the improvements are being made, it's also to be able to add your hospital images into the system. So any question before we go to do a kind of a quick demo of what we have been saying, please raise your hand if you have a concern, maybe I will take like few minutes to give a floor to my facilities if they do have compliments and also try to get your questions. If you do, please. I can see prosper in here prosper in compliments. So if no question I assume you understood everything. So let's go to our demo session. So as it has been explained so during this academy which I'll be using instances instances that has been shared to communicate to you. But if you have missed it out. We shall keep on sharing the links into the slack for you for those who are coming to keep up with us and also we do it together. So, we have, we have two instances for you guys. So we have two instances for you guys. So we have the the academy.demo.dev.org slash configure that you shall be using for configuration works. And also we have the second one as it has been explained to you for this one is not up. Do you see my screen. No, no, only any questions. Okay, let me share my my screen again. Do you see it? The link is also shared here in chat. Yes. As I said, we have two instances for you guys, you have a configuration slash configure instance that you shall be using for the configuration exercise. But for analysis, practice and whatever. As Jean Paul said it already shared on the slide. It's not displaying for me and I'm not sure why it's not. But since it has been shared with you, where is it. Check in the chat here. Okay, for you guys so you shall be using all these two instances for for your review for your analysis rated exercise and for your configure for your configuration rated exercise. So after look. So when you log into your system, you shall see automatically shall go straight to the to the dashboard. So for the sake of this academy, so we shall shall limit this demo to of course to the chase analytics tools. So yesterday when you look at For example, as I've been explaining, so the dashboard has been improved to be able for you to be able to start your favorite, your favorite dashboard. If you look here, you can start your, your dashboard. For example, by doing by kicking on this star. See for every dashboard you have this possibilities of starting it by clicking it by clicking to start automatically. The dashboard with the with the star is given a priority. And also, it helps you searching your favorite. Which meeting. Are you following. My little time. I'm not supposed to be sitting in finance meeting. Yes, we are following the same orders grace. Hello. Yeah, you say grigating. We are very few people here. Okay. So you can see you can easily start your dashboard based on if you wanted to make it a priority, you start it and you, you, you, you the starting helps you to sort to sort your your dashboard. So inside the dashboard as I've been explaining, you see, we have possibilities of filtering. So I've been explaining the filtering. So for example, inside the dashboard. I can say, I want to, excuse me. I want to filter to filter the, for example, let's say one province. So I can simply click here on a province and comes in here and filter only for example, food animal. And when confirmed automatically, the old dashboards are automatically updated with the animal with animal province. So if I go back and say, okay, let me, this is not what I wanted. I can go back and make sure that I say filter both. If I update, I'm sure that this is what I want. And then you see automatically, these filters automatically applies to to the whole dashboard. So you see this is also some what I've been talking about the improvements that has been made on on the dashboard application. So you can also, from this, as I said, so you can also choose multiple, you can also start multiple applications multiple dashboards. So as I said, any, you can start as many as you want, but automatically, the system sort of course alphabetically, the, your dashboards based on how you are going to your, your, your, your, your after starting the dashboard. You can also, for example, decide to filter or change dimensions. Let's say dimensions. Let me use this one connected or not. Let me see. So you can decide to use any policy. I want to filter out only six months. So which means I want to my dashboard only plot all data for the last six months. So if I confirm here, automatically, my dashboards get updated and whether charts, map, pivot table, everything is so is updated based on what I have filtered out here in the, in the filters. So this is really a very good feature for, for, for, for you to, if you are planning for you to do practice on and also explore how you can adopt it in your, in your country implementation. Any question, comments. Are you okay. Yeah, okay. Let's say, let's say, for example, you want to, so there are multiple configuration or changes you can do in here. For example, let's take an example of this first map. For example, you can also do some changes on this, on, on this map. See, you can also change however you want. So here we've been dealing with it with the dashboard. So but also you have a possibility of dealing with, of dealing with your, your very specific, very specific dashboard item. For example, of this one. If let's say I want to only change this one. Okay, let me bring it back. I want to only change this one. So I can open this one and be able to accommodate my changes. And with doing changes, when saved automatically changes are automatically reflected in the dashboard. There was me, I see the network is a little bit slow. I hope you still see my screen. So what's going on in here. We can have network issue in here. So do you still see my screen. Yes, I do. This is actually a network issue that is displaying all the things. It will have displayed the chart the way you want it. Okay. Okay. Thank you very much. So you can see, for example, let's take an example of this, of this chart. We can easily hope to, to change the period in here and probably limited instead of let's say using let's say six months. You can set to say, okay, let's look what is happening into three months and update our, our chart. So you can see, for example, here, the. You can see, for example, here in this, in this chart, we have more female positive HIV positive cases, and also have, have a few male positive. So I also decided to, for example, to change. And for example, let's change the presentation. Let's say you want to, as I've been saying, like they are the new DHS features allows to have free movement from one, moving one object to another. For example, let's take this one. Let's say we say we want to, we want to let me select the, for example, the, the two provinces. And maybe I want, I want this all units. I want this opening to be in here. And update, for example. So you can see, for example, I wanted to display this. Okay, I wanted to display to see how my regions are the state of status in my regions, my two regions. How it's there. So you can see, for example, the animal, the animal region has more positive cases and the food region has very few positive cases. So as soon as I update, I, I, I save changes automatically this one is reflected into the system. So from here, you can also see, for example, the interpretations. So within this data visualizer app, you can easily add interpret right your interpretation in here for this very specific for this very specific chat. Let's say. So, and the good thing you see the DHS keeps records of whoever did what and when that action has been powerful has been done. I can see, for example, the animal region seems to have double cases more than double. I have more than double cases HIV cases, HIV positive cases, comparing to food region. So when done, I can easily save my interpretation and okay, I can save my, I can save my interpretation and automatically the interpretation is there written there and the date and yeah. That's one of the improvements. The next improvement with regards to in addition to this with regards to interpretation. So you can see, yeah, you can manage sharing of your interpretations. So you can decide to reply to a given interpretation, you can hide. You can share the interpretation decide who are you going to share your interpretation if you want to make it public if I'm to share to a very specific group of users, or if you want to edit or delete. So these are features are these operations that you can do with your with your interpretations. Any question. Yes, Campano. I've seen Campano raising the hand is it. So please go ahead, my audible. If Copano is not ready, let's go to Derek. Derek, the floor is yours. Hello, hello. Yes, please. Okay, sorry, it's Copano. I mean, I think we were, we were not allowed to unmute ourselves but it's now been resolved. So that's why I couldn't hear me. Okay, so. Yeah, my question is okay. Did you share the login details for this particular instance? Yes, the, the login details if they are not shared. Yes, I'll be shared with you very soon. I'll ask Jean-Port to share with you the login details in this lab for everyone, right? So that as soon as we start tomorrow session, everybody is ready to start. Maybe just to add upon that, Adolf. Yes, apparently we have, we have the links within the Moodle. So if you go into Moodle, you'll find the links for this DHS2 platform and you'll be required to self register yourself. So apparently it's just the link and the account is going to be created by yourself via self registration. So if you log in into Moodle, you'll find a tab, you'll find a tab written DHS2, you'll find a tab named DHS2 training instances links. So if you open that, you'll find the two links for the platforms. What is for you to move around with all these analytical features, but the second one is going to be on the configuration part. Once we get into validation rules, configuration session. So both of them you have to register yourselves. Make sure you don't forget the username and passwords. Okay, thank you Adija. Any other questions? Delik, are you still asking or we continue? Thank you very much Adolf. Yeah, mine I had with internet and mine was about the dashboards. When we were talking about the dashboards, when you're filtering. When you're filtering with multiple dashboards that we had, we had immunization HIV and whenever you would filter, let's say like you want only the six months, it would appear to all the dashboards. Yeah, thank you very much. You can see here, we have different dashboards. And whenever you would filter, let's say like six months as you did, it appeared to all the dashboards. So now in my case, let's say I want to pick up only one one dashboard. Let's say like immunization only and it's only one that I want to visualize. Oh, maybe it's the only one I want to put into those months. Is it possible or is it possible to be done right here? Thank you. Okay, I'm not sure if I got you well. So if for example, I apply my filter to HIV district dashboard. So it means the filter I'm doing here only applies to this dashboard to all dashboard items. If I would just want to do it specifically for a single dashboard object. So you see here there is, there's three buttons in here. That's where you command, open your application, your object and change and after what do you say. But when you do it from here, it means you are doing for the whole dashboard objects. So whatever you do here in this dashboard, it doesn't apply to immunization, HIV facility, HIV national immunization app. So the other dashboards are very independent. So they are not, they don't have any linkage with this one. Oh, thank you. Yeah. So while we are here, you see we have different possibilities of editing of editing dashboards. And as I said, you see we have a printing option. So for every dashboard you can print. So if you print, all of this, all of this are going to be printed. Let's say if I try to print this one. So the printer is compiling everything. So then when it's done, I will print. That's one of the ocean. Secondly, we have also for every dashboard. No. Excuse me. So for every dashboard, apart from using a printing option here, you can also share your dashboard. And it's up to you to know who are you sharing it with but here we really discourage sharing to all users so to avoid sharing a needed dashboards to all system users. So we have possibilities of sharing with the group and also the access levels where they to view only or view and edit. Okay. So we also have the as I explained before, there's also a possibilities of making your dashboard offline. Let's take an example if let's say I take this one, and I make it offline. So it means as much as I make it offline. So that means when I'm offline, I will have possibilities of making of navigating from one offline dashboard to another without having a conscience that I'm not connected. So this one you can try it by yourself. So moving fast. Let's also see. Apart from using this offline offline. So there are also quite a number of tools that you can explore you can play along with from to see how they really work and give us feedback. You can share with them and if not share with the improvements that you may find more relevant to be added. In addition to to that. So as I said, this three button it's when you want to deal with a very specific dashboard object. And here it's when you want to deal with the whole, the whole dashboard. So that's with regard with the with the dash with the chat. So let's look at with regards to maps, not to pivot tables. So with regards to pivot tables if you look here. DHS allows you to add some legends color coding style for let's say for a very specific. For a very specific analysis you want to do. So with DHS, you can easily decide to come as I've been explaining to come and say you filter out your weather you change because I want to deal with the very single object with dashboard. I can just simply come here and open it up and be able for example to to to limit all units to change all units from this one let's say to to sub to sub to regions. So doing so automatically the system we change and give me the pivot table. So in here. You can also decide to let me bring back this one. You can also decide to to to look into let's say few period few months. Let's say instead of having 12 months, I have six months, and then update. So the dashboard also from this does applies and accommodate changes as needed. So from this one, who can tell me the who can tell me the which district with a very lowest lowest ratio. Come again. I just want to find out if you've been following from this pivot table. So we have said we have applied legends and I just want to find out from you who can easily tell me which district with a very low ratio hiv ratio. Can you make it bigger this small we cannot see why. Okay, I think I think it's the the bed district. Yes, the district. Yes. Yeah, that's so you see the bed district. Huh. So why is it the bed districts. I think we look at looking at the titles of the columns, the fourth column is where you have the hiv ratio on the new on art newly diagnosed interest interest entities. If I do like this. Is it still. It's still the lowest just that bit. I think you have just reordered. Yes, yes, yes, it is still the bed districts. And so you see, with this table you can simply sort by any column. You are pivot table rights. So based on the analysis you want to do you can easily do a sort of sorting. For example, people living with HIV tested that are logically suppressed. If you sort by by the sending order this is how it should be if by ascending order society should be. So you see with this new DHS pivot table, you can still do much much of the analysis as you want. So in addition to still within this pivot table, they are much things you can do for through this options. So see we have saving these are your familiar with, but also in the options we have different features that are here for us to be used we shall have more time to to play around with them by applying so for example this one. We have applied a predefined agent. So which means we have ready created the agent and applied to this table. We have a legend change background color. So this is what you use when you watch series you still can do some improvements that you want. So you can also limit your values you have can also deal with your parameters so there are a lot of things you can do within this pivot table side. And then when you are done you as always you update and for you to see the changes. Any question. I'm sure we shall have more time every day dedicated to every application or every feature mentioned starting from that that additional analysis and configurations charts my pivot tables and maps. We have much time dedicated to every of these aspects for us to really dig deep and do left and right up and down exercise, try to look in every corner of these applications to get familiar and find what is new with these applications. So probably without taking much of your time. I can limit my demo here as we shall have more more time with regards to to this. So maybe I can conclude by maybe looking at the charts showing you how you can. How it looks like, even though you've seen it in the PowerPoint, but let's see if you have on this dashboard. It's a map, a map. So you simply click on it and open it. So it does have the features that I've been talking about. So the network is not so strong. It's posted this way. So what it is distributed display who can remind me the features we have discussed previously with regards to charts. Hello. Hello. Yes, we can hear you. I was asking who can remind me the features we went through regarding the chart the map system is loading. The maps you are clearly indicate about the download button or you can import this to the map for the arc GIS or the QG is these features are the benefits. So, also during the map you can shift or changing into the tables, or you can use the three different dimensions, you can filter it to the map. So there are there are benefits. But also I have seen. Sorry remedy. So within the dashboard also the three bottom I have seen this another feed another benefit which is, if you can click on the bottom there's a full screen you can also show as a slideshow with your dashboard so these are the benefits which we have learned today. Thank you, but also have a question for you. It has been shared for two instance. One is for in the moodle but so one is the data analyte I have made my username and password. But also if I want to go the second instance for configuration do I need to have again another username or shall I use both in one username. Thank you. Yeah, thank you Ibrahim for with regards to to the instance I think as of now we shall be using the, the, the slash review instance. So but as we move forward, as we progress into the academy, the facilitators are communicating the instance to use, but apart from configuration exercise. That shall be done into the configuration the configure instance, the rest of your work shall be done into the review instance. So in every instance you should have you should you have to create the user account. Thank you. Let's see why my network is not moving fast button. Okay, let me use this one. Because I see that one is a little bit slow. So I've been talking about the, the, the maps, the map outputs to the dashboard. So they're actually looking at the, the network issues we're facing maybe may not load easily the maps application. But as hoping up to what Ibrahim said, we have the new maps application has actually improvements on, on, on maps, no layers. So they are very good improvements done performed on layers, new layers has been introduced, and also different maps type and also possibilities of drink down into the maps.