#SWDChallenge; 2019 October

This month I’m participating in the #SWDchallenge. We are given a small table. 5 rows and 5 columns.

Question 1: Review the data in the figure. What observations can you make? Do you have to make any assumptions when interpreting this data? What Questions do you have about the data?

Answer 1: First thing I did was checking if the columns with the percentages where adding up to 100. Both columns did not, so I made new columns and removed the old ones. I assume Tier A+ is an improved version of Tier A. I want to know the price per account.

Question 2: Consider the layout of the table in the figure. Let’s assume you’ve been told this information must be communicated in a table. Are there any changes you would make to the way the data is presented or the overall manner in which the table is designed?

Answer 2: I only moved Tier A+ to the top and kept the rest of the row design the same. I have added the column Price per account ($K) before showing the Revenue ($M). I made all columns the same width and wrapped the text of the top bar.

Question 3: Let’s assume the main comparison you want to make is between how accounts are distributed across the tiers compared to how revenue is distributed and that you have the freedom to make bigger changes (it’s not required to be a table). How would you visualize this data? Create a graph in the tool of your choice.

Answer 3: I will use PowerBI as the tool of my choice and start with loading the original data. I added 3 columns in PowerBI using DAX formulas.

% Revenue =
DIVIDE ( 'EXERCISE 2 1'[Revenue ($M)]; SUM ( 'EXERCISE 2 1'[Revenue ($M)] ) )

% Accounts =
DIVIDE ( 'EXERCISE 2 1'[# of Accounts]; SUM ( 'EXERCISE 2 1'[# of Accounts] ) )

Price per account =
    DIVIDE ( 'EXERCISE 2 1'[Revenue ($M)]; 'EXERCISE 2 1'[# of Accounts] ) * 1000;

I have chosen for the default colour theme and then in two colours of blue.

The chart is called a line and column chart. In the column I have put the percentage of accounts and the line is showing the percentage of revenue. With a sort in the highest # of accounts first. In the tooltip you can read how many accounts are in that % of accounts.

This is my visualisation: