Power BI

Corona (COVID – 19) Analysis using Power BI

Microsoft Power BI is widely recognized as the most economical, manageable and well-designed tool for data analysis across the globe. Power BI has a large user base in Australia and United States. With just a basic Microsoft Power BI training course, you can develop the skills required to design a Power BI report and analyze data. Climbing the ladder, with Microsoft Power BI advanced course, you can become proficient in connecting multiple data sources, performing data transformation, data modeling and creating the latest AI based visualizations. We, at AMZ Consulting Pty Ltd provide the following Microsoft Power BI learning opportunities:

With the mission to empower individuals and businesses, AMZ Consulting Pty Ltd Arranged a guest blogging competition in May,2020. The effort was focused on using Power BI for data analysis amidst the Corona Crisis. Microsoft Power BI arguably proved to be the most robust and powerful tool for analysis and visualization.

Let’s have a look at a few blog that out-stood the others:

Rank # 1:

Blog Title: DATA VISUALIZATION FOR COVID-19 PAKISTAN

Author: Laiba Abbasi

Correspondence email: laibaabbasi43@gmail.com

The Corona virus outbreak has reached threatening levels and is effecting people all over the world. Although, everyone is at risk but a certain category of people such as diabetic patients and cardiac patients are particularly at a greater risk. The outbreak originated in China’s city Wuhan in December 2019 and since then it has spread silently across the world. Pakistan is also amongst the affected regions of the world. In the blog post, I’m going to share Data Visualization for Covid-19 in Pakistan. The dataset I have used for the project fetched from the Kaggle.  The time frame used for analysis is March 11, 2020 to May 5, 2020. 

I have performed analysis in Power BI which is an amazing tool for data analytics. It helped me to make my visuals easily by utilizing its visualization panel. The best feature amongst all is Q&A option. Using Q&A, you can ask questions from the data in your natural language.

I have made a total 10 Visuals on 3 Dashboards to represent my data. I will show and explain each one of the, briefly but before that, let’s look at the data cleaning required prior to visualization: 

DATA CLEANING:

I have cleaned my data in Power BI by transforming data option available in the Power Query Editor.  The following data transformations have been performed:

  • Renaming of all the columns names for the tables in the data.
  • Removing of errors from the columns.
  • Removing of null or NaN from the data and replaced it by the value zero (0).
  • Changing the data types of some of the columns.
  • Replacing the concatenated or Joined line by line feed (to move the other sentence/line to the next line).
  • Removing the extra null row by keeping the top rows.
  • Transforming column to capitalize each word.
  • Created a one to many relationships between two columns of different tables.

DATA VISUALIZATION:

I have provided all the 10 visuals (both interactive and static) below with some explanation, and also provided the short video. 

Interactive Visuals: visuals

VISUALIZATIONS:
Following are the 10 visuals shown statically and interactively is also shown below:-

Highest cumulative case in specific region with respect to date. 

This visual shows that the highest number of cases were registered in May and the location of outbreak was Punjab. 

Regional statistics of total positive cases from the test cases performed.

This visual shows the total number of positive test cases from the total test cases performed in each province (both spatial and summary visuals shown above).

Total deaths, still admitted and the recovered cases across each region.

This visual shows the total number of deaths, admitted and recovered patients in each province.

Foreign and local transmission and their percentages across the Provinces.

Here the first visual shows the number of registered cases from tableegh (a religious gathering practice) and local transmission. The second visual shows the cases emerging from the people traveling from Iran and adjacent areas.  

Total Hospitals and their capacity across each Province.  

Suspected cases, confirmed cases and death cases in the last date and Last 24 hour’s.  (dated for the last date in the data set) 

Hospital-admitted and home quarantined cases.

Contact Tracing of travelers (i.e. returnees from Iran and China)

National Institute of Health (NIH) and Province preparedness and response on specific risk.

News Timeline for the updates in Pakistan and Globally.           

Lets see how this is done. 

GIT-HUB REPOSITORY:

The git-hub repository file for the visualization:  

This widespread transmission of corona pandemic can be controlled by following the social distancing measures such as keeping 6m apart and avoid handshaking. The transmission of this virus can only be minimized if each one of us plays a part to save ourselves and others.

 

Rank # 2:

Blog Title: COVID19 Data Visualization Using Power BI

Author: Arooj Tahir

Correspondence email: aroojtahir14@gmail.com

What is COVID-19?

  • COVID19 is a disease whose spread started from China.
  • Its symptoms include cough, fever, shortness of breath, muscle aches, sore throat, unexplained loss of taste or smell, diarrhea and headache.
  • COVID-19 can be severe as it has been the cause of many deaths around the globe.
  • It is contagious and hence is declared as a pandemic.
  • Corona’s vaccine has not been developed yet.
  • It can be prevented by social distancing, coughing or sneezing in an elbow or tissue papers, avoiding hand shake and physical contacts, disinfecting the spaces every now and then and washing hands frequently. Other recommendations to curb its spread can be found on WHO website

1. How Power BI helped me find useful insights from the COVID outbreak data in Pakistan:

