{"id":20194,"date":"2020-04-08T15:19:05","date_gmt":"2020-04-08T14:19:05","guid":{"rendered":"https:\/\/next-step.es\/?p=20194"},"modified":"2021-03-16T08:37:02","modified_gmt":"2021-03-16T08:37:02","slug":"power-report-bi-coronavirus-in-spain-and-worldwide","status":"publish","type":"post","link":"https:\/\/next-step.es\/en\/informe-power-bi-coronavirus-en-espana-y-en-el-mundo\/","title":{"rendered":"Power BI : Coronavirus Analysis in Spain and the World"},"content":{"rendered":"<div id=\"attachment_20214\" style=\"width: 1034px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-20214\" class=\"size-large wp-image-20214\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-Completo-COVID19-PowerBI-1024x578.jpg\" alt=\"Next-Step COVID19 PowerBI Report\" width=\"1024\" height=\"578\" srcset=\"https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-Completo-COVID19-PowerBI-1024x578.jpg 1024w, https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-Completo-COVID19-PowerBI-980x553.jpg 980w, https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-Completo-COVID19-PowerBI-480x271.jpg 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><p id=\"caption-attachment-20214\" class=\"wp-caption-text\"><em>Next-Step Report COVID19 - Author: Ernesto Garc\u00eda de Paso Sanz<\/em><\/p><\/div>\n<p>Given the general public concern about the Coronavirus crisis and the paucity of reliable, comprehensive reports from official sources of information, <strong>we have developed a detailed report in Power BI, on the data and the evolution of the COVID 19 virus in Spain and in the world.<\/strong>. This report is automatically updated daily with official data from the Spanish Ministry of Health. You can see the full report by clicking on this link:<\/p>\n<p><strong> <a href=\"https:\/\/app.powerbi.com\/view?r=eyJrIjoiMzQ4ZTNiYTktMTRiMi00MDI1LTkxMTAtZmE4MjE0MDgzYzc2IiwidCI6ImY4MDkzZjY5LWJhOWEtNDkyZS05YjdjLWIwZDdlNjVjOTliOSIsImMiOjh9&amp;pageName=ReportSection\">Coronavirus Analysis in Spain and the World<\/a> <\/strong><\/p>\n<p>In the first two pages of the report, an exhaustive review is made of the <strong>Coronavirus testing in Spain<\/strong>. On the first page, as shown in the image above, we can see the following graphs and statistics:<\/p>\n<ul>\n<li>Total cases registered to date<\/li>\n<li>New cases reported and change from previous day<\/li>\n<li>New cases hospitalised and change from previous day<\/li>\n<li>New admissions to the ICU Intensive Care Unit and variation from the previous day<\/li>\n<li>Persons killed and change from previous day<\/li>\n<li>New hospital discharges and change from the previous day<\/li>\n<li>Percentage of patients recovered, compared to registered cases<\/li>\n<\/ul>\n<p>Below, we can see a map with the<strong> percentages of registered cases by Autonomous Community in Spain<\/strong>.<\/p>\n<p>In the following graphic, on the right, a <strong>analysis of the evolution of registered cases: Total, deaths and hospital discharges<\/strong>.<\/p>\n<p>Then, a bar chart is used to make a <strong>comparison of the cases registered in Spain by Autonomous Community<\/strong>.<\/p>\n<p>Finally, we can see a comparative graph of:<\/p>\n<ul>\n<li>Registered cases, hospital admissions, deaths and discharges, by day.<\/li>\n<\/ul>\n<h2>COVID-19 by Autonomous Communities: Coronavirus Analysis in Madrid<\/h2>\n<p>The interesting thing is that if we click on the map or the graph of the autonomous communities, on a specific community, for example Madrid, the entire scorecard is updated with the data for that autonomous community:<\/p>\n<p><strong>Coronavirus analysis in the Community of Madrid<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20254\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-COVID19-PowerBI.png\" alt=\"Power BI: COVID 19 Report in Madrid\" width=\"659\" height=\"372\" srcset=\"https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-COVID19-PowerBI.png 659w, https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-COVID19-PowerBI-480x271.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 659px, 100vw\" \/><\/p>\n<p>And at the bottom right, in the graph of the evolution of cases, deaths, admissions and daily discharges, if we move the bar we can choose a day, and see the whole report updated with the data of that particular day.<\/p>\n<h2>Power BI: COVID 19 Spain - Continued<\/h2>\n<div id=\"attachment_20224\" style=\"width: 1034px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-20224\" class=\"size-large wp-image-20224\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-Completo-COVID19-PowerBI-2-1024x576.jpg\" alt=\"Next-Step Report COVID19 - Power BI\" width=\"1024\" height=\"576\" srcset=\"https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-Completo-COVID19-PowerBI-2-1024x576.jpg 1024w, https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-Completo-COVID19-PowerBI-2-980x551.jpg 980w, https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-Completo-COVID19-PowerBI-2-480x270.jpg 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><p id=\"caption-attachment-20224\" class=\"wp-caption-text\">Next-Step Report COVID19 - Author: Ernesto Garc\u00eda de Paso Sanz<\/p><\/div>\n<p>On the next page of the report, we continue with the national data, but we take a closer look at some relevant aspects, such as:<\/p>\n<ul>\n<li>Number of public, private and total available ICU beds.<\/li>\n<li>The masks distributed by each autonomous community.<\/li>\n<li>Confirmed cases, hospitalised, admitted to ICU and deaths, by age range.<\/li>\n<li>Confirmed cases, hospitalised, admitted to ICU and deaths, by sex.<\/li>\n<\/ul>\n<h2><strong>Power BI: COVID 19 Report: Global Analysis<\/strong><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-20234\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-Completo-COVID19-PowerBI-3-1024x574.jpg\" alt=\"Next-Step Report COVID19 in the World\" width=\"1024\" height=\"574\" srcset=\"https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-Completo-COVID19-PowerBI-3-1024x574.jpg 1024w, https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-Completo-COVID19-PowerBI-3-980x549.jpg 980w, https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-Completo-COVID19-PowerBI-3-480x269.jpg 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/p>\n<p>On the third page of the report, we can see the data at the global level and the breakdown by country.<\/p>\n<h2><strong>Power BI: COVID Report 19 - Coronavirus developments in the 10 most affected countries<\/strong><\/h2>\n<div id=\"attachment_20244\" style=\"width: 1034px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-20244\" class=\"size-large wp-image-20244\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-COVID19-PowerBI-4-1024x575.jpg\" alt=\"Power BI: COVID Report 19 - Evolution of Coronavirus in the 10 most affected countries\" width=\"1024\" height=\"575\" srcset=\"https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-COVID19-PowerBI-4-1024x575.jpg 1024w, https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-COVID19-PowerBI-4-980x550.jpg 980w, https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-COVID19-PowerBI-4-480x269.jpg 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><p id=\"caption-attachment-20244\" class=\"wp-caption-text\">Power BI: COVID 19 Report - Author: Ernesto Garc\u00eda de Paso Sanz<\/p><\/div>\n<p>Finally, on page four of the report, we can see a <strong>animated graphic with the evolution of COVID19 in the World<\/strong>The data from the first years of the disease, from the onset of the disease to the present date, through the data from the <strong>10 countries with the most reported cases of Coronavirus<\/strong>to date.<\/p>\n<p>We hope that this information will help all those who need reliable and up-to-date data on this serious international health crisis and that together we can overcome it soon.<\/p>","protected":false},"excerpt":{"rendered":"<p>Ante la preocupaci\u00f3n general de la poblaci\u00f3n sobre la crisis del Coronavirus y la escasez de informes completos fiables, procedentes de fuentes de informaci\u00f3n oficiales, hemos desarrollado un informe detallado en Power BI, sobre los datos y la evoluci\u00f3n del virus COVID 19 en Espa\u00f1a y en el Mundo. Este informe, se actualiza autom\u00e1ticamente a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":20214,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"off","_et_pb_old_content":"[caption id=\"attachment_20214\" align=\"alignnone\" width=\"1024\"]<img class=\"size-large wp-image-20214\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-Completo-COVID19-PowerBI-1024x578.jpg\" alt=\"Next-Step Informe COVID19 PowerBI\" width=\"1024\" height=\"578\"> <em>Next-Step Informe COVID19 - Autor: Ernesto Garc\u00eda de Paso Sanz<\/em>[\/caption]\n\nAnte la preocupaci\u00f3n general de la poblaci\u00f3n sobre la crisis del Coronavirus y la escasez de informes completos fiables, procedentes de fuentes de informaci\u00f3n oficiales, <strong>hemos desarrollado un informe detallado en Power BI, sobre los datos y la evoluci\u00f3n del virus COVID 19 en Espa\u00f1a y en el Mundo<\/strong>. Este informe, se actualiza autom\u00e1ticamente a diario con los datos oficiales de <a href=\"http:\/\/www.datadista.com\">www.datadista.com<\/a> Puedes ver el informe completo pinchando en este enlace:\n\n\n<strong> <a href=\"http:\/\/bit.ly\/2ykgf5Y\">An\u00e1lisis Coronavirus en Espa\u00f1a y en el Mundo<\/a> <\/strong>\n\n\nEn las dos primeras p\u00e1ginas del informe, se realiza un exhaustivo <strong>an\u00e1lisis del Coronavirus en Espa\u00f1a<\/strong>. En la primera p\u00e1gina, como muestra la anterior imagen, podemos ver los siguientes gr\u00e1ficos y estad\u00edsticas:\n<ul>\n \t<li>Total de casos registrados hasta la fecha<\/li>\n \t<li>Nuevos casos registrados y variaci\u00f3n con respecto al d\u00eda anterior<\/li>\n \t<li>Nuevos casos hospitalizados y variaci\u00f3n con respecto al d\u00eda anterior<\/li>\n \t<li>Nuevos ingresos en la UCI Unidad de Cuidados Intensivos y variaci\u00f3n con respecto al d\u00eda anterior<\/li>\n \t<li>Personas fallecidas y variaci\u00f3n con respecto al d\u00eda anterior<\/li>\n \t<li>Nuevas altas hospitalarias y variaci\u00f3n con respecto al d\u00eda anterior<\/li>\n \t<li>Porcentaje de pacientes recuperados, frente a casos registrados<\/li>\n<\/ul>\nA continuaci\u00f3n, podemos ver un mapa con los<strong> porcentajes de casos registrados por comunidades aut\u00f3nomas en Espa\u00f1a<\/strong>.\n\n\nEn el siguiente gr\u00e1fico, a la derecha, se realiza un <strong>an\u00e1lisis de la evoluci\u00f3n de los casos registrados: Total, fallecidos y altas hospitalarias<\/strong>.\n\nA continuaci\u00f3n, en un gr\u00e1fico de barras se realiza una <strong>comparativa de los casos registrados en Espa\u00f1a por cada Comunidad Aut\u00f3noma<\/strong>.\n\n\nPor \u00faltimo, podemos ver un gr\u00e1fico comparativo de:\n<ul>\n \t<li>Casos registrados, ingresos hospitalarios, fallecidos y altas, por d\u00eda.<\/li>\n<\/ul>\n<h2>COVID-19 por Comunidades Aut\u00f3nomas: An\u00e1lisis Coronavirus en Madrid<\/h2>\nLo interesante es que si hacemos clic en el mapa o el gr\u00e1fico de las comunidades aut\u00f3nomas, sobre una comunidad en concreto, por ejemplo Madrid, todo el cuadro de mando se actualiza con los datos de esa comunidad aut\u00f3noma:\n\n\n\n<strong>An\u00e1lisis Coronavirus en la Comunidad de Madrid<\/strong>\n\n[caption id=\"attachment_20254\" align=\"aligncenter\" width=\"1024\"]<img class=\"size-full wp-image-20254\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-COVID19-PowerBI.png\" alt=\"Power BI: Informe COVID 19 en Madrid\" width=\"659\" height=\"372\">[\/caption]\n\nY abajo a la derecha, en el gr\u00e1fico de la evoluci\u00f3n de casos, fallecidos, ingresos y altas diarias, si movemos la barra podemos elegir un d\u00eda,  y ver actualizado todo el informe con los datos de ese d\u00eda en concreto.\n<h2> Power BI: COVID 19 Espa\u00f1a - Continuaci\u00f3n<\/h2>\n[caption id=\"attachment_20224\" align=\"aligncenter\" width=\"1024\"]<img class=\"size-large wp-image-20224\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-Completo-COVID19-PowerBI-2-1024x576.jpg\" alt=\"Next-Step Informe COVID19 - Power BI\" width=\"1024\" height=\"576\"> Next-Step Informe COVID19 - Autor: Ernesto Garc\u00eda de Paso Sanz[\/caption]\n\nEn la siguiente p\u00e1gina del informe, seguimos con los datos nacionales, pero profundizando en algunos aspectos relevantes, como:\n<ul>\n \t<li>N\u00famero de camas UCI p\u00fablicas, privadas y total de camas disponibles.<\/li>\n \t<li>Las mascarillas repartidas por cada comunidad aut\u00f3noma.<\/li>\n \t<li>Lo casos confirmados, hospitalizados, ingresados en UCI y fallecidos, por rango de edad.<\/li>\n \t<li>Los casos confirmados, hospitalizados, ingresados en UCI y fallecidos, por sexo.<\/li>\n<\/ul>\n<strong><\/strong>\n<h2><strong>Power BI: Informe COVID 19: An\u00e1lisis Mundial<\/strong><\/h2>\n[caption id=\"attachment_20244\" align=\"aligncenter\" width=\"1024\"]<img class=\"size-large wp-image-20234\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-Completo-COVID19-PowerBI-3-1024x574.jpg\" alt=\"Next-Step Informe COVID19 en el Mundo\" width=\"1024\" height=\"574\"> [\/caption]\n\nEn la tercera p\u00e1gina del informe, podemos ver los datos a nivel Mundial y el desglose por cada uno de los pa\u00edses.\n\n\n<strong><\/strong>\n<h2><strong>Power BI: Informe COVID 19 - Evoluci\u00f3n del Coronavirus en los 10 pa\u00edses m\u00e1s afectados<\/strong><\/h2>\n[caption id=\"attachment_20244\" align=\"aligncenter\" width=\"1024\"]<img class=\"size-large wp-image-20244\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2020\/04\/Next-Step-Informe-COVID19-PowerBI-4-1024x575.jpg\" alt=\"Power BI: Informe COVID 19 - Evoluci\u00f3n del Coronavirus en los 10 pa\u00edses m\u00e1s afectados\" width=\"1024\" height=\"575\"> Power BI: Informe COVID 19 - Autor: Ernesto Garc\u00eda de Paso Sanz[\/caption]\n\nPor \u00faltimo, en la p\u00e1gina cuatro del informe, podemos ver un <strong>gr\u00e1fico animado con la evoluci\u00f3n del COVID19 en el Mundo<\/strong>, desde que se inici\u00f3 esta enfermedad, hasta la fecha actual, a trav\u00e9s de los datos de los <strong>10 pa\u00edses con m\u00e1s casos registrados de Coronavirus<\/strong>, hasta la fecha.\n\n\nEsperamos que esta informaci\u00f3n ayude a todos los que necesiten tener datos fiables y actualizados sobre esta grave crisis sanitaria internacional y que entre todos consigamos superarla pronto.","_et_gb_content_width":"","footnotes":""},"categories":[17,28],"tags":[51,52,53,54,55,114,117],"class_list":["post-20194","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-bi-es","category-sin-categoria-es","tag-coronavirus-en-el-mundo","tag-coronavirus-en-espana","tag-coronavirus-espana","tag-covid-19-en-el-mundo","tag-covid-19-en-espana","tag-paises-mas-afectados-coronavirus","tag-power-bi-es"],"_links":{"self":[{"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/posts\/20194","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/comments?post=20194"}],"version-history":[{"count":2,"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/posts\/20194\/revisions"}],"predecessor-version":[{"id":23203,"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/posts\/20194\/revisions\/23203"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/media\/20214"}],"wp:attachment":[{"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/media?parent=20194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/categories?post=20194"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/tags?post=20194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}