 good afternoon to all those attending this session. Next we are going to present a work that we have been developing for some time on digital transformation in the health sector in Chile. My name is Juan Venegas and I am currently a professor at the San Sebastián University for Continuing Education and Postgraduate Programs, but I have also worked in the other public and private universities. Anastasia Revilledo is a last-year student industrial civil engineer and is currently working on his thesis on machine learning models for the forecast of medical supply at the Valdivia Bacero Hospital. Today we are going to show part of the process that has been working with public data in the health area, but specifically in the development of a dashboard that allows managing some of the most relevant matrix and that we believe can be a tool for process of digital transformation in health institutions. In this context we are going to talk broadly about the health system in Chile, digital transformation because the use of art and libraries such as China is also relevant for the development of this type of tool and then about the development process carried out for this type of tools. Together we dashboard as a task. Well, in Chile the health sector is quite diversified library due to Chile's geography, but also due to the types of providers. This implies that the public sector covers about 78 percent of the population and the private sector 60, 16 percent. However many times the public sector is not capable of responding to the demand of patients for various reasons which tends to create ties with the private sector. In this context the health sector is completely regulated for the means of or the stereo of the salud, but in turn there are other regulators such as the AMIS, Institutos de Seguridad Social and Superintendencia de Salud. However, we talk about, specifically about the Magallanes Hospital which cover about 85 percent of the population of this region. It should be noted that this hospital is located in the southernmost region of Chile. They form the management of information to respond to the demand of patients critical. Since any patient who could not be treated in this hospital must be redirected to another hospital of the high complexity which are located at the important distance. So currently in Chile and there are many industries that are implementing process and tools for digital transformation, partly because the COVID-19 pandemic allowed the entry of new tools, but also because specifically in the health sector is not necessary due to the various problems that exist such as the reduction of the waiting list, lag or bed programming or the purchase of supply, low transparency of information or relevant or relevant matrix for the patient. This house allowed the actor of the system to seek solutions to improve this process which is not easy task due to the complexity of the system both in its increased structure and the needs of the patient. Along with about in many public hospitals, most administrative staff are professional such as doctors, midwives among others. Therefore, the needs tools that help them visualize, understand and better manage patient information, waiting times, resource and finances. So regarding our and the shiny framework, we generally use it for its versatility for app development in addition to being an open source software. But this framework has also been positioned as a development language by many companies such as Apsilon, Analythium, Solution, Aerospace in Chile among others. So next Anastasia, we will show you how much of the development has been. So now I'm going to talk about the approach you should take when designing your solution, which is design thinking. I think most of you have already at least heard of the design thinking concept and it's because it's the best way of understanding the user needs and creating innovative solutions. And by following the steps of design thinking, we can develop user centered and effective app for visualizing data. The first step is the exercise where we begin by truly understanding the needs and goals of our users. Then in the defined stage, we move on to defining the specific problem we aim to solve defining the problem helps us stay focused and ensures we address the most critical issues. And then in the eighth stage, this is where we let our creativity flow. We generate a wide range of ideas for apps design and functionality. And we encourage brainstorming sessions to explore practical and innovative approaches. The goal is to consider various possibilities that align with the needs of our users. Then prototyping allows us to visualize and test different design concepts. And by creating tangible representations of our ideas, we can gather early feedback from users and iterate on our design before investing significant development resources. And the testing stage is crucial to ensure our app meets the needs of our users. We conduct this usability test with our prototypes, observing how users interact with the app and identifying areas that need improvement. And by cooperating user feedback, we can iterate and refine our design and ensure user-friendly and intuitive experience while solving our defined problem. After iterating the needed amount of times, we move on to the development and implementation of our solution. Let's shift our focus to the importance of using the right visualization for our data. Here we have the minor map and it serves as a prime example of how complex information can be effectively communicated through our design and visually engaging representation. This graph presents the Napoleon's campaign to Moscow. Here we can see the geographic path taken and the width of the line shows the size of the army and the brown line represents the movement towards Russia and the black line corresponds to the surviving army during the retreat. Down below, we can see the climatic conditions in certain points of time. And this visualization is renowned for its ability to convey the immense scale of the campaign, the devastating impact of the harsh winter and the tragic loss of life suffered by the French army. Moving on to another example that is more related to healthcare, we can see the rose diagram created by Florence Nightingale. It illustrates the causes of mortality in the military hospital during the Crimean War. Its circle is divided in 12 sectors which represent each month and the different colors represent different causes for death. And the era is proportional to the amounts of death attributed to that cause. So these graphs challenge the prevailing beliefs and practices of the time which attributed death primarily to wounds and battle injuries. Through her graph, she emphasized the importance of preventive measures and the need for systematic improvements in healthcare infrastructure and hygiene. So now here we have some samples of more common used graphs and I just wanted to emphasize that using the right visualization techniques is essential for effectively communicating insights and facilitating data-driven decision-making and by choosing appropriate visualizations, we can enhance understanding, engage users, and avoid misinterpretation and bias. So now I'm going to show you the actual app with Develops. Here we have the main menu where we can see the different menus we created with a small description for each one. You can also click here for example and go straight to that menu, but I'm going to start from the top. Here we have the operating room report in which you can see the use of operating rooms. In blue we can see the percentage of hours of work compared to the enabled hours, and in green we can see the percentage of scheduled hours compared to the enabled hours. And also here you can see that the difference between the two bars represents the amount of suspensions. Here in the stats that are to the right we can identify problems. For example here we can identify that there are problems with the amount of hours that are getting scheduled, and also there are problems with the amount of suspensions of the operations. Then we have the suspension analysis first by cost. In this graph we can see for each month the percentage of suspensions attributed to each cost. Here we can see that in general the patients and the surgical equipment causes are the most common and something that is also stayed here. Then we have the breakdown of reasons for suspensions surgery of surgeries in the San Quixote where we can see the specific reasons for suspensions and to which category each one belongs. Then we have these two Pareto charts of COSAS that shows one for patients from 15 years and over and the other one for all ages. We can see that both are pretty much the same. And as I said before, patients and surgical equipment are the most common reasons for suspensions. And here we have another Pareto chart, but for the specific reasons of suspension is so here we can see the surgical table extension, acute pathology, the patients does not shut up and COVID-19 health emergency are the main reasons why the operations are getting suspended. Then we have the suspension by specialty and also by type of surgery. In this first by chart we can see that major surgeries are the ones that are getting the higher amount of suspensions. And here we can see that a general surgery and also traumatology are the specialties that get the most suspended. And then we have here the number of suspensions by specialty and also by type of surgery. So here we, for example, for general surgery, we can see that there were 181 suspended operations in major surgery the last year. Then this menu is pretty similar to the operating room report. Here we can see the number of scheduled quotas and the number of quotas used, but in this case we can see that there are more quotas used than the number of the scheduled ones. That is something that we can see here too. And lastly we have the days of resurgical stay menu. In blue we can see the total days of resurgical stay. In green the number of patients operated and in blue we can see the days of stay per patients. So here to the right we can see the general stats for the whole year and the graph shows them divided by month. And also you can choose here which specialty you want to see the data of. And also you can choose all of them. And lastly we have this graph that is pretty similar to the other one, but in this case they are separated by surgeries, sorry, by specialty. So here you can compare the different specialties for the month you choose and also for the whole year. And thank you. Thank you so much for listening and we're happy to answer any questions you have. So I'll start out by saying that is beautiful work. The artistry, the aesthetics are beautiful, the design is lovely. So thank you. It's incredibly impressive. I'm curious to know are you thinking about developing dashboards that are public facing and internal facing? So are you trying to share hospital information again to the world or is your audience people who work within the hospital? Well, actually this development is an idea for a startup. So the data, the tools, is our for this. We have been using public information in order to prototype, but this is the idea is to actually use them for directly working with hospitals and so on. How concerned? I don't know. I've never been to Chile. How concerned are you about needing to do English, Spanish, Portuguese? Are you concerned about trying to do shiny multi-lingual? What do you mean? That's sorry. Yeah. In fact, this dashboard is multi-lingual. In Spanish or English? For this moment, is it up in English? For the old dashboard, is it in Spanish? Cool. It's very impressive. I've tried to do shiny in Spanish and English. It's a lot of work. So I'm very, very impressed. I'm looking for questions. You have a lot of positive feedback. There's a question about, can you export reports? So can you produce PDFs or can you go off of the web? For the moment, the dashboard is not available for report or markdown or quarto documents. Okay. I think that's it. I don't see any other questions. So again, I'll just say, this is beautiful work. Please continue. Thank you for joining us. I'm very, very impressed. This is incredibly hard work. And thank you for sharing. You'll see it in the chat. Thank you. Thank you for presenting.