The infographics in the form of a silhouette of a human aura informs us that, in general, the patient's health is below average.
How to read this dashboard? As an example, let's start analyzing the patient's condition by visualizing data from left to right. Instructions for working with visual analysis on a DashboardĪll 15 indicators of the patient's health status are visualized on the dashboard: REACTION - indicators of the patient's neurological response.Īll data on the history of the disease from the table, by the sample formulas, are transmitted and processed on the “Processing” sheet:įurther, after the selection of processing, the health history data is presented on the main sheet "DASHBOARD".CHEERFULNESS - results of cheerfulness tests.HEMOGLOBIN - the level of deviation from the norm of the hemoglobin indicator.LEUKOCYTES - the number of points of deviation from the norm of leukocytes in the blood (value 0 means normal, -3 deviation downward from the norm, 3 - above the norm).PULSE is the average daily heart rate per minute.
KIDNEY - the current state of the kidneys.STOMACH - a condition of the gastrointestinal tract.LUNGS - indicators of the level of lung condition according to a five-point assessment system.BRAIN - indicators of the state of the brain (level 5 - excellent, 1 - very bad).The table for filling in the template is on the “Data” sheet. This will prevent the so-called statistical “noise” and also filter out statistical outliers. In the medical dashboard, it is possible to group daily values data in periods of up to 7 days (for example, by weeks or 5 days, and at least 1 day) to get their average values. It is necessary to fill in the table in the template so that the dashboard visualizes certain basic indicators of the patient's health on the main sheet. We have baseline data obtained from the patient's medical history for a period of 1 month (November 2020). In order to understand the principle of operation of the medical dashboard template in Excel, we first simulate the situation. Visualization of medical history analysis data in Excel