Covid 19 Dashboard in power bi

This recipe helps you make a Covid 19 Dashboard in power bi

Recipe Objective - Covid 19 Dashboard

Part 1:

Part 2:

Part 3:

Step 1 - Open Power BI report

Step 2 - Import dataset in Power BI report.

To import dataset, go to Home -> Get data -> Select dataset

Step 3 - Creating some calculated measures(fields).

To create calculated measures -> Right click on dataset in Fields section -> Select New measure -> Enter the following formulas one by one:

Active cases = SUM('CoronaVirus Data'[Confirmed Daily])-SUM('CoronaVirus Data'[Deaths Daily])-SUM('CoronaVirus Data'[Recovered Daily])

Average Confirm daily = SUM('CoronaVirus Data'[Confirmed Daily]) / DISTINCTCOUNT('CoronaVirus Data'[Date])

Average Death daily = SUM('CoronaVirus Data'[Deaths Daily]) / DISTINCTCOUNT('CoronaVirus Data'[Date])

Average Recovered daily = SUM('CoronaVirus Data'[Recovered Daily]) / DISTINCTCOUNT('CoronaVirus Data'[Date])

Mortality Rate = SUM('CoronaVirus Data'[Deaths Daily])/SUM('CoronaVirus Data'[Confirmed Daily])

Recovery Rate = SUM('CoronaVirus Data'[Recovered Daily])/SUM('CoronaVirus Data'[Confirmed Daily])

Step 4 - Designing dashboard.

Add 'Image' for logo in Power BI report.

To add 'Image', go to Insert -> Select 'Image' from Elements section -> Choose Image.

Add 'Title' in Power BI report.

To add 'Title', go to Insert -> Select 'Text box' from Elements section -> Enter title as 'Covid-19 Global Analysis'.

Add 'Card' for Mortality Rate in Power BI report.

To add 'Card', go to Visualization pane -> Drag and drop 'Card' visual in Power BI report.

Add fields into the 'Card' visual

Put 'Mortality Rate' in 'Fields'.

Similarly, create cards for 'Mortality Rate', 'Recovery Rate', 'Average confirmed cases per day', 'Average recovered cases per day', and 'Average deaths per day'.

Add 'Guage' for Total Cases in the Power BI report.

To add 'Guage', go to Visualization pane -> Drag and drop 'Guage' visual in Power BI report.

Put 'Confirmed Daily' in the 'Value' and 'Maximum value' fields.

Add 'Guage' for Active Cases in the Power BI report.

To add 'Guage', go to Visualization pane -> Drag and drop 'Guage' visual in Power BI report.

Put 'Active Cases' in 'Value' and 'Confirmed Daily' in the 'Maximum value' field.

Add 'Guage' for Deaths in the Power BI report.

To add 'Guage', go to Visualization pane -> Drag and drop 'Guage' visual in Power BI report.

Put 'Deaths Daily' in 'Value' and 'Confirmed Daily' in the 'Maximum value' field.

Add 'Guage' for Recovered in Power BI report.

To add 'Guage', go to Visualization pane -> Drag and drop 'Guage' visual in Power BI report.

Put 'Recovered Daily' in 'Value' and 'Confirmed Daily' in the 'Maximum value' field.

Add 'Slicer' for Month-year in Power BI report.

To add 'Slicer', go to Visualization pane -> Drag and drop 'Slicer' visual in Power BI report.

Put 'Month-Year' in 'Field'.

Add 'Slicer' for Date in the Power BI report.

To add 'Slicer', go to Visualization pane -> Drag and drop 'Slicer' visual in Power BI report.

Put 'Date' in 'Field'.

Add 'Slicer' for Country/Region in the Power BI report.

To add 'Slicer', go to Visualization pane -> Drag and drop 'Slicer' visual in Power BI report.

Put 'Country/Region' in 'Field'.

Add 'Map' for Covid-19 confirmed cases in the Power BI report.

