internal
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
internal [2020/11/03 07:35] ngohaily created |
internal [2020/11/03 08:22] (current) ngohaily |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| ==== 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 ==== | ==== The components of dashboard ==== | ||
| 1. The part of health information | 1. The part of health information | ||
| + | |||
| a. Map of COVID-19 confirmed cases in Vietnam | a. Map of COVID-19 confirmed cases in Vietnam | ||
| - | - Using data: the table of Covid-19 provinces (EN, VI) | + | |
| + | - 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: | - Visualizing in google studio data: | ||
| - | o Geodimension: the column of province (using location of city geoname) | + | |
| - | o Metric: infected column (beside it, there are some options such as recovered, active, deaths) | + | * 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) | - Data mode: live data (Sometimes need monitoring to repair the workflow if necessary) | ||
| + | |||
| - Source: Ministry of Health in Vietnam | - Source: Ministry of Health in Vietnam | ||
| + | |||
| b. COVID-19 situation in province | b. COVID-19 situation in province | ||
| - | - Using data: the table of Covid-19 provinces (EN, VI) | + | |
| + | - 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: | - Visualizing in google studio data: | ||
| - | i. Dimension: the column of province (data type is string) | + | |
| - | ii. Metric: the columns such as infected, recovered, active and deaths | + | * 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) | - Data mode: live data (Sometimes need monitoring to repair the workflow if necessary) | ||
| + | |||
| - Source: Ministry of Health in Vietnam | - Source: Ministry of Health in Vietnam | ||
| + | |||
| c. Education video | c. Education video | ||
| - | - Using data: using the data from third party on youtube (EN, VI) | + | |
| + | - 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 | - Visualizing in google studio data: insert the link under representation image | ||
| + | |||
| - Data mode: offline data | - Data mode: offline data | ||
| + | |||
| - Source: online youtube | - Source: online youtube | ||
| + | |||
| d. Hotline for COVID-19 | d. Hotline for COVID-19 | ||
| - | - Using data: the table of hotline contacts (EN, VI) | + | |
| + | - 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: | - Visualizing in google studio data: | ||
| - | i. Dimension: the columns of agency and telephone number | + | |
| + | * Dimension: the columns of agency and telephone number | ||
| - Data mode: offline data | - Data mode: offline data | ||
| + | |||
| - Source: ODV collected on media | - Source: ODV collected on media | ||
| + | |||
| e. List of designated centers for quarantine and treatment facilities for COVID-19 | e. List of designated centers for quarantine and treatment facilities for COVID-19 | ||
| - | - Using data: data stored on on CKAN of ODV (EN, VI) | + | |
| + | - 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 | - Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string | ||
| + | |||
| - Data mode: offline data | - Data mode: offline data | ||
| + | |||
| - Source: ODV collected on media | - Source: ODV collected on media | ||
| + | |||
| 2. Social security resources | 2. Social security resources | ||
| + | |||
| a. Government support packages | a. Government support packages | ||
| - | - Using data: data stored on CKAND of ODV including 2 items: for citizens (EN, VI) and for the business and enterprise (from the government newspaper) | + | |
| + | - 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 | - Visualization: insert the data link stored on CKAN of ODV under the text string | ||
| + | |||
| - Data mode: offline data | - Data mode: offline data | ||
| + | |||
| - Source: ODV collected on media | - Source: ODV collected on media | ||
| + | |||
| b. Initiatives by community | b. Initiatives by community | ||
| - | - Using data: data stored on CKAND of ODV including 2 items: Rice ATM & Zero VND supermarket (EN, VI) and Face mask ATM (from the Thanh Nien newspaper) | + | |
| + | - 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 | - Visualization: insert the data link stored on CKAN of ODV under the text string | ||
| + | |||
| - Data mode: offline data | - Data mode: offline data | ||
| + | |||
| - Source: ODV collected on media | - Source: ODV collected on media | ||
| + | |||
| c. Confirmed cases by gender and age group | c. Confirmed cases by gender and age group | ||
| - | - Using data: the table of patient information (EN, VI) | + | |
| + | - 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: | - Visualizing in google studio data: | ||
| - | i. Dimension: the column of age | + | |
| - | ii. Metric: Male and female columns | + | * 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 | - Data mode: need to update in the table of patient information about gender in google sheet | ||
| + | |||
| - Source: Ministry of Health in Vietnam | - Source: Ministry of Health in Vietnam | ||
| + | |||
| 3. Other resources | 3. Other resources | ||
| + | |||
| a. Covid-19 dataset | a. Covid-19 dataset | ||
| - | - Using data: the profile about Covid-19 in Vietnam in ODV page (EN, VI) | + | |
| + | - 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 | - Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string | ||
| + | |||
| - Data mode: offline data | - Data mode: offline data | ||
| + | |||
| - Source: ODV collected on media | - Source: ODV collected on media | ||
| + | |||
| b. Policy timeline to covid-19 | b. Policy timeline to covid-19 | ||
| - | - Using data: data stored on the ODV page (EN, VI) | + | |
| + | - 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 | - Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string | ||
| + | |||
| - Data mode: offline data | - Data mode: offline data | ||
| + | |||
| - Source: ODV collected on media | - Source: ODV collected on media | ||
| + | |||
| c. Covid-19 regulation dataset | c. Covid-19 regulation dataset | ||
| - | - Using data: data stored on the CKAN of ODV page (EN, VI) | + | |
| + | - 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 | - Visualizing in google studio data: insert the data link stored on CKAN of ODV under the text string | ||
| + | |||
| - Data mode: offline data | - Data mode: offline data | ||
| + | |||
| - Source: ODV collected on media | - Source: ODV collected on media | ||
| + | |||
| 4. Confirmed case summary | 4. Confirmed case summary | ||
| + | |||
| a. The score | a. The score | ||
| - | - Using data: the table of patient information | + | |
| + | - 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. | - 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) | - Data mode: live data (Sometimes need monitoring to repair the workflow if necessary) | ||
| + | |||
| - Source: Ministry of Health in Vietnam | - Source: Ministry of Health in Vietnam | ||
| + | |||
| b. Timelines covid-19 cases in Vietnam | b. Timelines covid-19 cases in Vietnam | ||
| - | - Using data: Asia map covid (EN, VI) | + | |
| + | - 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 | - Visualizing in google studio data: using chart line | ||
| - | i. Dimension: the week column | + | * Dimension: the week column |
| - | ii. Metric: the columns such as total cases and death cases | + | * Metric: the columns such as total cases and death cases |
| - Data mode: offline data is updated every 14 days. | - Data mode: offline data is updated every 14 days. | ||
| + | |||
| - Source: OWID | - Source: OWID | ||
| + | |||
| c. Map of total COVID-19 cases in countries of ASEAN and China | c. Map of total COVID-19 cases in countries of ASEAN and China | ||
| - | - Using data: Asia map covid | + | |
| + | - Using data: [[https://docs.google.com/spreadsheets/d/19tOudaR81lpTI4ucvBSu3GcZx95VBHgcVgHBb0QVT48/edit#gid=446489772|Asia map covid]] | ||
| - Visualizing in google studio data: using geo chart | - Visualizing in google studio data: using geo chart | ||
| - | i. GeoDimension: the column of country | + | * GeoDimension: the column of country |
| - | ii. Metric: Total cases column and with option death cases column | + | * Metric: Total cases column and with option death cases column |
| - Data mode: live data (Sometimes need monitoring to repair the workflow if necessary) | - 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. | - 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 .** | ||
internal.1604388936.txt.gz · Last modified: 2020/11/03 07:35 by ngohaily
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
