22 Visualisation charts in CLUBASID

Data visualisation is a very important topic. With more and more data accumulating, it is important that we are able to visualise them using different charts. In CLUBASID, data is understood through entities, attribute and time. So what do all these mean? Let us say we want to compare GDP, population and HDI (Human Development Index) of different countries.

• Attributes will be GDP, population and HDI.
• Entities will be the names of the countries (e.g. Ghana, Zimbabwe, Gambia, Ethiopia, etc).
• Time will represent the years we are concerned about (e.g 1970, 1971, 1972, etc).

CLUBASID also returns data values in “global” and “local”.

• Local represents the actual value that we want. So if we want select an attribute (say GDP) and an entity (say Ghana), We will see the GDP of Ghana in a particular year (year can change based on the animation timeline graph).
• Global represents the sum of attribute values across all entities. So if we select an attribute (say population), “global” will show us the total population across all the entities in our data (e.g. combined population of all the countries in our data) in a particular year (year can change based on the animation timeline graph).

Unlike Microsoft Excel and many others, CLUBASID not only allows you to visualise data, but allows you to see the data over time using a animation timeline graph. CLUBASID is currently live on the Microsoft store https://www.microsoft.com/en-us/p/pandemic-simulator/9n86x1xhz765?activetab=pivot:overviewtab

1. Bar Chart (Comparing attributes)

This graph allows you to compare attributes values in in an entity. For example if we have an infectious disease data with attributes of “Infected”, “Recovered” and “susceptible” and with “Ghana” as an entity, we can compare the number of infected, number of recovered and number of susceptible people in Ghana.

2. Piechart

Piechart is useful when comparing data as parts of a whole. Values are shown as a percentage of the whole. For example, if you have a population data on gender, you can show what percentage of the population is male or female.

3. Donut Chart

This is just like pie chart with a hole in the middle, hence the name “donut” chart.

4. Race bar chart

Race bar chart is simply a horizontal bar chart that compares the attributes of different entities over time. This chart can also sort values from highest to lowest. The example below is comparing yearly revenue in different companies from 2005 to 2020.

5. Scatter animated plot over time.

This chart shows multiple attributes and how they change over time. For example, you can use this chart to see how GDP and Population change over time in a particular country.

6. Correlation graph

This graph allows us to find the correlation between two variables using linear regression. We then get the equation of the slope line as well as the R and R-squared.

7. Relative circles

Relative circles uses circles for every attribute or entity we are trying to compare. The bigger circles represent bigger values while smaller circles represent smaller values.

8. 3D spatial graph (5D graph)

This graph uses 3 spatial dimensions as well as colour and size to show values across 5 dimensions. To fully exploit this graph, there must be at-least 5 attributes in your data.

9. 4D graph (2D spatial)

Just like the graph above. however, this one is a regular 2D spatial graph with 2 additional axis of size and colour. To fully exploit this graph, there must be at-least 4 attributes in your data.

10. Stacked bar chart

Stacked bar chart is a kind of bar chart where multiple values can be stacked on to one another in a single data stack. You can choose to stack multiple attributes in a data stack.

11. Group bar chart

with group bar chart, a bar column in created for every attribute in every entity. Colours are assigned to the bars based on the attribute they represent.

12. Line chart

In line chart, we are trying to show the changes in data over time.

13. Area Chart

Similar to line graph, the only difference is that we shade the area under the curve.

14. Range bar chart

Range bar chart shows a the highest and lowest value of a particular attribute over time. Each bar represents a particular entity. A use case for this would wanting to show Highest GDP and Lowest GDP from 1990 to 2020 for different countries.

15. Spider Chart

Spider chart is perfect when you want to compare lots of attributes (from 4 to about 10) between 2 entities.

16. Gauge chart

Gauge chart is like a speedometer chart. There is a gauge for every entity and the the needle as well as the text for each gauge indicate the value of the selected attribute at that point in time.

17. Waterfall chart

Waterfall chart shows the increases or decreases in attribute data over time. If for-example the time interval is 1 second and we are showing data for 7 seconds a green bar would represent an increase in value compared to the previous second and a red bar would indicate a drop in value compared to the previous second.

18. Geo-map chart

To use this chart, when the entities represent countries. In this case you can then map each entity to a country on the map that they represent. Red indicated high value and green indicated low value.

19. Histogram

The purpose of this graph is to show frequency distribution in the data.

20. Heat Map

Basically a table with attributes as columns and entities as rows. It uses red colour to indicate high values and green colour to indicate low values.

21. CandleStick

In this chart, each candlestick represents a range of values. The white part of the candle is the shadow which has an upper limit “high” and a lower bound “low”. The main part of the candlestick (the body) will be green if the value first value of the range (that the candle represents) is less than the end value of the range. For example, a candle that has the range of 3,6,1,5,3,1 will be red because 1 (the last value) is less than 3 (the first value) and the candlestick will have a “high” of 6 and a “low” of 1.

22. Gantt chart

This graph is different from the rest as it is not visualising the loaded data. This graph simple visualises different tasks (added by the user) as well as the start time and the end time of these tasks.

CLUBASID is currently live on the Microsoft store https://www.microsoft.com/en-us/p/pandemic-simulator/9n86x1xhz765?activetab=pivot:overviewtab