Algeria Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
Expand all | Collapse all

COVID-19 Coronavirus Outbreak

  • 1.  COVID-19 Coronavirus Outbreak

    Silver Contributor
    Posted Mar 13, 2020 07:30 PM
    Edited by Badrane Derbazi Mar 13, 2020 07:32 PM
      |   view attached
    I invite you to CRUD the attached pbi file to be similar to the one published (Data are live: please refresh) at:

    Worldometers remove preview
    Coronavirus Cases:
    Live statistics and coronavirus news tracking the number of confirmed cases, recovered patients, and death toll by country due to the COVID 19 coronavirus from Wuhan, China. Coronavirus counter with new cases, historical data, and info. Daily charts, graphs, news and updates
    View this on Worldometers >



    Enjoy

    ------------------------------
    Badder
    ------------------------------

    Attachment(s)

    pbix
    Corona.pbix   52 KB 1 version


  • 2.  RE: COVID-19 Coronavirus Outbreak

    Top Contributor
    Posted Mar 15, 2020 04:09 AM
    Thanks for sharing Badder

    ------------------------------
    Regards
    Mehdi HAMMADI
    CoGitar / 23389830
    mehdi.hammadi@cogitar.com
    ------------------------------



  • 3.  RE: COVID-19 Coronavirus Outbreak

    Silver Contributor
    Posted Mar 17, 2020 01:49 PM
    Edited by Badrane Derbazi Mar 17, 2020 02:10 PM
      |   view attached
    File updated:  Column and KPI of the Mortality added
    Ranking


    Algeria by Numbers


    ------------------------------
    Badder
    ------------------------------

    Attachment(s)

    pbix
    Corona.pbix   50 KB 1 version


  • 4.  RE: COVID-19 Coronavirus Outbreak

    Top Contributor
    Posted Mar 17, 2020 03:10 PM
    Thank you for sharing Badder.
    The big problem (for  algeria) is the accuracy of the data. Some sources are relating 8 recoveries, your report says 10 and other sources 12. The % of deaths is not very good indicator or maybe you have to add the % of recoveries


    ------------------------------
    Regards
    Mehdi HAMMADI
    CoGitar / 23389830
    mehdi.hammadi@cogitar.com
    ------------------------------



  • 5.  RE: COVID-19 Coronavirus Outbreak

    Silver Contributor
    Posted Mar 18, 2020 06:14 PM
    Edited by Badrane Derbazi Mar 18, 2020 07:03 PM
      |   view attached
    Hello Mehdi,

    As I said above the pbix file depends to worldometers. Which means, Analysis is based on data provided by health authorities (Data accuracy is fine), this might be higher depending on how reliable our government is.
    2) John Hopkins University
    3) WHO: Wolrd Health Organization

    The overall conclusion is that there’s a constant progression with a worrying rate of mortality.

    Note: New pbix uploaded

    ------------------------------
    Badder
    ------------------------------

    Attachment(s)

    pbix
    Corona.pbix   66 KB 1 version


  • 6.  RE: COVID-19 Coronavirus Outbreak

    Top Contributor
    Posted Mar 27, 2020 05:58 AM
    Thank you Badrane,
    Did you noticed that the total recoveries number changed from 32 to 24 than 29 these last days. What data can we Believe.
    Personally I follow the data provided by the Algerien Health Ministry. The officiel announcement is made every day at 5PM and there dashboard is updated the next day between 9am and 2pm (http://covid19.sante.gov.dz/carte/)
    Stay Safe, Stay Home

    ------------------------------
    Regards
    Mehdi HAMMADI
    CoGitar / 23389830
    mehdi.hammadi@cogitar.com
    ------------------------------



  • 7.  RE: COVID-19 Coronavirus Outbreak

    Silver Contributor
    Posted Mar 27, 2020 06:23 AM
      |   view attached
    Hello,

    Yes the data are refreshed every time there are updates.


    My last version in Arabic this time.

    ------------------------------
    Badder
    ------------------------------

    Attachment(s)

    pbix
    Corona.pbix   75 KB 1 version


  • 8.  RE: COVID-19 Coronavirus Outbreak

    Silver Contributor
    Posted Mar 30, 2020 09:26 AM
    Edited by Badrane Derbazi Mar 30, 2020 09:35 AM
    Hello
    Data from the Algerian government are not accurate. we have 511 cases (active 449) announced to WHO. However, summarize the active cases by Wilaya will give you 417?

    Last version
    - Language changed to Arabic
    - More Charts
    - Detailed Algeria's map added with Latitude and Longitude of Locations

    Issues:
    - Data are not accurate, my source is (http://covid19[dot]sante[dot]gov[dot]dz/carte/)


    Principal Interface


  • 9.  RE: COVID-19 Coronavirus Outbreak

    Bronze Contributor
    Posted Mar 31, 2020 07:29 AM
    Hi, thank you for sharing.

    Yes, unfortunately, the data of the Algerian ministry of health are not updated daily and are not accurate. Also if you sum the cases by wilaya you will not get the correct total. I think that the person who is in charge of the "official" dashboard is taking the data from the Ministry press release.

    I hope they will one day think that the data is important.

    ------------------------------
    Hoss Satour
    Data analyst
    Algiers - DZ
    numidiabi.wordpress.com
    ------------------------------



  • 10.  RE: COVID-19 Coronavirus Outbreak

    Silver Contributor
    Posted Apr 03, 2020 02:13 PM
    Edited by Badrane Derbazi Apr 03, 2020 02:39 PM

    Last version:

    - Colorization changed
    - Some data has been acquired from http://covid19.sante.gov[dot]dz/carte/

    Source (Excel and pbix) uploaded feel free to apply your imagination (Color, Charts....)



    Note: copy the joined files into C:\temp to avoid changing the source file otherwise (File >> Options ans Settings >> Data source settings >> and click on Change Source...)

    ------------------------------
    Badder
    ------------------------------

    Attachment(s)

    pbix
    Corona.pbix   236 KB 1 version
    xlsx
    wilayate.xlsx   25 KB 1 version


  • 11.  RE: COVID-19 Coronavirus Outbreak

    Silver Contributor
    Posted Apr 12, 2020 06:03 AM
    Edited by Badrane Derbazi Apr 13, 2020 05:02 AM

    Hello,

    Last update:

    - Tunisa's Map addedd
    - Date Last Refresh Added
    - More Charts Added
    - Conditional formatting Added








    ------------------------------
    Badder
    ------------------------------

    Attachment(s)

    pbix
    Corona.pbix   293 KB 1 version
    xlsx
    wilayate.xlsx   35 KB 1 version


  • 12.  RE: COVID-19 Coronavirus Outbreak

    Bronze Contributor
    Posted Apr 13, 2020 02:38 AM
    Bonjour
    Merci pour cette partage Badrane.
    Pouvez vous m'indiquer ou je peux trouver la liste des Wylaya avec position géographique.
    Merci

    ------------------------------
    Karim Mohsni
    Auditor
    ------------------------------



  • 13.  RE: COVID-19 Coronavirus Outbreak