===== How to know about workflow of Covid-19 dashboard in Vietnam =====

==== Workflow of Covid-19 dashboard in Vietnam ====
{{ :internal:workflow.png?direct&400 |}}

-	Importing html data is used the import html function in google sheet

-	Organizing data: using some functions like: count if, if, sum, vlookups, …

-	Visualization in google studio data: using some types of chart like line chart, geo chart, scorecard, table, bar chart.

==== The components of dashboard ====

1.	The part of health information

a.	Map of COVID-19 confirmed cases in Vietnam

-	Using data: the table of Covid-19 provinces ([[https://docs.google.com/spreadsheets/d/1pusc-AEvXF8qFuAY2kMeWnycfjA2blceOvT4dHEJqtU/edit#gid=384971799|EN]], [[https://docs.google.com/spreadsheets/d/1pusc-AEvXF8qFuAY2kMeWnycfjA2blceOvT4dHEJqtU/edit#gid=0|VI]])

-	Visualizing in google studio data:

  * Geodimension: the column of province (using location of city geoname)
  * Metric: infected column (beside it, there are some options such as recovered, active, deaths)
  
-	Data mode: live data (Sometimes need monitoring to repair the workflow if necessary)

-	Source: Ministry of Health in Vietnam

b.	COVID-19 situation in province

-	Using data: the table of Covid-19 provinces ([[https://docs.google.com/spreadsheets/d/1pusc-AEvXF8qFuAY2kMeWnycfjA2blceOvT4dHEJqtU/edit#gid=384971799|EN]], [[https://docs.google.com/spreadsheets/d/1pusc-AEvXF8qFuAY2kMeWnycfjA2blceOvT4dHEJqtU/edit#gid=0|VI]])

-	Visualizing in google studio data:

  * Dimension: the column of province (data type is string)
  * Metric: the columns such as infected, recovered, active and deaths

-	Data mode: live data (Sometimes need monitoring to repair the workflow if necessary)

-	Source: Ministry of Health in Vietnam

c.	Education video

-	Using data: using the data from third party on youtube ([[https://www.youtube.com/watch?v=wGoodWEtV8c|EN]], [[https://www.youtube.com/watch?v=BtulL3oArQw|VI]])

-	Visualizing in google studio data: insert the link under representation image

-	Data mode: offline data

-	Source: online youtube

d.	Hotline for COVID-19

-	Using data: the table of hotline contacts ([[https://docs.google.com/spreadsheets/d/19bRDMrM74pr_I6mbMxaxVTuQCLicLEYH1WomqqdE7SU/edit#gid=1237989309|EN]],[[https://docs.google.com/spreadsheets/d/19bRDMrM74pr_I6mbMxaxVTuQCLicLEYH1WomqqdE7SU/edit#gid=0 |VI]])

-	Visualizing in google studio data:

  * Dimension: the columns of agency and telephone number
-	Data mode: offline data

-	Source: ODV collected on media 

e.	List of designated centers for quarantine and treatment facilities for COVID-19

-	Using data: data stored on on CKAN of ODV ([[https://data.vietnam.opendevelopmentmekong.net/dataset/covid-19-quarantine-areas-and-treatment-hospitals-in-vietnam?type=dataset|EN]], [[https://data.vietnam.opendevelopmentmekong.net/vi/dataset/covid-19-quarantine-areas-and-treatment-hospitals-in-vietnam?type=dataset|VI]])

-	Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string

-	Data mode: offline data

-	Source: ODV collected on media 

2.	Social security resources

a.	Government support packages

-	Using data: data stored on CKAND of ODV including 2 items: for citizens ([[https://data.vietnam.opendevelopmentmekong.net/dataset/social-support-during-the-covid-19-epidemic-season-in-vietnam|EN]],[[ https://data.vietnam.opendevelopmentmekong.net/vi/dataset/social-support-during-the-covid-19-epidemic-season-in-vietnam|VI]]) and for [[http://baochinhphu.vn/Thi-truong/Hang-loat-giai-phap-ho-tro-doanh-nghiep/399631.vgp|the business and enterprise]] (from the government newspaper)

-	Visualization: insert the data link stored on CKAN of ODV under the text string

-	Data mode: offline data

-	Source: ODV collected on media 

b.	Initiatives by community

-	Using data: data stored on CKAND of ODV including 2 items: Rice ATM & Zero VND supermarket ([[https://data.vietnam.opendevelopmentmekong.net/dataset/rice-atm-station-and-zero-supermarket-in-vietnam?type=dataset|EN]],[[https://data.vietnam.opendevelopmentmekong.net/vi/dataset/rice-atm-station-and-zero-supermarket-in-vietnam?type=dataset| VI]]) and [[https://thanhnien.vn/thoi-su/xuat-hien-atm-khau-trang-mien-phi-tai-tphcm-1262012.html|Face mask ATM]] (from the Thanh Nien newspaper)

-	Visualization: insert the data link stored on CKAN of ODV under the text string

-	Data mode: offline data

-	Source: ODV collected on media 

c.	Confirmed cases by gender and age group

-	Using data: the table of patient information ([[https://docs.google.com/spreadsheets/d/1ATzhaSAZ4__D2gflXj388658Rj96po2-AFMpzzKAgdU/edit#gid=1191269394|EN]],[[https://docs.google.com/spreadsheets/d/1ATzhaSAZ4__D2gflXj388658Rj96po2-AFMpzzKAgdU/edit#gid=111873581| VI]])

-	Visualizing in google studio data:

  * Dimension: the column of age
  * Metric: Male and female columns
-	Data mode: need to update in the table of patient information about gender in google sheet

-	Source: Ministry of Health in Vietnam

3.	Other resources

a.	Covid-19 dataset

-	Using data: the profile about Covid-19 in Vietnam in ODV page ([[https://data.vietnam.opendevelopmentmekong.net/en/profile/coronavirus-data-in-vietnam|EN]],[[https://data.vietnam.opendevelopmentmekong.net/vi/profile/coronavirus-data-in-vietnam| VI]])

-	Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string

-	Data mode: offline data

-	Source: ODV collected on media 

b.	Policy timeline to covid-19

-	Using data: data stored on the ODV page ([[https://vietnam.opendevelopmentmekong.net/stories/timeline-of-covid-19-and-vietnam-policy-actions-at-a-glance/|EN]],[[https://vietnam.opendevelopmentmekong.net/vi/stories/timeline-of-covid-19-and-vietnam-policy-actions-at-a-glance/| VI]])

-	Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string

-	Data mode: offline data

-	Source: ODV collected on media 

c.	Covid-19 regulation dataset

-	Using data: data stored on the CKAN  of ODV page ([[https://data.vietnam.opendevelopmentmekong.net/en/dataset/40839211-40dc-4252-9ab4-c39aeff3bae6?type=dataset|EN]],[[https://data.vietnam.opendevelopmentmekong.net/vi/dataset/40839211-40dc-4252-9ab4-c39aeff3bae6?type=dataset| VI]])

-	Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string

-	Data mode: offline data

-	Source: ODV collected on media 

4.	Confirmed case summary

a.	The score 

-	Using data: [[https://docs.google.com/spreadsheets/d/1ATzhaSAZ4__D2gflXj388658Rj96po2-AFMpzzKAgdU/edit#gid=1637285597|the table of patient information]] 

-	Visualizing in google studio data: using scorecard and metric corresponding to every column content in google sheet.

-	Data mode: live data (Sometimes need monitoring to repair the workflow if necessary)

-	Source: Ministry of Health in Vietnam 

b.	Timelines covid-19 cases in Vietnam

-	Using data: Asia map covid  ([[https://docs.google.com/spreadsheets/d/19tOudaR81lpTI4ucvBSu3GcZx95VBHgcVgHBb0QVT48/edit#gid=14755850|EN]],[[https://docs.google.com/spreadsheets/d/19tOudaR81lpTI4ucvBSu3GcZx95VBHgcVgHBb0QVT48/edit#gid=2073666860| VI]])

-	Visualizing in google studio data: using chart line
  * Dimension: the week column
  * Metric: the columns such as total cases and death cases
-	Data mode: offline data is updated every 14 days.

-	Source: OWID 

c.	Map of total COVID-19 cases in countries of ASEAN and China

-	Using data: [[https://docs.google.com/spreadsheets/d/19tOudaR81lpTI4ucvBSu3GcZx95VBHgcVgHBb0QVT48/edit#gid=446489772|Asia map covid]] 

-	Visualizing in google studio data: using geo chart
  * GeoDimension: the column of country
  * Metric: Total cases column and with option death cases column
-	Data mode: live data (Sometimes need monitoring to repair the workflow if necessary)

-	Source: ODV collected from MOH in Vietnam, ODC, Ministry of Health in Thailand, worldometers page, outbreak page.

**Note: in parallel the Covid-19 data will be downloaded from the google sheet and
uploaded on CKAN every week to archive .**