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:
- Microsoft Power BI Basic in house training in Australia at Sydney, Melbourne, Brisbane, Perth and Adelaide.
- Microsoft Power BI Advanced in house training in Australia at Sydney, Melbourne, Brisbane, Perth and Adelaide.
- Microsoft Power BI Corporate training in Australia at Sydney, Melbourne, Brisbane, Perth and Adelaide.
- Microsoft Power BI Basic Online Training Course.
- Microsoft Power BI Advanced Online Training Course.
- Microsoft Power BI consulting services.
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: email@example.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 dateset 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:
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.
I have provided all the 10 visuals (both interactive and static) below with some explanation, and also provided the short video.
Interactive Visuals: visuals
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.
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: firstname.lastname@example.org
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.
“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.