Table and Matrix as Visuals = The Same but Different, Use Wisely

by Inforiver | May 09, 2022 |

Table vs Matrix Visuals: Key Differences?

Table and matrix visuals differ from your typical chart & graphs.

Unlike other visualizations, they represent data closest to its original form. They feature values in numeric form rather than focusing upon visual qualities.

Generally, tables and matrices are very commonly used to display dense value structures in static reports and presentations, or as active dashboard controls. Matrices, (also commonly known as Crosstabs or Pivot Tables) are also powerful instruments for data examination when combined with conditional formatting and graphical in-cell visualizations.

However, in many ways, tables and matrices are the same thing. They are both flat displays of rows and columns upon which various manipulations can be performed.

But, there is one key difference. In simple terms, a Table is very similar to data in an ordinary spreadsheet, while a Matrix is very similar to Pivot Table in MS Excel. It aggregates and presents data in a Crosstab or Pivot Table format. In short, as a class of data presentations, Tables are a subset Matrices; and a Table is often best understood in Matrix terms.

A Table is very similar to data in an ordinary spreadsheet, while a Matrix is very similar to Pivot Table in MS Excel

Example

Following are some very basic table and matrix visuals to show how they work. For example, the table below illustrates the produce of a greengrocer who purchases bags of fruits and vegetables to sell from distributors in the US and in the EU.

Table
ItemSourceTypeAmount
applesEUfruit10
orangesEUfruit15
pearsEUfruit20
potatoesEUvegetable25
applesUSfruit15
orangesUSfruit20
pearsUSfruit25
potatoesUSvegetable15

This table has three dimensions: Item, Source and Type; and one measure or value, Amount. Each row corresponds to a record. You can sort or filter the table by any category or value field.

For example, let us assume you are interested in analyzing the mix of fruits & vegetables coming from EU and US. Generally, it is a bit difficult to accomplish with a table visual.

According to Stephen Few, "A common problem with tables and graphs is the excessive presence of visual content that isn’t information. Whenever quantitative information is presented, that information should stand out clearly, without distraction." -- “Designing Effective Tables and Graphs” (Perceptual Edge blog)

Please note that what you can do with a table is largely dependent on the software you are using.

This is where a matrix really shines. It can provide a more focused look at data in summary form, avoiding clutter and emphasizing critical figures.

Pivot Table or Matrix  
    
Sum of AmountColumn Labels
Row LabelsfruitvegetableGrand Total
EU452570
US601575
Grand Total10540145

The Matrix is essentially the same as a Pivot Table. But, it is a summation table built from raw data—generally Tables—through category selection and summarization. They also show data grouped by rows and columns, but it is summary data rather than detailed line-item records. However, matrices are frequently used as active desktop controls, permitting what-if scenarios and experimentation with different groupings.

When it comes to reviewing raw data, a table is sufficient. But, for analysis needs, as shown in the example above, the Matrix is often desired. Almost all leading BI software including Power BI, Tableau and Spotfire provide matrix reporting capabilities in addition to tabular reporting.

Enhanced Table/Matrix Visualization

In addition to display of numbers, table and matrix visualizations can be enhanced with cell-level alerts. One typical visualization is a heat chart, in which colors such as green to red are used to highlight the values in individual cells. This draws users’ attention to critical areas.

Enhanced Table/Matrix Visualization - Heat Chart

Another type of visualization is to superimpose a bar chart on top of the table or matrix.

Enhanced Table/Matrix Visualization - Bar Chart

Finally, the addition of Sparklines to a table is becoming increasingly common. These are small single-cell worksheet charts that illustrate trends in the data. For example , here, we expand our diagram to show trend of grocery delivery across time periods.

Enhanced Table/Matrix Visualization - Sparkline

As active dashboard components, the Matrix visuals hold a place of their own. However, it allows a prodigious amount of experimentation to explore suspected relationships or correlation between categories – something that a Table visualization may not reveal in itself.

Sophisticated matrices also break through two dimensional limitations and provide drill down capabilities.

Wrapping it Up

In conclusion, the Table and the Matrix, in all their variations, are fundamental to data visualization. They are essentially variants of the same idea: manipulation of a basic row vs column record set. They are often used when standard charts are not enough to provide enough information around a specific context.


Inforiver Logo
About Inforiver!

Inforiver delivers the fastest way to build collaborative reports in Power BI through a seamless low-code / no-code experience. The product is developed by Lumel Technologies, which has a decade of experience in building visualization products including ValQ, xViz and BI Hub.
ValQ
BI Hub
xViz
5920 Windhaven Pkwy, #130
Plano TX 75093
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram