Pacharapol Withayasakpunt

Please see my COVID19 Dashboard.

I feel PowerBI a little slow and lagging for my wanting to make decisions…

Map is nice, but if we try to make it a flat projection for the whole world, it is distorted.

Funnel chart is just akin to Bar chart.

Tree map is a very good idea to compare numbers.

Scatter chart is a good idea to show relationship between 3-4 variables, but I personally think time series animation is too complicated and not always understood…[Read more]

– Sparkline is used to show general trend of Confirmed case over time.
– Line chart with forecast is used to show future trend, with confidence interval.
– Clustered bar chart makes it easy to compare between categories.
– Donut chart and sunburst makes a nice comparison over 100%.

My dashboard

Please find my dashboard here : https://app.powerbi.com/view?r=eyJrIjoiODczMmIyNmYtNjMyNi00YzI1LWE0ZWItNmNiM2Q1MTEyOGE0IiwidCI6ImE1NjYxYjU3LTQ3ZDItNDNlNC04MGFhLWYxNzcwMTZhNTJmYiIsImMiOjEwfQ%3D%3D

Everyone seem to use Mercator map for some reasons, even though it is equator-small, Greenland stretched, and USA-just-the-right-size. I might even propose something like Google Earth or D3.js.

– https://covidvisualizer.com/
– https://covid3d.live/

Also, my Chromium-based browser, Brave, lags because of the map… Not sure if it is the case for…[Read more]

Dengue and Arboviral diseases are nice diseases to be studied and apply for Thailand, especially coupled with mapping system — as I saw that there is much affected in southern of Thailand.

As for the current state of Thailand, when the disease is reported, mosquitoes must be controlled, so yes, GIS is important.

> Do you know there is any data-driven decision-making facilitation using in Thailand? If not, which public health issue you will start with?

Sadly, I don’t know one, but data-driven organization is a direction.

> if you were a researcher, what step/detail do you want to add or change in this process flow? and from research limitation, what…[Read more]

A good example of how to find then source of disease with evidence-based, just like John Snow.

I prefer the first one. I think it is more correlate specifically with GIS, although I am not sure of its use…

I think both are valid in different ways, so it actually depends more on how YOU would use the paper. Both are quite relevant to GIS.

But if I had to choose, I would probably go with the second one, as it gives a bigger picture of Malaria towards policy making.

If there is not yet full paper available for the second one, it is hard to choose. But for now, I can tell that for the first one, you might be able to learn a lot about GIS (compared to some other papers I have seen).

– Quite new, about five years
– Time series
– Spatial mapping
– High impact disease

– SubjectID can be backtracked to confirm site of working; also included are date of visit and date of informed consent
– Exact date of birth and initials should probably be avoid, as it can potentially identify the person. I would rather reduce to Month and Year, or Year only, just to be safe.
– Onset date in General Medical History is picky, and…[Read more]

A direct and clear advantage, is that when that research is picked from the shelf, it can be correctly interpreted. Meta-analysis can be easier.

In the meantime, before the research is done, it can mean that it can be computerized and OCR’d, and data sharing can be easier to be done in real time.

I have seen a study of a pharmaceutical that we have to sign who is interpreting the questionnaire, but the use simply Excel.

Still, in many parts, it is excruciating and error-prone. If SPSS is to be used it might be safer. A relational database isn’t used yet.

Race should have some checkboxes, or a guide on how to write.

In my experience of data collection, I have little experience of research, but the data collection system has to be well designed. However, I truly missed one facet, what if the data is reused…

I can tell little from the point of view of software development and utilizing data. When a long time has passed, maybe months, I tend to forget how the…[Read more]

I was indirectly involved in data extraction from questionnaires of my parent’s work (of a pharmaceutical company).

– It might be impossible with design the questionnaire without marketing research.
– Other checkboxes, and fill in the blank might the choice, but the answers vary; and it is prone to subjectiveness of what is similar and not.
-…[Read more]