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
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
