 Hi everyone, welcome back. So I think we have two more major topics to cover for the day. The first one being the event visualizer where we are going to discuss how we are going to visualize tracker and event data as charts. And the second is the maps. So we'll be discussing how we can visualize the event data and the tracker data that we have collected in a maps format. So out of the two topics, we will first discuss about the charts. Most of what we will be covering today for charts has already, I mean, most of you must be familiar because we have kind of dealt with most of these topics in the foundation course as well. But we will just do a basic recap and see what additional features are available in the visualizer app and of course what are the limitations. So let me share my presentation first. Right. So the objectives for this session is to describe what event visualizer app is about and what is there in the interface and also understand how to create visualizations using tracker data and describe the limitations of event visualizer app when working with tracker data. So the event visualizer application enables analysis of events in charts format. It is somewhat similar to the data visualizer app but this is specifically for tracker and event data whereas data visualizer app we are also using for visualization of aggregate data. So this event visualizer app is particularly useful for visualization of variances in option sets. So for example if we are having an event or we are capturing a data element which has option sets attached for example it could be the gender as male and female it is quite handy in visualizing these kind of variances in the option sets. But we must also take into consideration that event visualizer only allows you to work with data from a single program stage. Right. So we are not able to pull data from multiple or different program stages and visualize them in the event visualizer. So there is no and also there is no enrollment type output option for event visualizer. So it is only visualizing the events no enrollment and also therefore we can't actually combine various data elements from different program stages and visualizer. So that's a major limitation in the event visualizer app as it is now. However this application in its current form will be replaced but we are not able to mention at this point of time when it will be replaced and the new application will be made available. Right. So we use in the visualizer app we can actually design a chart based on the event data we can save it we can download it and we can also add it to the dashboard. So what is there in the event visualizer interface. So it is somewhat similar to all other DHS to analytics applications that we have discussed so far. So when it comes to the data dimension we have the program and program stages which kind of defines the data source. And then you also have a range of other dimensions which includes data elements or attributes periods and organization units. And one key thing which is not there in event reports that you have been event visualizer is the chart type. So we can select which type of chart you want to visualize. Right. So what are I mean how do we kind of create a visualization with tracker data using event visualizer. So going back to basics, we always need to remind about the tracker data model. So as per the data models as per tracker data model, we identified different components right. So we have to configure them in the visualizer app for us to generate a visualizer. So, first of all, the most important thing is of course to know the data source which is the program stage data elements and attributes, which will be visualized in the visualizer application. Something different that you didn't have in the event reports is to select the chart type. So when we do that it will kind of determine by nature of family to report to be presented. For example, if you want visualization related to trends. Right. So, in that case, are we going to use column charts line charts bar charts, right. I mean, there are like about more than I mean, somewhere around the five to 10 different chart types that we can use in event visualizer application. So when to use what chart type, you always need to figure out so you are not actually going to use try out all different types of charts for all the given use cases. It has to be rational why we are selecting a particular chart type over the other. And then we also need to define the data period and organization unit. And finally, we have to. I mean, this is something that we are also did in the event report application like we also can decide what will be the layout. Right. So, based on that we can decide like what will come as the category dimension what will be the series. So this is something also that we will try out during our demonstration. However, there are a few limitations in the event visualizer application working with tracker data. The first thing is that it does not allow visualization in line listing, meaning you cannot visualize data by list of individual events. So for example, by names, age, type of health outcome laboratory research advice, a list you can't develop using the event visualizer. And also it doesn't allow data analysis from multiple program stages. So this we have to keep in mind when we are using event visualizer. But having said that for aggregation purposes, we are kind of introducing another concept that we will do tomorrow. So that concept is called program indicators. So using program indicators, we might be able to have I mean extend some functionality, like for example, if you want to connect data from a couple of stages and produce aggregate visualizations that you can do using program indicators. So I'm not actually going to discuss anything about program indicators today, because that will be discussed separately tomorrow. Right. So let us do the demo and analysis with event visualizer. Let me share my other screen. So right now I'm logged into the instance. Let me refresh so that I'm not locked out. Fine. Right. So where do we find the event visualizer application? So right now we are in the dashboard. So you go to apps, and you click on the apps icon here and you find this icon, the application named event visualizer. So we click and open the event visualizer. And once we do that, it will take a moment based on your internet connectivity and let me refresh just in case. All right. Let me close and open my browser again. Most probably it's due to my internet connection. Probably I'm located a bit far from the original server. All right. Finally it loads. Let me share my presentation again. Sorry, not the presentation, the browser. Right. Okay. So this is the event visualizer application. Right. So what do we see in this interface? So it's somewhat similar to the interface of many other analytic tools that you see in the DHIS2. So the major difference that you're seeing on this event visualizer app compared to the event report is the availability of the chart type. So you can see here, there are different types of visualizations, chart visualizations that you can perform using the event visualizer. Right, which are listed above. And then of course, onto your left, we have the various dimensions. So first one what we have here is the data dimension. And then we also have the period. Right. And then the organization unit. So these are the three core dimensions available. Whenever you are doing any basic analysis of analysis using DHIS2. But in addition, there are many other dimensions that you have created in your instance that may be available for you to use when you are analyzing. But as minimum, you should have the data period and organization unit and the chart type. Then we have another set of options onto your right top. So the first thing is the update button. So whenever you do some configuration here onto your left, you need to click on update to get the updated visualization. And then we have the favorite button here. So which has many different options right now only the open button is made available. But all others are grayed out because we are just starting from because we just opened the application. And then we have the layout button. We will come back to it a bit later. And of course we have the options tab here which includes many different customizations that we can perform on the visualization we design. And then we also have another button to download the visualization we produce here. So what I will try to do is just to open one visualization which is already saved. So to do that, I click on favorites, open, and then I will select the second one AstraZeneca first and second dose by location. So I click and open this and this is the visualization that we get. So what I did here is to open an already saved visualization somebody has configured before. Why I did so is to show how things are configured here so you can clearly see when you click on the data dimension. Now we have a program, a particular stage and selected data items from this stage already visualized here. And then for the period it shows that we have they have fixed the period and the organization unit is also set. So these steps are what we are going to perform now. So let me kind of start with the new visualizations. So what I'm going to do here is to click on favorite and new. Right. Now we have to define the parameters that we are going to configure to obtain the visualization we want. So first thing is to select the chart type. So I will keep it simple. So I will select the default column chart type. So it is already selected. And then in the data dimension, we have to select a program stage and the data items from that program stage. So I will select the program. So for an example, let me take the COVID-19 vaccination registry. And then the stage I will select the vaccination stage just like that, which is there here. And then I will select now we you can see so I mean whatever the data elements and the attributes which are available. Right. In this program and the program stage will be listed here. So it's a big list. So in case if you want to kind of make it shorter, we can either select data elements from here. So it will only display the data elements and not the program program attributes. So I will select the dose number. This one I can double click and then it comes here. Right. And then of course, the vaccination name. Right. So here we have the vaccine name. So I double click. And once I do that, out of all the data elements and attributes which are actually we have not be sure we are not selected attributes here. It's only the data elements out of all the data elements. The ones we select are the ones that you are seeing onto the box inside this box here. What we can actually do is now we know that dose number data element has an option set attached to it. Right. So due to that we can do something special here. We can kind of filter which options we need to visualize. So I'm going to select first dose and second dose. Right. So I'm kind of filtering the dose number so that only the data related to first and second dose will be visualized. Not the ones that are coming from the booster dose or the third dose. And then and then from the vaccine name, I'm going to select just one vaccine which is AstraZeneca. So now we are done with the data dimension. Next we have to configure the period. So the period I will keep it as this here. And then next is the organization unit. So what is selected is the user sub bulk unit. So I can either keep that or else I can select something else. So for the moment I will just keep it as user sub unit. Right. And what I can do is actually I can click on this update button here and see what will be the visualization going to look like. So let me click on update button. And this is what I'm seeing. So what's the problem here? Actually there is no problem right. As per the criteria we have defined we have got the visualization. It's just that what we had in our mind is not what we are seeing here because we might be interested to see a chart which has more columns not just one of them. But what has actually happened now is we look at the visualization here. We are actually seeing all the org units up here which has been filtered. And we are just seeing the total dose of AstraZeneca which has been given to the patients in the year 2022. So how are we going to get the visualization that we probably have in our mind? So what we can actually do is we can go to this layout tab and we can see how the layout has been configured. So ideally we can select what we don't want to come in this visualization to the report right so under the report filter. So what we will do is we actually don't want the period to be involved in the visualization. So I'm going to push the period to the filter because like it's only in the year 2022. The category dimension defines what will be the x-axis in this particular chart type right. So in that case I believe what I actually want to see is how I mean each user subunit like for example the second level in our org unit hierarchy how the second level is doing when it comes to dispersing each of the vaccines. So for that I need to have the organization units coming here as the category dimension. What does the series dimension implies? So basically what series dimension implies is it will be grouping whatever we are mentioning in the category dimension. So in the x-axis we are having categories. So we'll be probably as per the configuration we are doing here. We'll be seeing all the organization units and under each organization unit whatever we are mentioning here will be grouped. So I think what we can have the not the vaccine name because vaccine name we only have AstraZeneca but what we would like to see is the dose number. So when we do that ideally we should be seeing all the org units in the x-axis which will be grouped by the dose number right. So I think our visualization is okay for now and let me click on update and when I do that this is what I am getting right. I think something similar is what you wanted to visualize. So we have the column chart and if we just look at what we have in this column chart we have all the org units in the level 2 listed in this x-axis. And it has been grouped based on the doses. So you are seeing the first dose here and the second dose. The first and second dose are both visualized here into different colors. Okay. Right. So let us see what other further customizations we can do in this visualization. So one thing we can do is we can click on this button called options. And here we are seeing a lot of different configurations we can perform. So the first thing is show values. So when we click on I mean it has already been ticked. So when the show values is ticked you will be seeing the actual values in the chart itself. So this is fine. And another nice feature that comes very handy is to hide not applicable data. Sometimes like you may get some say for example it could be an org unit or it could be another dimension where you may have values which are not applicable. And it may not look so good to have them visualize in the chart. So when we click on this when we select this hide not applicable data they will be hidden from your visualization. So here what I can actually do is to sort this chart from low to high so that we will be getting the lowest values on to your left and the highest values we will be having on to the right. And then few other things we can do. We can actually give the axis some names. So for the range axis this is basically the y we can give the y axis the dose number and then the domain axis which is in this case the x axis we can give the name location. And then of course we can give the chart a title because right now we don't have a nice title. So we can mention astra, Seneca first and second doses by location first and second doses by location. So with these additional configurations we can click on update and we should be able to see the updated chart where we have the title chart title and the labels for the X and Y axis and then all our values arranged from lowest to the highest. We also have few other options available here. The first thing being we can of course save this chart. So if we open an existing chart we can save it as or else if it is a new chart we can actually save it. So when we are saving it is asking for a name and a description. So you can give a nice name and a description for this chart. In addition you also have this feature to download. So when we click on download there are many different options but commonly used ones include image and a PDF. So when you click here it will download the image file of this chart and you can also download the same chart as a PDF. Right. So now that we have demonstrated how to design a simple chart why don't you try the first exercise in the learner's guide. So we can give you 10 minutes to try it by your own. So only do the first exercise and the event visualizer in the learner's guide. So that first exercise is about practicing the same steps that I have followed in producing this output. So if there are any questions please ask them in the Slack call the chat and our team will be ready to answer. So see you in 10 minutes.