CoronaVirus Report – Using Python and Power BI to Analyse COVID19 Data

Learn how to use Python and Power BI in order to create a CoronaVirus Report with summary statistics, trends and forecasts. We provide all the data, scripts and resources in order to replicate this yourself. This report is also published in the web for people who only want to use it for analytics. Hope you enjoy this video!

Support the channel on Patreon:

Data Analytics Course Link:

Overview:
• From where to get the CoronaVirus data
• Writing a Python script to clean and Transform the data
• Building a Power BI dashboard for CoronaVirus
o CoronaVirus Summary Statistics
o CoronaVirus Trends
o CoronaVirus Forecasts
o CoronaVirus breakdown analytics
• How to publish your CoronaVirus report online

CoronaVirus COVID-19 Raw Data:

FREE TUTORIALS:
How to download and install Python through Anaconda:

Numpy Tutorial:

Pandas Tutorial:

Joins / Merges Tutorial:

MatPlotLib Tutorial:

Seaborn Tutorial:

Machine Learning – Linear Regression Tutorial:

Machine Learning – Logistic Regression Tutorial:

Power BI Tutorial:

Yiannis Pitsillides on Social Media:

[YiannisPi]

What do you think about the dashboard? Please let me know your feedback below!

[adshakin]

Hi Yiannis,
This is really good, please we need more, Just to ask, why using Python, is Power BI not able to do all these pivoting, join, etc, and analysis before real dashboarding?. I think Power BI can as well.

[andreasp.]

Excellent- very useful and informative these days. Keep it up Yiannis!

[bhavneetkaur]

Hi really appreciate your efforts its an amazing have a doubt when I am loading the data it is showing null values in latitude and longitude too what should I do, how to remove null from that .

[christopherdaly]

This is really good. I don't know if its something i've done, but if you look at the uk. The death rate is 3.59%, and the recovery rate is 0.22%. That doesn't look right. This is data from the 1st December.

[mehdihasanov]

Should say thanks alot for above provided explanation, excellent work.

1. my latest data shows only 30th April sadly, tho file is filled with the latest data of 18th Aug.

2. instead of downloading 3 files (Confirmed, Deaths and Recovered cases), how to make it auto-downloadable with Python?
or even better how to make it auto with Power BI itself, but then I won't have sorted data which you did in Python, as I understand correctly.

Looking forward to hear from you.

[abrhamyifter]

This was great to learn from. Thank You. I just have to ask how do you update the data after publishing it to the web.

[ghosthanded]

There are many null values in lat and longtitude columns how to treat those

[Eramitpatra]

Very nice and informative video Yiannis ! Can't we do the pivoting at Power BI eliminating Python codes?

[williamrupert]

Thank you for the tutorial. it has solve most of my problems. pls how can i contact you to help me out on some issues

[alimukhtar]

I love your content, its really amazing. I just need to know something. I will appreciate if you answer.

1) Can we apply machine learning model in analysis like regression, if yes then in which particular scenario we are apply that model ?
2) Which model is best for prediction corona virus in coming months ? Like in statistics there is a concept of bay's theorem to predict something in future.

Do you have any tutorials on corona virus predictions ?

[biswarooppattnaik]

Hi, i'am getting some null values (lat, long, confirmed, death, recovered) columns after full join.

[Kodegems]

I did not find the Raw data file. I have got other files but Raw one is not included.

[colabpython]

i love it thank u please upload next video ASAP

i have a doubt, from my view u have imported static data which u have created suppose if the data is updated what we are going to do change the code or it will dynamically updated
if i want i updated the data dynamically how we can achieve?

[paarajvohra]

Hi Yiannis! Is the PUBLISH TO WEB option removed?? Please HELP. I want to publish a Dashboard on my website for public use. It has no sensitive Info as such. PLEASE HELP.

[mishramankamal]

13:07 can we not use any lag function instead of joining so many times? Let me know if not possible.

[newcovenantchurchstreatham]

I do know Python, how can i get an API link that i can link to my Power Bi for the site?

[ousbouchra]

please I am using the latest data and I have found that the null values are in long and lat columns so how would I transform

[vasudeva]

Can you please share the video to learn Python basic for data science

[howtodo]

very nice! I've got an issue with recovered columns, both daily and cumulated. 60% of cells are empty in the extraction( no value). Any help is welcome :) Thx a lot