Week 2 Visualization project

[Saranath]

Create charts using appropriate variables of interest. Then publish your work and share your link in this forum and explain briefly how these graphs can be helpful for decision making. (15 points)

 

Please post a short URL in this forum by copy your PowerBI url to https://bitly.com/ or https://tinyurl.com/ website. Then copy the short url and post in the forum.

Posting a long URL will disable the reply function in our forum.

[Arwin Jerome Manalo Onda]

Hi everyone,

Attaching my PowerBI dashboard for this week’s assignment.

Power BI

COVID-19 dashboard with number of cases (confirmed, recovered, deaths) is one of the measures in determining the country’s response to this public health emergency.

Best,
Arwin

[Arwin Jerome Manalo Onda]

For some reason, even after I followed the steps on publishing the report, it still displays incomplete columns. But when in editor mode, I can still see the columns for the deaths, recoveries, and confirmed case.
See attached screenshot.

Screenshot

[Amnat Khamsiriwatchara]

Can you send you pbi file so I can have a look?
Amnat

[Arwin Jerome Manalo Onda]

Hi Professor,

I think it took a good few minutes for the dashboard to refresh. It now displays the updated columns based on my last update.

Still attaching the PBIX for your reference.

Best,
Arwin

[Boonyarat Kanjanapongporn]

Overall covid situation is illustrated with Table chart. Cumulative cases and Cases per million (Confirmed, Recovered, Death) are for the reader to compare figures between countries. Filtrating continent and date are for specific region and time comparison.

Matrix chart includes GDP groups slicer. Countries which have the same range of GDP are group together. Trend of covid-related figures might be noticed with different GDP groups of countries.

My publish dashboard :

https://tinyurl.com/2p859vrv

[Saranath]

Well done!

[Karina Dian Lestari]

Hi all,

Kindly see my Power BI dashboard. This dashboard show Countries, GDP per capita and COVID-19 variables, such as daily cases, daily recovery, and daily death. The table is useful to make a comparison, for example between the GDP per capita and COVID-19 cases.

This is also my successful connection to the dataset .

Thank you.

[Saranath]

Well Done!

[Kansiri Apinantanakul]

Hi All,
Please see my dashboard in the link: https://bit.ly/3NgxdCR
Please allow me to pick up the a little bit different topic to analyze in this week.
My idea just pop up when I saw the column of internet user and internet host in combination with GDP.
This dashboard composed of continent, country, population, internet host, internet user, and GDP.
I imagined myself as a investor who interested in investment of internet service globally.
This dashboard shown demand (internet user) and supplies (internet host) in combination with GDP.
The country with high GDP, high demand and lower supplies would be attractive country to be invest.

However, in order to explore the country in particular GDP range, user can use the slicer to select the interested range.

[Saranath]

Hi! I could not access to your dashboard. It seems that the report was not published. Could you please check?

[Kansiri Apinantanakul]

Please kindly try the new link: https://bit.ly/3A7oWOI
Thank you !

[Amnat Khamsiriwatchara]

This is a good example in how to extract info from your interest, and distribute them through the tool. Well done.

[TARO KITA]

Hi all,
Please follow the link below to access the assignment for the COVID-19 Dashboard.
https://bit.ly/3yiKVRn

This matrix includes figures by country for Daily confirmed, Daily recovered, and Daily death. These data are used at the national level as a basis for restructuring the healthcare system in response to outbreaks and for planning the allocation of resources, as well as indicators for the issuance or lifting of a state of emergency declaration, involving various restrictions.

[Saranath]

I also could not find your dashboard in the link. Could you please check?

[TARO KITA]

My apologies. Please find the updated link below to access the assignment.
https://bit.ly/3nkltF1

[Tossapol Prapassaro]

Dear all,
Here is my report link https://tinyurl.com/yn7h5kpp

This table report the COVID-19 situation, the variables include The name of country, Confirmed cases, total deaths, recovered cases and GDP.