Power BI makes data visualization easy by providing visualization pane to choose your visual. Creation of reports and dashboard is easier and quicker. The dashboards and reports can then be shared with others.

The Data set of Pakistan’s corona virus outbreak was too vast and not understandable by just looking at just the numbers. Power BI created some cool visualizations of data and made it understandable.

The power of Power BI is that:

  • It cleans the data easily, now you may think what is data cleaning?. Data cleaning is the art of removing unnecessary data, remove the syntax errors, correcting spelling mistakes.
  • It creates the relationships between different data sheets and tables. 
  • It provides different themes, colors to decorate graphs and make them easy to understand.

For example, the graph below shows the number of people expired, discharged, home quarantined and still admitted during the outbreak.

This Power BI feature is so interesting and see how easily understandable the graph is.

2. Data story and how Power BI helped me solve my problem at hand:

My data is based on corona patients from Pakistan. This data is taken from Kaggle which is free to use for data scientists. The data was not cleaned before, so I cleaned the data in Python (which in case of Power BI is not necessary)

The loading of data in power BI was my next step, it was so easy to do.

After that, I made the graphs using Power BI’s exciting and easy to use visualization options. The look and feel of the graph could be customized by the options available for each filter.

Power BI is handy and easy to use. Instead of long coding lines to plot of single graph, power BI’s GUI provides the visualization by drag and drop. Just select the columns and values of data and drop your columns into the fields area.

The above visualizations show number of arrivals in last 24 hours, new (Last 24 hours) and test performed in last 24 hours, Cumulative, cumulative test positive and cumulative test performed, Quarantine facilities by Date and Region.

These visualizations show cumulative travelers screened, travelers screened at points of entry in last 24 hours, cumulative number of persons present and number of arrivals in last 24 hours, suspected at points of entry by Date, Month and Region.

The visuals above shows suspected cases cumulative, suspected cases last 24 hours and suspected cases last date, number of total admitted, total hospitals, beds for COVIDS, death recovered and total admitted by Date and Region.

These visualizations show province preparations and response, cumulative tests performed, expired, discharged, home quarantine, still admitted by Date and Region.

3. My favourite Power BI feature? ( a step-by-step guide. )

Power BI is an exciting tool and easy to use. All features are very satisfying and interesting but I’m more attracted toward its graph making ability, there is no coding required and the GUI is easy to understand.

Let’s have a look.

1. After loading your data, click on reports (if in case it’s not on it before)

You already will be on your page one, if not then create a new page found at the bottom of the current page (+ sign in yellow color)

2. Go to the visualization tab and select whatever kind of graph you want to make.

In my case, I’m applying the line chart (Just for explaining).

3. Now select the data axis, legend, Values, Secondary Values, Tool tips by just drag and drop from Fields, found on right most of the screen, and you’re all done.

Rank # 3:

Blog Title: An amazing experience with Power Bi

Author: Hamna Baqai

Correspondence email: hamnabaqai710@gmail.com

“It’s best to have your tools with you. If you don’t, you’re apt to find something you didn’t expect and get discouraged.”      Stephen King

Visualizations means infographics that do the story-telling for the data. Make a visualization and let the data speak!

I used Microsoft Power BI for a course project in by graduation degree. Power Bi, being a powerful analytics tool was recommended by our faculty, to analyze covid19 situation in Pakistan. It proved out to be a valuable tool, which helped me focus more on data easily. Using the spatial mapping features, drawing maps in Power BI was a lot more easier then what I thought.

Getting started in Power BI was possible only after a little guidance in the right direction. The most attractive feature of Microsoft Power BI is to handle a wide range of data sources. Wherever is your data set, Power Bi will get it for you. Whatever data you have, it will be visualized in the form of graphs in reports dashboards.   

Interestingly, it’s features of viewing map of world, highlighting areas with increase or decrease of a particular entity, enabled me to get the best results for my analysis. The graph above graph, shows highlighted spots where the highest number of tests were performed as well as the largest number of covid19 patients present during March-April 2020 in Pakistan.

Creating customized visualization with filters, removing irrelevant and unnecessary objects or regions, helped me to obtain the target values, making it visually appealing as well as a tool to be used for daily data analysis. Alteration of colors, text of titles, legends, x or y axes, adding customized titles and selecting the graph of your choice are the most valuable features.

The tool is intelligent enough to create visually appealing visuals as it automatically adds the labels on best positions on the graph. It was pretty exciting to change the location of the legend from top to right, making it feasible to read the graph.

Another amazing feature is the Focus mode. It helped me to get a larger image with  detailed information. Every feature, I found was exciting and helpful, with user friendly interface Power Bi seems to be the best visualization tool. With hundreds of visualization tools available Power Bi had exactly what I had been looking for.

Back to list

3 thoughts on “Corona (COVID – 19) Analysis using Power BI

  1. I like this website very much, Its a very nice office to read and incur information.

  2. Anonymous says:

    I love looking through a post that can make people think. Also, many thanks for permitting me to comment!

Leave a Reply

Your email address will not be published. Required fields are marked *