Forum Replies Created
-
Posts
-
The best type of graph to show ranking is a bar/column graph. To make ranking very clear to see, the pivot table can be formatted to display the service categories ranked in descending order of claims, this will create a pivot chart with the bars also displayed in proper ranking order (service category with the highest number of claims to the lowest). For both the Northern and Eastern Zones, Curative Care Visits have the most number of claims, 1110 claims and 987 claims, respectively. For the Northern Zone, Speech Therapy is ranked last with only 1 claim, while in the Eastern Zone Inpatient Medical and Inpatient Obstetrics are ranked last, both with 2 claims.
The best graph option to display Flores del Mundo’s membership trends over the course of the year is a line graph with a data point for each month of the year (months on x-axis, # of members on the y-axis). A line graph would most clearly allow a reader to see trends over time compared to others displays.
If graphing total membership for the year stratified by member type (employee/spouse/dependent), but are not interested in seeing changes over time, I would use a bar graph, with each bar representing the total number of each member type. The different lengths of bars would make it easy to take away which member type had the most representation versus others during the year displayed. If you were interested in stratifying by member type and change over time, you could display the breakdown of member type for each month or quarter of the year.
If I wanted to display Eastern and Northern membership on the same graph and wanted to see trends over the year, I would create a line graph, similar to the overall membership line graph, but with one line representing Northern membership and another representing Eastern. I would be sure to have each line either be a different color or pattern for people to interpret clearly.
While the WHO Maternity Dashboard does fit Few’s criteria of data being “consolidated and arranged on a single screen,” and utilizes various colors to visually indicate status of an outcome towards the target, there are multiple factors that make me lean towards not qualifying this example as a dashboard. First, Alexander noted that a dashboard should focus on data related to the goal. As stated in the WHO article, the “goal” of this dashboard was to present effectiveness of the PROMPT training, with a secondary focus on identifying adverse outcomes in perinatal trends. The maternity “dashboard” displayed does not specify training outcomes versus overall trends that may or may not be related to the training. The “dashboard” displayed tends to fit Alexander’s definition of a report, as it is a table that contains raw data. This table is more of an intermediary step to a dashboard, which has the potential to be translated into graphical visuals that will allow for conclusions to be drawn “at a glance.”
