 I hope you can all see the presentation on the screen now. So we are going to start with a brief presentation, which gives an introduction of program indicators. Then we'll have a hands-on exercise. And then we just followed by you all following that exercise on the exercise instance, which is given in the learner's guide. If the instructor of the presentation will start with a brief introduction of what program indicators are, how are they derived, what are the two types of program indicators, event and enrollment indicator types, and what is the difference between them. Then we'll understand how program indicators help in tracker data analysis, which cannot be done by other visualization applications like event visualizer and event reports that you learnt yesterday. Which is followed by again a hands-on. Starting with what are program indicators. Program indicators are computer variables based on data elements or attributes and constants that are used to aggregate individual level data. So for example, I visited a health facility yesterday and I was registered in a tracker program. And the health facility wants to know today how many patients were registered in the tracker program yesterday. So my data will be aggregated including all the other patients' data who visited yesterday. Using a program indicator, which will give account of how many patients visited yesterday. So an aggregation of individual level data is what we get from program indicators. An example which is shown on this screen is the number of first AstraZeneca doses given to patients. So if you want to know how many patients have been administered first dose of AstraZeneca in the COVID vaccination program, then how would you do that? So the screenshot which is shown below is that of an event report. You can see the case-based details and the type of vaccine given to the patients with the dose numbers. Now you can filter and find out how many patients were given first AstraZeneca doses. So account of the number of patients given AstraZeneca doses will be my program indicator result. Now you would say it is very similar to what we get from event visualizer and event report. So yes, the answer is true that it looks very similar to what we get from event visualizer and event reports with added features, more flexibility that we can get from program indicator analysis. And something we do not get from event visualizer and maps. This is something that we'll discuss further. So what is it that we can do with the event reports and what additional features that we are there that we can get with program indicator analysis using tracker data? So what we cannot do with event reports and visualizer and maps is we cannot create enrollment type pivot tables or enrollment type visualization in event visualizer and maps. But the program indicators we somehow are able to perform these operations in data visualizer app and in maps. The pros and cons of using program indicator data analysis, they give you more flexibility in creating summaries of event and enrollment tracker data. And they can be used in tools which users are generally more familiar with that they are used with aggregate data analysis as well like data visualizer and maps. And they also offer additional functionality. So for example, when you are creating program indicators, you can use many filters that help in comparing data from different program stages in the tracker program. For example, if statements, you can count the relationships, you can measure the difference in dates. For example, say sample collection date and result date. You can see the return around time by checking the difference between the result date and the sample collection date. So these are some of the pros that you can see with the program indicator analysis. And what are the disadvantages? So I mean each program indicator needs to be configured manually in the application. For example, if you want to calculate a date difference that need to be set in the filter section in the program indicators. So in this session, we are not going to see how program indicators are configured. We are going to see how they are used for analysis. So configuration is something that we learn in the configuration academy, tracker academy. So another disadvantage, you can say disadvantage is that you can define a requirement for a program indicator when you are creating it. But you cannot change the filter when you are generating the reports real time because the program indicator has already been set. All you can do is generate that program indicator using data visualizer app. But with the event report, you can just drag and drop the filters. And if there is a lot of data that you are going to generate for the program indicator with many filters, then it would sometimes slow the systems. What are the two types of program indicators? One is event program indicator and the second is enrollment program indicator. There is a difference between these two. So event program indicator, it evaluates each event within a particular program stage. An enrollment program indicator, it evaluates the entire enrollment within a particular program. So for example, my information is stored in a program and I want to analyze the data which is stored in any of the program stages in a program. Then I would use an enrollment program indicator. And if I want to compare the data between two program stages, then I would use an enrollment program indicator and not event program indicator. We'll see the examples in the next slide. So in this case, you can see if you want to see the number of PCR tests that were requested. For a particular time period and for a particular organization unit. And you can see that there are two events in this case, event one and event two. So if you are generating an event indicator, the indicator value will be two. If you're generating an enrollment indicator, the value will be one by because the enrollment indicator uses the latest information from the last stage which has been entered. Where the information is entered. The next example of an enrollment indicator, how they are used and how they are useful is in this example. For example, you want to see the number of patients that were hospitalized and they were tested positive for COVID. And the information about the hospitalization status is stored in stage one, which is clinical examination and diagnosis. And the information about results is stored in stage three. So a program indicator will be configured, which will say that account of hospitalized cases and lab results where the result is positive to be generated. And now that the information is compared between two stages, stage one and stage three, that you can get with an enrollment indicator. Now we can see these examples and we can generate some reports in the instance and we can see how they work. So I'll go to the app data visualizer. I first want to generate a pivot table. So what I'll do is on the top left corner, I'll select the chart type where you can see column is selected right now. I'll just click on this option and select pivot table. Then I'll click on data here in columns. I'll select the data type program indicators. The program I'm going to select is COVID-19 vaccination registry. The program indicator I'm going to select is underlying conditions. So I want to see the number of cases with underlying conditions that have been registered. So I'm going to select this indicator, move it to the right-hand side and click on update. I am going to select a period of last six months. So I want to see a trend of last six months here, update and organization unit. I am going to select all the organizations at level two. So I am going to select all of units below the country and click on update. So now you can see that the data is not looking very aesthetic. So we can just change the layout, move the period in columns, update it. And I'll move the organization unit in the roles. You can just drag and drop and update. So here you can see on top the last six months starting March 22 to August 22. And all units on the left, you can see the number of patients that have been enrolled in this program that had underlying condition. Then what we can do is then we can create a chart. So to create a chart, I can just go to file and open new. I'll go to the chart type again and click on say I want to create a line chart. Now these are the all chart types that you can create, which is available as options on the screen. I can click on line chart and then I can go to data. Select my data type, which is program indicators. Select the program. This time I'm going to select over 19k space surveillance. And I'm going to select these three indicators, symptoms present, symptoms present step and recovered. And I'll click on update. The period I'm going to select is I'm going to select a fixed period this time. Yearly say I want to select any 20 then I can select 2020 and update. If you don't have any data in one of the periods, you will see that the chart is empty. Organization unit again, I want to select all organization units below. Level two update. I want to select this year because that's when we have data in this application for this year is 2022. So I hope you are aware of how do we select because you have I'm not going into the details of how what all options are there in the app because you have seen the apps yesterday when visualizer and event reports. But if you still have any questions, you can ask in the chat or once you finish. I will select this year and click on update. So this is what we get. Once you change the layout, you will see the data which is populated in this graph. So now you can see I can. I can see the COVID patients that you have COVID-19 symptoms. In green death in blue and record in red, but I don't really want to see these colors in the in the way they are shown. I want to see deaths in red. I want to see the patients that have record in green. I can't really change the sequence of colors here in visualizer, but I can change the sequence of my data elements to change the how they appear and where they appear on in the chart. So I can just move. Record first on top. Then I can. A symptoms present can be in blue and that's I want to show in red. Then I'll choose the sequence way I want to show them on the screen and I'll click on update. This way I see record in green symptoms present in blue and that's in red. You can also convert this line chart directly in a pivot table. If you change the chart type here, so it was a line graph right now, I click on pivot table. And I'll click on update. So now you see the same information in a pivot table chart also can be open in a map. If I click on open as map, it will redirect me to the DHS to maps option. So the thing with maps is you can use only one program indicator on one layer. I'll click on this. And it'll show me over 19 symptoms present and the cases that have recovered on this screen. However, if you want to add two indicators here, I can add another layer and I'll select on thematic layer. Then I'll select program indicators. Program case based surveillance and the program indicator I want to see is symptoms present and depth. I'll go to style. I'll change the color to say this and I'll click on add layer. Now, if I want to just see the depth here on the screen, you can see this toggle visibility option here. I can just turn it off. It'll show me only the depth. If I want to see the recovered cases only, I can switch the toggle visibility on the symptoms present and recovered cases. Then it'll show the recovered cases only. Now, we can move to the first exercise in the learner's guide which is to create a table. I think we can have a few minutes for you to go through the exercise and ask questions if you face any challenges in generating the chart and table. If you have, then you can ask me if not, then we can move further after 10 minutes and generate the next chart.