Heatmap Visualize Relationships With Days Sales Outstanding

Use Scatterplot to visualize days sales outstanding by multiple categorical variables.

This example applies to the Supply Chain Module. For more information, go to www.minitab.com/supply-chain-module.

Example

Days sales outstanding (DSO) is the average number of days to collect payment for a sale.

In this worksheet, DSO is the graph variable. Product is the row variable. Quarter and Auto Invoice are the column variables.

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Cycle Time, select Days sales outstanding.
Select Visualize relationships with days sales outstanding, then click OK.
Select Heatmap, then click OK.
From Display, select Function of a variable.
In Graph variables enter the column that contains the days sales outstanding data.
From Function, select the function of days sales outstanding. For example, if you select Mean, the color gradient of the rectangles in the heatmap uses the mean value of days sales outstanding in each rectangle.
In Row variables enter up to five columns that define the rows.
In Column variables enter up to five columns that define the columns.
Click OK.

For more information about this analysis, click Help in the main dialog box.