Covid-19 Dashboard Using Power BI

Project Outline

This project is all about Data visualized Web-based dashboard to get information on Covid-19. This dashboard is showing information in form of Graphs and Charts so it will be easy to get information and it is easy to do Analysis.

The goal of Data Visualization

The primary Goad of Data Visualization is to communicate information clearly and effectively to users via the statistical graphics, plots, information graphics, tables, and charts selected. 

Effective visualization helps users analyze and reason about data and evidence. It makes complex data more accessible, understandable, and usable.

There are lots of Data Visualization tools are available in the market like Tableau, Looker, Microsoft Power BI, Plotly, Fusion Charts, etc. Here in this project, we will be using Microsoft Power BI.

What is Power BI?

Microsoft Power BI is a business intelligence platform that provides non-technical business users with tools for aggregating, analyzing, visualizing, and sharing data. we can get data from multiple Data Sources like SQL, Excel, CSV File, etc. Provides Personalized Data boards, Simple and Performance Oriented, Secure reports.

It uses Power Query which is a similar kind of SQL Language to do mathematical and other operations on Data.

Our Dashboard Functionalities

                                                    Global

India

 

To make this dashboard we have used a CSV file which is there in our Github repository in that file we are having columns as confirmed, confirmed daily, Deaths, Deaths daily, State/Union Territories, Time, Recovered, Recovered daily, and other fields.

So we have performed the below query operations and got the required information which we want to show on the dashboard,

Queries

Active Cases Query

Active cases1 = SUM('India'[Confirmed Daily])-SUM('India'[Deaths Daily])-SUM('India'[Recovered Daily])

Average Confirm Daily

Average Confirm daily1 = SUM('India'[Confirmed Daily]) / DISTINCTCOUNT('India'[Date])

Average Death Daily

Average death daily1 = SUM('India'[Deaths Daily]) / DISTINCTCOUNT('India'[Date])

Average Recovery Daily

Average Recoveries daily1 = SUM('India'[Recovered Daily]) / DISTINCTCOUNT('India'[Date])

Total Cases

total cases = SUM('India'[Confirmed Daily])

Total Active Cases

total active cases = SUM('India'[Active Cases1])

Total Deaths

total deaths = SUM('India'[Deaths Daily])

Total Recovered

total recovered = SUM('India'[Recovered Daily])

So we have used the above queries to build various graphs and tables shown in our dashboard.

Future Improvements

We will be trying to make UI better and add more graphs and charts as part of our dashboard so Users can get more information from our dashboard.

We will be Integrating its report from the dashboard to the Web page and at this time it is static means we are using a CSV file in which data is already cleaned and directly used in the backend to make these charts but we will be making it Dynamic. also these dashboard is only for INDIA related information but we will be making it available from whole Glob.

Thank you for reading 

Prepared By: 19IT069 Veet Moradiya

                       19IT070 Dhruv Nagar

Mentored By : Mrudang Pandya