 So welcome back everyone to the second component we are going to discuss today is the reports app in DHS 2. So hope everyone can hear me and see the screen. Can someone confirm whether you can see hear me and see the screen? Yes. Yes. Thank you very much. So we'll be discussing the reports app and before that the most awaited moment, the word of the day. So word of the day for today is sharing. So we were discussing how to use dashboards to share data, share visualization. So word of the day today is sharing. So next session is on reports app where we create different kinds of reports in DHS 2. So the objectives are how we will see how to create a data set report and how to create a reporting rate summary and how these reporting rates can be viewed in other applications and how to create an organization unit distribution report and how to upload resources in the system. So we'll start with the reports app overview. So this reports app consists of five modules, standard reports, data set report, reporting rate summary, organization distribution report and resources. So these standard reports are customized reports and which has a specific layout. So that making standard reports requires some knowledge on programming also. So they can be created using iReports using the just for report format. So this creating of standard reports we are not going to discuss today, but because it's out of the scope and it will take some time and it will also need some programming knowledge. So anyone who wants to see how standard reports are created, you can get the help of the DHS 2 documentation also. And so if you want a certain report of your format you will have to use the standard report and we'll be discussing, we'll be starting the components with the data set report. So here it will create a summary of output of your data set values. You can aggregate data by the org unit level or group in the same format. So this is bound with the data entry app. So in data entry, hope you can remember that data elements and indicators, data indicators are accumulated into data set which you report for a certain period of time. So data set could be daily, monthly, weekly or yearly or quarterly likewise as a frequency and you assign it to an org unit where this data is reported. So what you get from the data set report is the data entered into that particular data set for a particular period or a particular org unit. So we have to see the relationship between this data set and the data set report. I will share my browser now. So if I go to reports app, so here we see the five components and I'm going to click data set report. So we will see how this immunization data set report looks in the data set report layout and also in the data entry form. So for that, I will also open the data entry form first for this immunization form data set. So if I go to data entry and I have to select a facility where this immunization data set is assigned. I have selected the cardinal hospital and you can see immunization data set. And if you go down, you can see that it's a monthly report. So if I go to March 2021, so this is the data entry form, the data entry app. You can see data is entered here and the report is completed. So if you go through this layout, there is one box for outreach sessions, another box for vaccination of children, then vaccination of women and child bearing age, adverse effects, stock, whole chain. So there are different components where data is entered. So this form is pre-designed by the customizing people. You can do it in your own instance. You can create your own data entry form and add these elements into that form. So if I go to this data set report now, you can see it's the similar data you get with aggregation. So I will generate this same data set. Let's say we'll start with the same cardinal hospital name, immunization. So I will go monthly. The first thing you have to select is the org init where you want to see the data set before. So you can select at the facility level or you can aggregate to the above levels. I will show aggregation next. Then you select the data set, which is immunization. You have selected, then you select what period you want. You can either select the monthly or you can select, if you want to aggregate it to quarterly or yearly, you can select above levels. Currently, I will show monthly for the same period which I have opened in data entry. March 2021, if I click generate report, I will get the same data here from the data entry menu and on the data set report. So this is useful for aggregation. So currently there is no aggregation, but I will aggregate this into bird district. So if I select bird district, same immunization, data set. So instead of monthly, I can select for the whole year 2020. So I'm aggregating the data for all these org units under the bird district for year 2020 for this immunization data set. Now if I click get report, I get an aggregated data set report for bird district for 2020. So the use of this is you can aggregate up to national level and you can aggregate up to any year. So that is how to create a data set report and the use of aggregation in data set report. So once you have created the data set report, you can either download it as an Excel or download it as a PDF. So if I click download as a PDF, I get this data set report PDF with the aggregated data. So that is about basic creation of a data set report. So if you go down here, the data set report menu and collapse this, you can see there's a button called show more options. So when you click that, you can see conditional drop down boxes where you can select. So these are org unit is disaggregations like organic groupings where organization units are grouped into ownership type OS urban and rural. So for the data set report, you can add this additional organic group if you want. For example, if you want to see data only for public organization units within the urban district, you can select public here from the ownership drop down and get report. So initially, let's say outreach sessions, outreach plan 657, it's like this, all so it's all public maybe. So you can see you can add you can change the ownership or type or urban rural organic groups and add to this report. Let's change it to private then and get report. So you can see there are no reports coming from the private sector. So all this data is coming from the public organization units. I will add another disaggregation another organic group, let's say type, say center and get report. So it will get data from the organization units categorized as health centers only. Likewise, you can filter using these additional options. So it's a very easy method to get a report of a data set, which is reported using the data entry for a certain frequency and you can aggregate it to certain organization levels and certain periods and also restrict filter into organic groups. So it's very small sessions, a very quick session and we will go back to the learners exercise. So please go to the reports component reports menu in the academic page and you can see the exercises the ungraded exercises here you can download it and we'll give you 15 minutes to generate this data set report and you can practice on it and generate additional organic groups. So you can do exercise one and two and we'll start in 15 minutes. So welcome back everyone. So we're going to start the final session for today on reporting great summary. So this is the adoption in our reporting app and we can create summary reports of data set completeness and timeliness in our app. So important is you can also pull the same rates in other apps also which we will show. So I will go to the demonstration. So I'm back in the instance and you can see I'm in the reports app. So we have discussed the data set report and next we'll be doing the reporting rates summary component of this report set. So if I click the reporting rate summary icon, I can see this layout and it's similar to the report data set report. So where I can see a place to select the organic data set and the reporting period. So we will see how to generate a reporting rate summary. So I will select an organic from the drop down. Right. Sorry about that. I had to log in again. So I will select from the animals from the animal region the dog district and I'm going to generate the reporting rate summary for the same immunization data set. So I will select from the immunization from the data set. So I selected the organic, the data set. Next is what period do I need this reporting rate summary? So I will select. I want to generate this for 2021. So I will select yearly and select 2021 get report. So this is the reporting rate summary report. So you can see what you see here is about the completion of this immunization data set by each organization unit, which it is allocated. So if I go down, I have selected immunization for dog district for 2021. And I can see the facilities where this report should be sent and their numbers and the completion rate. For example, the hot dog primary health care center has sent 10 reports, 10 actual reports out of the expected 12. So this is a monthly report. So for one year, there should be 12 reports. So from that 12, they have sent 10 reports. So they have completed an 83.3 immunization reporting rate for this year. Mind you, this is all dummy data. So 2021, we have entered data for 10 months. And next there are two columns. One is immunization actual reports on time and immunization reporting rate on time. So you can see there are two rates here and two types of actual reports. One is how many submitted and out of that, sorry, out of all how many submitted on time. So this timing is decided when you are configuring the data set. I will just show you where it's configured. So when you are creating a data set, you have to give a frequency to that data set and a period for timely submission. So I will open the same immunization data set. So this is the immunization data set. And here you can see days after period to qualify for timely submission. It's 15. After ending the month, if that facility submits this report within 15 days, that will be calculated here as a timely submission. So all 10 reports were submitted within 15 days after ending that month. So same rate of immunization reporting rate on time, same rate applies here, 83, 83. Likewise for each organization unit under the DOG district we have selected, you can see the number submitted, number due and the rates. And we can see also a total for DOG district. So DOG district, there are 10 facilities and there should be 240, sorry, 240, 20 facilities, 240 reports expected and out of that, 170 were submitted with the rate of 70.8. So that is the organization reporting rate summary. Again here you can have additional options. Similarly, you can select only for private or public and you can restrict it to the organization unit group. So but here when you are doing this, there is a limitation for reporting rate summary. You can select only one dataset here and you can select only one organization here and you can select only for one period here. So this is one of the limitations in reporting rate summary, which is which can be overcome by using the other reporting apps, other visualization apps like the data visualizer. I will show how to do this same thing in the data visualizer. And also another disadvantage is this does not respect organization closure. So even if the organization is closed, it will show as a due report. So I will show how to generate this reporting rate in data visualizer now. So I'm going to data visualizer now, which we have done during last week and this week, sorry, last week, last two days. So here I'm going to open one of the data, one of the charts designed for this reporting rate summary. So I will go and click open. So I'm going to open this EPI completeness last 12 months chart. We will discuss that chart now. So if I open that, you can see a similar data that is a reporting completeness as a chart here. So we will see the dimension selected here. First we will go to see what data dimension is. So data, we have put immunization reporting rate. So that is how many immunization reports submitted. And if I go to period, it's for the last 12 months. And if I go to org unit, it's user org unit. So I mentioned that there is a disadvantage in data set reporting, reporting rate. So we'll see whether we can overcome this in this set. So similarly, here also we currently see only one reporting rate. But the advantage is we can add another reporting rate here. For example, if you go to data, and there is a thing called data sets here, which we might have not discussed when we are doing the pivot tables and data visualizer, but we'll discuss it now. So we select this data sets option. So we can see certain things attached to this data set. One is reporting rate and reporting rate on time, actual reports, actual reports on time, expected reports. Likewise, there are certain items where you can select. So I'm going to select reporting rate here. And then I can select another data set. For example, HIV monthly. So if I select HIV monthly, it will calculate automatically the HIV monthly reporting rate for the org unit. So now if I update this, now I can see two data items. One for HIV and one for immunization in the same graph. So it's the same thing, the reporting rate. We have added another dimension, which we couldn't do in the reporting rate in report module. So this one, you cannot add two data sets. But in data visualizer, we have overcome that limitation and added two data sets. So similarly, you can make a table also for the same data. And if you want to change organization units, you can add organization unit, different organization unit, multiple organization unit. And you can add any period also if you want. So that is analyzing the reporting rates using other analytic tools. So I hope this reporting rate summary is clear. Again, you can download it as an Excel or a CSV. So you can try changing this to animal region and you get the report. You can see how many reports are due for each district, how many are expected, how many have reported. Likewise, you can aggregate and analyze how many reports report, what are the reporting rates at each level. So next, we will move on to organization, distribute and report. So if there are any questions you can ask in the chat or in the Slack, we will answer them over the end of this session. Next, we will see about org unit distribution report. So this report is about how the organization units are distributed within a certain level, for example, at district level or region level. So we can get a disaggregated report according to the organization unit group from this. So I will generate a report and show you so that you will understand what this report is capable of. I will go to food region. I'm selecting food region here. So on the left side, there's a place to select the region. And on the right, you can select which disaggregation, which org unit group you want, let's say ownership. Now, if I click get report, I can see all the organization units under food region, according to the organization unit group, that is in each district, how many private facilities and how many public facilities and the total. So using the organization unit groups, you can generate this organization unit distribution report. So this might be useful when we are preparing reports and see whether we have received all the reports and see analyze and interpret. So this report might come in handy. You can do the same report as a chart within this app. If you click get chart, you will get a chart for the same table. Similarly, you can desegregate using other one, other org unit groups. For example, type, how many dispensaries, healthcare centers likewise are in each district. You can go up to national level if you want and see the desegregation within the regions. So this is a useful report when you are doing analytics. So again, you can download, as I mentioned, as a PDF or an Excel. That's about organization unit report. And the final component we are going to discuss today is resource. So sometimes you will have to upload certain resources within your DHS to instance. The most common example is the manual. Manuals which you have made for your system. So you can upload those manuals into your system. Let's see how to upload these manuals. So these will be stored in your server. So I'm going to upload one resource and see how it works. So there's this plus bar to upload a resource. And it will bring this dialog box, very simple interface. So first thing you have to give a name. I will say report. Then you have to select a report resource type, whether it's a file or a URL. So you can upload a link also here. So I'll upload the file first. Next, there is a button called use this as an attachment or not. I will put it as an attachment. And next, you have to select the file. So I will put this maybe data set report which we downloaded. I'm going to open this. So I have opened a data report and I'm going to add this. So now my report is available here. Let's see the options here. So you can either view resource, view that report, or you can change the sharing settings here. So you can add it to public access. So anyone with the logins can download this report and edit it. You can add the resource or you can restrict it to users like we did. So I'm going to generate this report and see what will happen. I'm going to view what I have uploaded. So this is the immunization data set report which we downloaded. Then we have uploaded it into the system. So that is resource, a file. Let's add a link also and see. So I'm going to add academy link maybe. So I will select external URL this time. So now we have to add the URL, type the URL here. So I will add the URL of this course. You type the URL here. I'm going to add this as a resource now. So there is some resource with the link. So if I click that, the page will be opening. So that is about adding resources. So it's easy to upload your system user manuals and share it with the users with this resource option. I'll go back to my presentation. So we have discussed reporting rate summary and how to generate it in Visualize. And about organization unit distribution report and about resources. So that's all we are doing for today. We have located time for today. So you can do the three exercises. Remaining three exercises, exercises three, four, and five. And also, if you go to the academy page, you can see there's a graded assignment on dashboards. So few questions, easy questions, which I have already discussed in the lecture. So you can answer them and submit this. This is a graded assignment worth 10% of your final grade. So that's all for today. So if there are any questions on what we have discussed, you can ask. Please practice the rest of the three exercises, exercise three, four, and five on the reports app. And also complete the graded assignment. And I wish you all good luck. And please, if there are any questions you can raise now or you can put it in the chat in the slide. Thank you very much for listening. I'll just remind the word of the day, it's sharing. And I'm going to stop sharing now. Thank you.