And here is my screen captured showing the connected datasets https://drive.google.com/file/d/1JwCFJXXOXcPW8Njij24Ykn6RBPtkja26/view?usp=sharing

[Ashaya.i]

Hi everyone,
You can access my report via link https://tinyurl.com/3dbzk9h8

This report shows the confirmed cases, recovered cases, and death cases of COVID-19 per million by country and also shows the GDP of each country. By doing so, we can see some differences of high GDP country and COVID-19 cases and estimate the capability to encounter with the COVID-19 situation in each country.

[Sri Budi Fajariyan]

Dear all

Here is my dashboard for covid data analysis,

https://bit.ly/3ubMluI

Consist of:
1. Table of daily confirmation, recovery, and death per country to evaluate the burden
2. Matrix of GDP and daily confirmation cases

Thank you

[Napisa Freya Sawamiphak]

Please find my dashboard here: http://tinyurl.com/2p9446td

My dashboard mainly focuses on confirmed COVID-19 cases across the continent, country, and capital. Using a map and a line graph for data visualization makes it easier to understand the trend of confirmed cases/ongoing transmission over time, which is useful for disease surveillance and public health. The user can review the full data in the matrix and table, and also filter data for specific locations, GDP, and the number of confirmed cases/deaths/recovered based on their preference.

[Hazem Abouelfetouh]

Hi everyone,

Please follow the link for my Dashboard

Tab 1: A table chart includes country and capital name with Population, GDP, Confirmed cases, Recovered cases, and Death and a slicer to filter by country name.
Tab 2: A matrix chart by continent and slicers to filter by date, continent and country name.

[Hoang Thuy Linh]

Here is my link:
https://app.powerbi.com/links/2bzIWbSWkq?ctid=a5661b57-47d2-43e4-80aa-f177016a52fb&pbi_source=linkShare
1. A filter for locations, countries, year, month… for choosing
2. the map with country’s death number to alarm how important and severe in each country
3. Confirmed cases in each continent to see the whole COVID-19 situation in the world
4. Total Confirmed, death, recovered cases in each country
Thank you

[Hoang Thuy Linh]

here is my table’s link
https://app.powerbi.com/links/2bzIWbSWkq?ctid=a5661b57-47d2-43e4-80aa-f177016a52fb&pbi_source=linkShare&bookmarkGuid=1e31215c-170d-46fe-8243-7e21023c1503
thank you

[Anawat ratchatorn]

This is my dashboard for Week2. I use table, matrix, slicers, and also try to add a few additional other charts to make it more useful for decision making.

It consists of 5 pages.

1. The first page demonstrates Overall Covid-19 situation including Total cases, total deaths, and the line chart of total confirmed cases by date sliced by continents and country. The first dashboard provide overall situation and trend of cumulative cases to make us understand a big picture.

2. The second page is daily stats. There are 2 charts, Daily Confirmed cases by date and Daily Deaths by date, with slicer that can filter by Year/Month/Date and Area(Continents, Countries, Province). The chart provide us deeper detail of daily situation each day and each specific area. With these information, we can see trend of covid-19 severity situation in any specific date and area.

3. The third page is table containing very informative detail about each country. This table also provide information of Capital and GDP. And I also create new measurement that I use Sum of Deaths divided by Sum of Confirm to the DeathConfirmRatio. I imply that this ratio can tell us about effectiveness of Covid-19 patient care. And it might be related with GDP or GDP per Capita. There are 2 filters, Date and Area.

4. The fourth chart is Treemap. I decide to illustrate number of confirmed cases in percentage. So you can see the percentage along with proportion of the area to see proportion of confirmed cases proportion among continents. You can also click on each continents’ area to drilldown to see deeper detail in each continent. There is also a matrix showing number of Confirmed cases, Deaths, and Recovered cases categorized by Continent and Country that make you to see exact number along with Treemap. Date filter is also provided. This chart make you to be able to compare cases in each area.

5. The last one is map. Bubbles’ size represent number of cases in each area. You can click on the bubble to drilldown. This map provide geographical data related with Covid19 cases.

[Author]

Posts