{"id":1337,"date":"2020-03-30T18:40:10","date_gmt":"2020-03-30T16:40:10","guid":{"rendered":"https:\/\/data4success.de\/?p=1111"},"modified":"2023-10-17T10:27:53","modified_gmt":"2023-10-17T09:27:53","slug":"corona-infections-in-powerbi-evaluate","status":"publish","type":"post","link":"https:\/\/data4success.de\/en\/corona-infections-in-powerbi-evaluate\/","title":{"rendered":"Evaluate Corona infections in PowerBI"},"content":{"rendered":"<p>Here is an example of how the current Corona figures can be evaluated in Power BI. The numbers update daily based on the data published on corona.rki.de. The evaluation has 4 different pages at different aggregation levels. By clicking on the bars you can filter everything else on each page.<\/p>\r\n\r\n\r\n\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<p><iframe src=\"https:\/\/app.powerbi.com\/view?r=eyJrIjoiMmY3ODAwOTktMjcwNS00ZWE5LWJmMjAtMzFiOGQ1MDYyMTIzIiwidCI6IjIyMTdmNzdhLWQ4NTMtNDU0ZC1hZWE0LWI1YzE2YTJmOWJhZCIsImMiOjl9&amp;PageName=Deutschland\" width=\"933\" height=\"700\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\r\n\r\n\r\n\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<p>You can download the corresponding PowerBI file free of charge from <a href=\"https:\/\/data4success.de\/wp-content\/uploads\/2020\/05\/data4success_Corona_in_PowerBI_v2.zip\">here<\/a> download. If the download does not work, I can send it to you by e-mail. Everybody is allowed to use, modify and publish the file as he likes, under the condition that the source information of the underlying data is mentioned there, and furthermore a link to <a href=\"https:\/\/data4success.de\/en\">www.data4success.de<\/a> persists.<\/p>\r\n\r\n\r\n\r\n<p>You work in a manufacturing company and need support in Power BI, ideally in combination with Microsoft Dynamics NAV\/BC? I can save you a lot of money through automated data analysis. Feel free to contact me anytime about this, I give trainings, consult your business intelligence, reporting and controlling teams, and also build reports with Microsoft technologies for many companies.<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\">Data source<\/h2>\r\n\r\n\r\n\r\n<p>The data is collected daily from <a href=\"https:\/\/corona.rki.de\">corona.rki.com<\/a> read out.<\/p>\r\n\r\n\r\n\r\n<p>A detailed description of the underlying data can be found here: <a href=\"https:\/\/www.arcgis.com\/home\/item.html?id=dd4580c810204019a7b8eb3e0b329dd6\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.arcgis.com\/home\/item.html?id=dd4580c810204019a7b8eb3e0b329dd6<\/a><\/p>\r\n\r\n\r\n\r\n<p>The thanks goes to <a href=\"https:\/\/www.esri.de\/de-de\/home\" target=\"_blank\" rel=\"noreferrer noopener\">esri<\/a>, Germany's leading service provider of geodata analysis software, which in cooperation with the <a href=\"https:\/\/www.rki.de\/DE\/Home\/homepage_node.html\" target=\"_blank\" rel=\"noreferrer noopener\">Robert Koch Institute<\/a> provides the daily updated data of the data set \"RKI_COVID19\" used here.<\/p>","protected":false},"excerpt":{"rendered":"<p>Hier ein Beispiel davon, wie sich die aktuellen Corona-Zahlen in Power BI auswerten lassen. Die Zahlen aktualisieren sich t\u00e4glich anhand der auf corona.rki.de ver\u00f6ffentlichten Daten. Die Auswertung hat 4 verschiedene Seiten auf verschiedenen Aggregationsebenen. Mit Klick auf die Balken k\u00f6nnen Sie jeweils alles andere auf der jeweiligen Seite filtern. &nbsp; &nbsp; Die dazugeh\u00f6rige PowerBI-Datei k\u00f6nnen [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":1412,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[16,17,18,19],"class_list":["post-1337","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-allgemein","tag-corona","tag-covid-19","tag-power-bi","tag-powerbi"],"_links":{"self":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/1337","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/comments?post=1337"}],"version-history":[{"count":1,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/1337\/revisions"}],"predecessor-version":[{"id":2465,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/1337\/revisions\/2465"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/media\/1412"}],"wp:attachment":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/media?parent=1337"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/categories?post=1337"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/tags?post=1337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}