{"id":480,"date":"2024-04-11T15:08:49","date_gmt":"2024-04-11T15:08:49","guid":{"rendered":"https:\/\/agustincastro.es\/?p=480"},"modified":"2026-01-24T13:21:50","modified_gmt":"2026-01-24T13:21:50","slug":"poblacion-mundial-en-dashboard-de-power-bi","status":"publish","type":"post","link":"https:\/\/agustincastro.es\/index.php\/2024\/04\/11\/poblacion-mundial-en-dashboard-de-power-bi\/","title":{"rendered":"Poblaci\u00f3n mundial, en dashboard de power BI"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">En esta pr\u00e1ctica dejamos a un lado <strong>R<\/strong> y nos ponemos manos a la obra con <strong>power BI<\/strong> para crear un sencillo <strong>dashboard <\/strong>con el que explorar y mostrar informaci\u00f3n sobre la poblaci\u00f3n mundial categorizada por pa\u00edses. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">He utilizado los datos de la p\u00e1gina web <a href=\"https:\/\/www.worldometers.info\/\">Worldometers<\/a>, muy conocida porque nos tuvo bien informados sobre la evoluci\u00f3n de los casos de COVID durante los a\u00f1os de la pandemia. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">El dataset cuenta con datos estimados y actualizados para cada pa\u00eds o territorio dependiente hasta julio de 2024. No obstante, en este ejemplo he utilizado la <strong>poblaci\u00f3n del pa\u00eds<\/strong> (population), la <strong>densidad de poblaci\u00f3n<\/strong> (density) y la <strong>migraci\u00f3n <\/strong>en t\u00e9rminos netos (migrants). <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"795\" data-src=\"https:\/\/agustincastro.es\/wp-content\/uploads\/2024\/04\/popu0-1024x795.png\" alt=\"\" class=\"wp-image-481 lazyload\" data-srcset=\"https:\/\/agustincastro.es\/wp-content\/uploads\/2024\/04\/popu0-1024x795.png 1024w, https:\/\/agustincastro.es\/wp-content\/uploads\/2024\/04\/popu0-300x233.png 300w, https:\/\/agustincastro.es\/wp-content\/uploads\/2024\/04\/popu0-768x596.png 768w, https:\/\/agustincastro.es\/wp-content\/uploads\/2024\/04\/popu0.png 1119w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/795;\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Para la visualizaci\u00f3n de la informaci\u00f3n he optado por (1) utilizar una tabla resumen con las tres variables de inter\u00e9s para este caso, (2) dos gr\u00e1ficos de barras apiladas para resaltar f\u00e1cilmente los pa\u00edses m\u00e1s poblados y, aquellos con mayor tasa neta de migrantes y, (3) un mapa en el que, adem\u00e1s de localizar al pa\u00eds cuando se aplica el filtro, indica la densidad de poblaci\u00f3n en la leyenda y, una burbuja de tama\u00f1o proporcional a esta.  <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"569\" data-src=\"https:\/\/agustincastro.es\/wp-content\/uploads\/2024\/04\/popu1-1024x569.png\" alt=\"\" class=\"wp-image-482 lazyload\" data-srcset=\"https:\/\/agustincastro.es\/wp-content\/uploads\/2024\/04\/popu1-1024x569.png 1024w, https:\/\/agustincastro.es\/wp-content\/uploads\/2024\/04\/popu1-300x167.png 300w, https:\/\/agustincastro.es\/wp-content\/uploads\/2024\/04\/popu1-768x427.png 768w, https:\/\/agustincastro.es\/wp-content\/uploads\/2024\/04\/popu1.png 1455w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/569;\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"575\" data-src=\"https:\/\/agustincastro.es\/wp-content\/uploads\/2024\/04\/popu2-1024x575.png\" alt=\"\" class=\"wp-image-483 lazyload\" data-srcset=\"https:\/\/agustincastro.es\/wp-content\/uploads\/2024\/04\/popu2-1024x575.png 1024w, https:\/\/agustincastro.es\/wp-content\/uploads\/2024\/04\/popu2-300x168.png 300w, https:\/\/agustincastro.es\/wp-content\/uploads\/2024\/04\/popu2-768x431.png 768w, https:\/\/agustincastro.es\/wp-content\/uploads\/2024\/04\/popu2-1280x720.png 1280w, https:\/\/agustincastro.es\/wp-content\/uploads\/2024\/04\/popu2.png 1445w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/575;\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>En esta pr\u00e1ctica dejamos a un lado R y nos ponemos manos a la obra con power BI para crear un sencillo dashboard con el que explorar y mostrar informaci\u00f3n sobre la poblaci\u00f3n mundial categorizada por pa\u00edses. He utilizado los datos de la p\u00e1gina web Worldometers, muy conocida porque nos tuvo bien informados sobre la [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":482,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,5],"tags":[],"class_list":["post-480","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-bi","category-tecnica-y-practica"],"_links":{"self":[{"href":"https:\/\/agustincastro.es\/index.php\/wp-json\/wp\/v2\/posts\/480","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/agustincastro.es\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/agustincastro.es\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/agustincastro.es\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/agustincastro.es\/index.php\/wp-json\/wp\/v2\/comments?post=480"}],"version-history":[{"count":1,"href":"https:\/\/agustincastro.es\/index.php\/wp-json\/wp\/v2\/posts\/480\/revisions"}],"predecessor-version":[{"id":484,"href":"https:\/\/agustincastro.es\/index.php\/wp-json\/wp\/v2\/posts\/480\/revisions\/484"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/agustincastro.es\/index.php\/wp-json\/wp\/v2\/media\/482"}],"wp:attachment":[{"href":"https:\/\/agustincastro.es\/index.php\/wp-json\/wp\/v2\/media?parent=480"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/agustincastro.es\/index.php\/wp-json\/wp\/v2\/categories?post=480"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/agustincastro.es\/index.php\/wp-json\/wp\/v2\/tags?post=480"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}