 Right, so in the next session, which we will try to do within like two to an half hours because it's a kind of a lengthy session, we are trying to analyze the tracker data using event reports. So event reports is a tool in DHS2 which you might be really familiar if you have used DHS2 or you have even attended previous academies, but we will try to explain the basics on how to use DHS2 event reports and what you can do with it and then we will try to take some examples, different use cases, different scenarios and analyze the data which is already there in our demo instance using the event reports. So the objective of the lesson is to describe the functions of the event reports app and to explain the difference between events and enrollment reports and design event reports using the tracker data, describe the differences between how repeated and non-repeated stage data is displayed and to design event reports showing data from multiple tracker program stages. So these are the five learning objectives we have for this lesson and we will try to cover all of them using the presentation as well as live demonstrations. So during the demonstration I will try to demonstrate a few steps at a time and then you are expected to go through the learning guide and then do it, practice it after me. So that's what we are going to do and finally at the end of this session you will have to do the graded assignments on event reports which will be made visible at the end of the session. Okay so first of all the event reports app is basically an analytics tool in DHS too and it enables analysis of events in two ways. Now you are you must be really familiar with the concept of events and what's the you know like how the events are related to the track entity instance and the tracker data model which we covered on the first day. So when we analyze the data we have two ways first is pivot table type analysis. The pivot table style analysis is where we are trying to produce aggregated values of the events which are there in the tracker. So as you can see here in this table on the top that here we have a tabular output so we have a table with rows and columns and if you focus on the different rows and columns you will see like this is this output is similar to what we usually see when we are using the pivot table app of DHS too. So you have a certain data element so attributes in the rows and then probably more than one data element to attribute as columns and you can see a kind of a comparison based on a combination. So for example you can see here how many like doses of a particular vaccine has been given to the males and females. So it's always a combination AstraZeneca vaccine, how many doses given for the females, how many for the males. So this is exactly what we do in our aggregate pivot table. So similarly based on tracker data we can create a pivot table inside the event reports app. So that's the first type of output that we can generate. The second in fact like a very unique one for the event report is to produce a line list or list of events based on queries and filters. So as you can see in the table at the bottom here we have like all these rows that we have here are different or separate events. So you can see like a dose that was given on a particular date and like when this event has been registered that's the incident date for the unit and then the first name, surname, gender and the vaccine name. So here all the events based on the criteria that we define are listed out. This becomes very useful in case when we want to obtain a tabular output or output say for example like a spreadsheet from the DHS2 so that you can do other analysis outside DHS2 as well as for a record keeping purposes. So you know like in most of the health facilities even though we have the data in DHS2 as line lists they prefer to also keep a copy of the events that took place probably as a spreadsheet. So this is served by this second functionality that we have of line list. So these reports or the tables that we create in event reports can be saved as a favorite just like what we do in pivot table and you can download it as the CSV file or Excel or there are even other formats and also you can save it and add it to the DHS2 dashboard. So these are the three functions in addition to visualizing within the event report app we can do using the built-in event reports app of DHS2. So few things that you have to keep in mind the event report or basically an event report is always based on a program. So that means that this is very important to remember like say for example even though this is not directly possible using the DHS2 tracker capture because when you are trying to register a tracker track identity instance in DHS2 tracker capture you're always registering that person for I mean not only you are registering you are enrolling directly that person to a program but conceptually you can create track entity instances without enrolling in a program. This I'm not going to go into too much of depth because it's a kind of advanced concept and it's not directly supported but if you are kind of using the DHS2 web API for different web applications or integrations this is one possibility but usually in event reports when we are using it always like produce an output based on a program. So you will only see people who have been enrolled who have an enrollment in the program and then whatever the analysis that we do is based on a range of dimensions and filters which is a kind of a combination of data elements periods and organization units. So you know very well the three dimensions the three main dimensions in DHS2 which are what when and where so here the what is represented by the data elements as well as attributes and then period and organization unit. And when you are working with tracker data another thing that you have to keep in mind which we explained on day one is that we have these two concepts called events and enrollment. So let's discuss a bit more in detail what are the differences between events and enrollments which you already know and how it is applicable when we are trying to analyze data using the DHS2 event reports. Any questions as of now? This is I mean I have been only explaining concepts but you will have probably a few more clarifications when we are doing the demonstration. So now this is something that you have to focus very clearly because it might be a bit confusing to understand the difference like it's very basic although so the tracker programs as I mentioned to you on day one can have one or more than one program stages right and each of this program stage will have more one or more events. And when we are creating an output of event type so if you can remember I mentioned we can create two types of outputs in event reports one is event type the other one is enrollment type. So when we are creating outputs of event type then we can see the data from all events within the single programs stage that we are working with. So I will demonstrate it further but as you can see here in this table below you see like that they have I mean in this table we have selected something called the table stylus pivot table and again we have we have another thing called output type and the output type we have an option to select event or enrollment but when you select event what we are like what it will do is like it will kind of take into consideration all the events within that program stage okay and we cannot however weave or summarize data from multiple program stages when we are using this output type. So for example if you can remember our case-based surveillance program had multiple program stages but when we are using this event type output you can only select a single program stage and visualize the data which are related into that stage only you cannot be combining out data that is coming from multiple program stages and generating a report report or a table when you are using this event output type please remember that right because this this like you might have this question like okay I tried to use events but unfortunately I can't combine the the say for example the output the the the COVID output and the COVID test results while that is because the output and the test results are in two different program stages so if you are actually going to do that you have to use the other output type which is enrollment okay so I think it's quite simple but can be confusing if you don't focus well okay. The next is the enrollment type output so what this enrollment type output allows you to do is to analyze data and visualize them across multiple program stages say for example you have in this case-based surveillance program three or four program stages and you want to generate a table which has the test result and the outcome okay test results are in one program stage and outcome data is in another program stage then if you want to display it you have to use the type enrollments and not event and also like you can visualize across an entire enrollment within the program okay meaning like if you want to produce a table output okay and even probably generate a line list which has patient's name age some attributes and then like some critical examination from stage one then something about lab request from stage two about the result from stage three and the outcome from stage four this is the type that you have to remember but still we have one limitation in the present version of event reports which is in case if there are repeatable program stages say for example the lab request is a repeatable program stage right so you can order many lab lab samples using request forms if that is the case when you use the event sorry enrollment type output it will only consider the most recent event for this output right so this is one major limitation is because like say for example you might have ordered five test results a test samples and the results are available from three of them and samples could be serum neosopharyngeal swabs urine like it could be different types but then and your results may have only come for serum and you have outcome of like the patient discharge it'll not really make too much sense if the if the events don't tally between the stages say for example you may have you may get a kind of output from a urine sample request but the latest event for the program stage the test result may be for a blood sample right so then those are the two that will be displaying on the table so that's one limitation you have to keep that in mind when you are designing your tracker program of course designing tracker programs is out of this out of the scope of this academy we have a separate academy coming up probably in december for this so please enroll yourself into that one so where we can talk more about configuration of tracker but like i just wanted to mention you this i hope it is clear any questions but still having said that this is one very useful output that we can use to produce tabular to obtain data in a tabular format from dhs too right so with that we come to the end of the presentation and let's move on to the demonstration i'll stop sharing any questions no i suppose and i and i hope i was audible both right so so now let me log into our demo instance i'm sharing my screen so now we are in the demo instance that we usually use so how to navigate to the event reports app what you have to do is you have to click on this apps icon here and go to event reports right and one more thing i must tell you please do not use the tracker capture or capture application to enter any data like at least today and probably tomorrow because like some of the graded assignments that we are using because like what we did was like we changed the default sharing settings so that you can if you wanted in the first first two days so that you can go there and use this tracker capture app and see how it works right but the thing is now for the assignments we'll be depending on some outputs that have been preconfigured so these outputs again will be kind of altered in case if you start entering data one thing we can do is we can update the sharing settings so that you will not be able to enter data using tracker capture and capture application but we don't want to let you do that so that you can always go there and see what is there but let's see just wanted to mention you don't try to enter any data into tracker capture because some of our outputs that we are producing for the analytics the assignments are based on the data which is already captured in the system okay right so what i'm going to do is i'm going to click on the event reports app and then i do that this is what i get right so here you can see like we have two main parts of the screen one large portion on your right and then we have this left side so left side is where we are configuring our output and this white area here is where your output is going to be displayed okay so here you can see like we can first of all select table style as i mentioned in the presentation whether it should be a preventable or a line list and the output type whether it has to be event type output or the enrollment type type output please try to remind the difference between the two types of output and then here we have to select program right that is because like this large portion is where we are configuring the data dimension or the what dimension of dhi is to and then here we can select the periods so period you can select fixed or relative periods as you can see here or else you can even select dates based on start and end dates right so that you our configuration here changes for us to select and starting date and end date and then of course we have the organization units just like as in any other outputs where we have the entire unit tree which is visible and here onto your right side you have few controls like this update button is is what creates the visualization based on the configuration that we do here and in favorites here we can open an already saved output layout is where you are configuring the columns and rows and filters in your table and of course in options you have few options to fine tune your tables so for example there are options to visualize the row and column totals and in case if you want to get rid of empty rows you have some controls there and download of course it's disabled now because we don't have output is what you use when you want to download this table as a excel output okay so probably because you are already familiar with this I mean how to use tables in DHIS too let's try to focus on one example so what I will try to do now is to open an existing or already saved visualization so I'm going to click on favorites and click open and then I will select the output confirmed cases by age and sex do we have it here yes this one so once I click on that one because this one is already saved in dhs too based on or precon already configured parameters you will see a populated table so let's focus what we have here so here you can see this kind of visualize the data that is coming from the entire country law pdr and here we have rows which are displaying different age categories and we have columns which displays the gender breakdown right so this is a typical type of pivot output that you use that you may be familiar when you are using the aggregate component of dhs too but the same we can do using the dhs to track right but the difference is this data is coming directly from tracker and not just like what we seen dhs to aggregate okay so let us try to produce this table by ours right so what we are going to do here do that is to click on new so that it clears our existing configuration and then we will select the table style as pivot already selected and the output type as events right and then data we have to select the program so if produce this output I will select the program case based surveillance and the stage if you can remember like we were dealing with resource so the stage has to be the stage three which is lambda results okay now remember because I selected event output it will only pull events from stage three nothing else from any other stages we can display in this table okay so now when I do that I get this box filled with all types of data elements and program attributes which are related to stage three like if the list is too huge what you can do is you can limit what is displayed here by selecting data elements so that it will only display the data elements or program attributes so that it will only select the program attributes so let me select few of them I will select the age and sex age is here sorry sex is here age and then I will need the data element which is the test result test result okay this is the one right so what I did was I just double clicked on each of them so that once it is selected it will be displayed on this box below with the heading selected data items so whatever which are displayed here are the ones that are going to be visualized in this output component which is on your right okay is that clear this is same what we do when we were using the pivot table in aggregate but let me also show you something else now here when we are defining the data items that we are selecting for the output you can see few filtering and configurations we can do here right so here like in case if we have now now for example this sex attribute has multiple components right so here it is asking it has given us the possibility to select I mean display data related to both the genders so we can actually what we can do is we can select one of them like male or female right so in case if we select female it will only display it will filter the data that we are displaying only to having females not males so let me deselect that so I can do some filtering probably so that the lab resource I will only display the positive results right because otherwise I will be populating the table with inconclusive invalid negative not perform positive there are so many so I will just select positive so that only the positive items will be displayed on the table not your right okay and let's move on to the period let's select let's deselect first the last 12 months because if I select this there'll be another breakdown based on the month so I deselect last 12 months and I will select this year okay and then the oak unit I will select not the use oak unit I can actually select the law pdr which is the country okay right so next what we can do is we can actually click on update to see what the output will be so I'm getting an output like this so the issue is like this is not really the similar output that we saw in our like the already saved item that I displayed to you before right now you know why right what's the reason anybody you can use the chat you can unmute what's the issue here what do I have to do to make this table look like the one which which was saved and which I showed you before we have to change the layout of the table exactly we have to change the layout right so how are we going to change the layout so if you can recall that previous table it was having the gender or the six attribute as the columns and age was the was as the rows right those were the two breakdowns that were there in the table so what we can do is we will go to layout and we will have we will click and move this six to the oak unit dimension right and we leave age the row dimension so what are we going to do with this lab results and column and the periods and augury so the thing is like period is this year we don't really need a breakdown here so we can move the period to the filter and the oak unit it was for the entire country so we don't we don't actually need to mention it there and the lab result of course because it was only positive we can move it to here as a column but because our last output was like okay let's let's do like this so that we will have the this result right at the top and then the gender and then it will be disaggregated based on row right so that's kind of like how I work out based on the the layout I have in my mind right because we don't need a breakdown based on periods and oak unit I just included that in the reports so let's see whether it appears the way we want so let me click on update button yeah and here we go we have the table but it's still not really the one we wanted any more we can do any suggestions I mean like yeah I'm happy with the layout but now first we will deselect this portal uh total who's effect there in that one other than that anything else we can eliminate the row yeah exactly so there are some empty rows we can get rid of them so what we can do is we click on options here and then we can click hide empty rows that's it click update there we go this is the table that we initially right so okay congratulations we have our first output in event reports so the new stuff we learned uh on dhs2 tables here is everything about the configurations you do here the tables type output type and how to select data and then how to select the field everything else about you know layouts these options we have already dealt with them when we were doing the pivot tip okay so that's it that's it on how to create a very simple uh pivot type uh a table output using event reports okay so let's try to design something quite different so do we have any questions in the chat not yet let's let's do one more example on a different type and then we will let you let you practice on your own so you have refer the learners right so in the learners guide you have a one exercise where you can practice doing the same but i did now so let's try to create a line again um let's open a favorite item this time i'm going to open something called oh first two we have it yeah a six and vaccine name list this one i'm going to click open that and this is the output that we get so as you can see right what can you see okay we have this which is a line list okay we have this line list why you called it line list is because it's it's a table which has uh per row you are seeing um some information related to an event okay so you can see we have the date of vaccination registration incident date the organization unit the national id then some attributes of that person the same surname gender and then we have the vaccine name and the nose now right so this is what and you can scroll all the way down and you will see like this table has 322 pages and all together it has 32122 cases or rows right it's a kind of a massive table that you see here and that's why it is paginated so that you you just don't see the entire table at once right okay so this is a kind of a line list type of visualization so let us try to create the same so what we are going to do just like before is to click on favorites and then live right so let's see what we have to do so right now now for this example the table style is going to be is it people's to line list this line list right not people because here we are going to list out individual events and we are not going to compare the aggregates of uh between different parameters so that's why it's going to be a line list and this is going to be events or enrollment these going to be events right not a kind of a health record across the stages but we will even in this example we will only focus on one stage so I select event and the program is co-act co-indy 19 vaccine registry this one and for the stage we have only one stage here so we will select the vaccination and now we have to select the parameters so let me because it's a huge list let me just filter only the attributes and I will select the first name double click and then the surname my double click so it comes here and then I will also get the national id and six so I have four attributes and let me now select the data elements right here also we have many but I will just select the vaccine um name this one and then the dose number is the dose dose number so you see here I mean even though this is not related um when you are configuring dhs2 this the the naming conventions really matter right that's why like when you are browsing through a huge list it is very convenient if you if you follow a proper naming convention so because here you have this prefix and then a dash and then everything is kind of arranged out in alphabetical order so I will select the dose number fine so we have this huge list so let's do something here now for the dose number let's only select the doses from the dose number one the first dose right so that we don't have a huge list so I selected first dose and then the period I did select the last 12 months and I select this year an open unit let me go and select allow pdr which is the country okay and then um let's also figure out the layout first what we can do so here when I click on layout this is what we have the first mention the event date open unit first name surname national id sex vaccine and dose number so here if you in case if you want to you know like change the order like now I I made it such that you will see the surname first and then the first name right so that you can do here even before generating the table okay right so that's it let's click on update and see whether we get what we wanted click on update here we go we have our line list right you can see here we selected we kind of shuffled the two the the parameters we wanted surname to appear before first name so that change is reflected here and you are only seeing data related to first dose that's why the total event count displayed in this table is 17 000 as opposed to some 30 000 plus rows that we got in our exam okay so here now what we have is a line list of all the events that took place under this program stage what else we can do of course we can download this you just have to click on microsoft excel or csv and it will download uh entire list the event list um which you can open in excel so I think this answered some of the questions that were raised on day one how to get a copy of the data that is captured in the tracker this is the easiest way to get it out like you can also download it from the tracker capture first page line list but you will have a much better control to put the attributes and the event data or the data element that the values of the data element together and build a table from here right so here you have much better control to obtain and out okay and again like the other thing that you can do is you can this we have already demonstrated in our previous academies I can like you can click on save as and you can save um this item um to be used later that's the other thing you can do this is again similar to what we always do with the data visualized and pivot table applications all right so I think we can just stop there briefly so that you will be able to practice so what you have to do is uh before that are there any questions related to the areas that we have covered of course you may have questions about you know enrollments which we have not touched yet so if you have any questions related to previous and line listing related to events please feel free to ask hope it is clear or is it too confusing I went as slowly as possible but please let me know if I need to slow down or if I need to speed up a bit please let me know oh it's just fine do we have a question okay so yeah great thanks for that feedback right so I will just stop here let's take which time we have let's take 10 minutes so what you have to do is you can go to model and open event reports and you will find the learner's guide do only the first exercise which illustrate the exact steps that that were involved in getting the outputs that I just showed you right so only do the first exercise and then we will start in like 10 minutes there is a question back to pivot table showing positive test results by age since this was an event output the number of age doesn't actually represent individuals correct since some clients might have more than one positive test result yeah of course yeah true true that that's that's a limitation because I mean whenever we use events mind you it's always like say for example if you have multiple events for the same person for a stage or like if you have multiple different events like all these are added together so but but then again like if you want to say like you have serum samples urine samples radiology samples that you might be able to limit by have you know configuring the filters but I agree with you like this will have its imitation because the same person might have had multiple events so this is where enrollment analytics will play a crucial role because that then it will only calculate the enrollments and again we have another way of achieving this like that is of course by using program indicators like that I'm not going to like it is not for the line listing like if you want to get a aggregate count of number of unique events for a person you can also try to use program indicators which we will try to describe tomorrow right so not now but there are other ways of doing that and also I must mention this event report app is a app which is undergoing a lot of modifications as we as of now like so you will see a much modified application with more features based on a lot of inputs we have received from the DHS to community in time to come so this application what you're seeing now is one of the like I mean like yeah we can't call it legacy but it's it's a bit of a old app DHS to so you will be seeing a new events event reports have been featured so which will try to address most of these limitations that we have been current question of the app any more questions if not let's try to take a 10-minute break where you can practice the exercise one in learner's guide and let me also try to shift my network to a stable one