I am a sucker for a cool data visualization. However, last week, a friend, who works at Amazon, reminded me about the importance of plain numbers. Amazon famously despises PowerPoint presentations and prioritizes written narratives in their communications and I love it. Also, I'll do anything not to make a useless PowerPoint presentation again.
To prioritize plain numbers and narratives in reporting, you may have to use more tables. So, let me show you how to present attractive tables.
This week's video actually aligns with this post 😅
Let's start with a basic data table
We want to spice the table up and present it in a report. There are several storytelling guidelines to consider here, such as target audience, but I don't want to get into that now. For this exercise, we will assume the audience is interested in the trend in cases and deaths in the calendar year, and they want to see the data in a table.
Disclaimer: My prescriptions are subjective, so follow along if you dare
Change table orientation
To show the trend in the cases and deaths in the calendar year, I start by changing the orientation of the table by copying the table, right-clicking, and pasting it in transpose
Our new table looks like this ⬇️. In this format, we can see the trends better.
Rules for formatting tables
Format your tables with these rules (remember my disclaimer about subjectivity and drink this KoolAid)
Left align text
Right align numbers
The column headers should match the alignment of the content in the column. For example, the column header for a column with numbers should be right-aligned
Use consistent number formatting throughout. Our sample table does not show this well, but if you decide to use commas after every 3 digits like this (1,546), then do it consistently throughout the table. If you have decimals, use the same number of decimal places throughout
Use sentence case. For example, "Grand total" instead of "Grand Total"
Following the rules above, our table should look like this now ⬇️
Declutter
We declutter so we can focus attention on specific aspects of the data. I learned a great technique from Storytelling with data about focusing attention: starting with grey! Grey everything out and then start intentionally deciding which features should stand out.
I select the entire table and make all borders and text grey
I add 2 extra columns for Trend and Grand total
To learn how to insert the sparklines in the Trend column, watch the video below ⬇️. Do not worry, I have it starting at the exact point you need 😉 (if not, skip to 04:31🙏🏾)
I remove all the borders (patience pays 😅)
Focus attention
We only want to add additional ink where it is necessary. I add a border to separate the months from the rest of the data. We are almost there 😍
Because I am interested in the trend of cases and deaths in the calendar year, I bold Cases, Deaths, and their totals.
We are done!
Let's compare the 2 tables now. Which do you prefer?
Conclusion
You will have to present your data in a tabular form at some point in your career. Make it look good.
Have a great week!
Comentarios