To add 'Map', go to Visualization pane -> Drag and drop 'Map' visual in Power BI report.

Put 'Country/Region' in the 'Location' field and 'Confirmed Daily' in the 'Size' field.

Add 'Clustered bar chart' for Confirmed Cases by Country/Region in Power BI report.

To add 'Clustered bar chart', go to Visualization pane -> Drag and drop 'Clustered bar chart' visual in Power BI report.

Put 'Country/Region' in the 'Axis' field and 'Confirmed Daily' in the 'Values' field.

Add 'Line and Clustered column chart' for Cumulative Confirmed, Deaths, Recovered by Date in Power BI report.

To add 'Line and Clustered column chart', go to Visualization pane -> Drag and drop 'Line and Clustered column chart' visual in Power BI report.

Put 'Date' in the 'Shared axis' field, 'Deaths' in 'Column values' field, 'Confirmed' and 'Recovered' in the 'Line values' field.

Add 'Table' in the Power BI report.

To add 'Table', go to Visualization pane -> Drag and drop 'Table' visual in Power BI report.

Put 'Country/Region', 'Confirmed Daily, 'Recovered Daily', 'Deaths Daily', 'Average Confirm daily', 'Average Recovered daily', 'Average Deaths daily', 'Recovery Rate' and 'Mortality Rate' in 'Values' field.

To apply conditional formatting on Table -> Go to Format -> Conditional formatting -> Select column -> Turn on Data bar.

In this way, we can create a Covid-19 Global Analysis Dashboard in Power BI.

Download Materials

What Users are saying..

profile image

Ray han

Tech Leader | Stanford / Yale University
linkedin profile url

I think that they are fantastic. I attended Yale and Stanford and have worked at Honeywell,Oracle, and Arthur Andersen(Accenture) in the US. I have taken Big Data and Hadoop,NoSQL, Spark, Hadoop... Read More

Relevant Projects

Learn to Build an End-to-End Machine Learning Pipeline - Part 1
In this Machine Learning Project, you will learn how to build an end-to-end machine learning pipeline for predicting truck delays, addressing a major challenge in the logistics industry.

Build a Customer Churn Prediction Model using Decision Trees
Develop a customer churn prediction model using decision tree machine learning algorithms and data science on streaming service data.

PyCaret Project to Build and Deploy an ML App using Streamlit
In this PyCaret Project, you will build a customer segmentation model with PyCaret and deploy the machine learning application using Streamlit.

Loan Default Prediction Project using Explainable AI ML Models
Loan Default Prediction Project that employs sophisticated machine learning models, such as XGBoost and Random Forest and delves deep into the realm of Explainable AI, ensuring every prediction is transparent and understandable.

Deep Learning Project for Time Series Forecasting in Python
Deep Learning for Time Series Forecasting in Python -A Hands-On Approach to Build Deep Learning Models (MLP, CNN, LSTM, and a Hybrid Model CNN-LSTM) on Time Series Data.

GCP MLOps Project to Deploy ARIMA Model using uWSGI Flask
Build an end-to-end MLOps Pipeline to deploy a Time Series ARIMA Model on GCP using uWSGI and Flask

Azure Text Analytics for Medical Search Engine Deployment
Microsoft Azure Project - Use Azure text analytics cognitive service to deploy a machine learning model into Azure Databricks

Build a Music Recommendation Algorithm using KKBox's Dataset
Music Recommendation Project using Machine Learning - Use the KKBox dataset to predict the chances of a user listening to a song again after their very first noticeable listening event.

Customer Market Basket Analysis using Apriori and Fpgrowth algorithms
In this data science project, you will learn how to perform market basket analysis with the application of Apriori and FP growth algorithms based on the concept of association rule learning.

OpenCV Project for Beginners to Learn Computer Vision Basics
In this OpenCV project, you will learn computer vision basics and the fundamentals of OpenCV library using Python.